UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Menu
Content

. Home
. Articles
. Function Library
. Class Library
. API Declarations
. Error Codes
. Featured Content

Resources

. Wiki FAQ
. Wiki Help
. Markup Listing
. Create Article
. Guidelines
. Templates

To Do

. Completion Required
. Review Required
. Wanted Pages
. Dead End Pages

Toolbox

. Upload file
. Special pages

Advertisment

> All articles    
Display pages starting at:
All pages

13 - Type Mismatch2007 Interactive Command Reference
3061 - Too few parameters, expected N49 - Bad DLL Calling Convention
AAFOAAFO Videos
ACEACE SQL BodyACE SQL Extensions
ACE SQL FunctionsADO
APIASCII Codes
AccessAccess: What Is It?Access: What Is It For Newcomers?
Access 2000 Replication FAQAccess 2003 - Set Form Under ControlAccess 2007 and Sub Menus
Access 2007 and the Ribbon - It's no big dealAccess 97: Ole server may not be registeredAccess 97 Form Events And When They Occur
Access Basics TutorialAccess Controls (Definitions)Access Custom Right-click Menu
Access HistoryAccess LimitsAccess Links
Access Object ModelAccess On Other PlatformsAccess Queries And More
Access ServicesAccess Web AppAccess Web Database
Access and the web HTML Object LibraryAccess wiki - Access Help and How-to - Microsoft Office :CopyrightsAccess wiki - Access Help and How-to - Microsoft Office :General disclaimer
Accessor
Action Queries
Add-insAddTrustedLocation
Add A User Defined Function To ExcelAdd Your Page to an Existing Disambiguation Page (HowTo)Add a Function Library Entry (HowTo)
Add a Page To Review and Completion List (HowTo)Add a Wiki Article (HowTo)Anomalies: Insert, Update and Delete
ArrayToExcelArray FormulasArray Sort in VBA
ArraysArticle Layout ExamplesArticle Layout Guidelines
Article Layout Guidelines (Compact)Asynchronous HTTP Request ClassAutoNum
AutonumbersAzure
BLOOKUP a Binary Lookup For Excel
Backup
Base Ten to Base LetterBeginners Guide To ODBC
BindingBookmarkProperty
Bound
BuildInClauseBuildNameButton (Stock)
ByVal vs ByRefCRUD
Calculated Data Types Microsoft Access 2010Caller
Calling Action QueriesCamelCase
Cascading Combo Boxes
Cascading Dropdown Lists (Non-VBA)Cascading Dropdown Lists (VBA)
Categories of ApplicationsChangeFileExtensionChoosing between DAO and ADO
Classes
CloseAllFormsCloseDesignFormsCloud Computing
Code ArchiveCollection Class
Combo Box
Combobox (Stock)Combobox NotInList Event
Command-Line SwitchesCompact and RepairCompact and Repair Database over a Network
Compiler DirectivesComposite Indexes vs Composite Primary Keys
Connection String
Content For ReviewContinuous Forms: Highlight Current RowControl Stock Gallery
ConvertQuoteConvertToWordDocCopyFile
CopyMemoryCorruptionCountNodes
CrashCreateDCCreateFontIndirect
CreateWindowExCreate A New Disambiguation Page (HowTo)Create a Help Topic (HowTo)
Create a Subform with Alternating Color RowsCreating MDE, ADE, and ACCDE FilesCreative Commons License FAQ
Currency: an underestimated Type (Money with Sql-Server)CursorsDAO
DDMMSStoDDDSN-Less Connection
Dab:Sample
Data Analysis for the Faint of HeartData Macro
Data ModelingData Source NamesData Validation
DatatypeDate/Time FunctionsDateDiff() and the "w" interval
Date PickersDebatable Content (Template Help)Debugging
DecompileDeleteDCDeleteLinkedTables
DeleteObjectDeleting RecordsDestroyWindow
DirectoryExistsDispatchMessage
Display Related DataDocument AssembliesDocument Data Macros
Document Form RecordSource to WordDocument Query SQL to WordDocument Report RecordSource to Word
Domain FunctionsDownloadBinaryDrawText
Duplicate Values and Unique ValuesDynamic Charting
Dynamic SQLDynamically Resize Continuous Dialog Form To Match Number Of Records
EnableMenuItemEnumChildWindowsEnviron() Function
EqualGroupingError CodesError Handling
Error Handling (Global)European Date ConversionEvalMixedNum
ExpandEnvironmentStrings
ExpandEnvironmentVariableStringExpanding a Hierarchical Data Structure
ExportToCSVExpressionExpression Service
FL Usage
Fat databaseFeatured ContentField
FileExistsFileToByteArrayFileToString
File ExtensionsFilter FieldFindWindow
FindWindowExFind Missing Dates or Numbers within a RangeFind Record
FirstDayOfCurrentWeekFirstDayOfWeekFirstLines
First Last Nth OccuranceFiscalStartFixQuotes
FixTextFixText DigitsFixText Letters
FormForm Design 101
Form Event QuirksForm FiltersForm and Report Templates
Form splitter controlFormatting CodeFractionsAsText
FreeLibrary
Frustrated Join
FunctionLibrary:Comparing strings with accentsFunctionLibrary:FixQuotesFunctionLibrary:Self-Healing Object Variables
GetActiveDirectoryFullNameGetActiveWindow
GetAlphaOnlyGetAncestorGetBEFolder
GetClassNameGetClientRectGetCurrentControlValue
GetCurrentThreadIdGetDCGetDesktopWindow
GetDeviceCapsGetDigitsOnlyGetDirContents
GetFileExtensionGetFilePathGetFilenameFromPath
GetFocusGetKeyMasksGetLastDayOfMonth
GetLinkTargetGetListItemGetMaxArrayValue
GetMemberGetMessageGetMinArrayValue
GetOpenFileNameGetParentGetProfileString
GetQueryCriteriaGetRecordValuesGetSQLRecordcount
GetSaveFileNameGetStrOccurrencesGetSummaryInfo
GetSystemMenuGetSystemMetricsGetTempFileName
GetTempPathGetTextMetricsGetUnicodeFileIntoArray
GetVersionExGetWinCalcVal2GetWindowLongPtr
GetWindowRectGetWindowTextGetting Ready To Backup An Access Database (97 upwards)
Global VariablesGoogle Map UtilityGracePeriodValid
HL7 To XMLHash
HideNavigationPane
How To Open Windows XP Regional Settings In CodeHttpRequest ClassHyperlink (Stock)
HyperlinksIF AND OR NOTIS
I Am AnonymousIaaSIdentity
Immediate WindowImported Data
InStrRevIncrementDomainIndex.php
IndexesInstanceIs64BitOffice
IsActiveControlIsAllCapsIsAlphaOnly
IsArrayInitializedIsBooleanIsFolderEmpty
IsFractionIsIn Find an Item in a ListIsMixedNumber
IsNumbersOnlyIsObjectOpenIsParentForm
IsQueryIsSubformIsSubformFocus
IsTableIsWindowVisibleIsWordUnique
Jet
Jet Sandbox ModeJunction Tables (Many-to-Many Relationships)
KeyNavigatorKeyboard UI Design
KillTimer
LPadLabel (Stock)Labels: Attach And Detach
LastDayOfCurrentWeekLastDayOfWeekLastLines
Last Row or Column Without VBALibrary Databases
LimitationsLinked ListLinked Table Operations
Linked tableLinks
ListDeleteRecordListFindFormTableListInitialize
ListNewRecordListRenumber
List BoxesListbox (Stock)Lists
LoadLibraryLocalUserLocking Behavior
Login SecurityLong IntegerLookup Table
Looping Through A Range Of Cells In VBALorem Ipsum
MS Query
MainMain Page
MakeMyQueryMakeTestQueryMake Table
MaxIf - MinIf AverageIfMenu Bar
Menu Bar VBEMerging Multiple QueriesMessage Engine
Messaging SystemMessengerMicrosoft-Access-User-Limitations
MoveMemoryMoveWindowMsg Structure
MulDivMultiValue Combobox (Stock)MultiValue Listbox (Stock)
Myths About Access FE With ODBC BE
Naming ConventionsNatural Vs Surrogate Keys
NewGUID
News:2011-04-01News:2011-05-10News:2011-05-15
News:2011-12-09News:2012-01-11News:2012-01-14
News:2012-01-15News:2012-01-18News:2012-08-28
News:FeedHistoryNodeNormalization
Normalization Terms and ConceptsNormalizing A DatabaseNormalizing Existing Data
NthDowInMonthVBANulls And Their Behavior
Number of Mondays in a Date RangeNumbers Stored as Text - Text Stored as NumbersNumericDateEntry
NumericInputODBCODBC Connection VBA Code
OSVersionInfo StructureObject ExistsOffset and Dynamic Ranges
On-premise
Once-off QueriesOpenFileName Structure
Opening Files From Access
Option ExplicitOption Group (Stock)
Options DesignOrganize Code and Reference InfoOutputModules
Overview of Packaging Access 2003 ApplicationsPaaS
Page Break (Stock)Page NotificationsPage Numbering by Group
Parameter Query
ParseHyperlinkFieldParsePrintNumberRangePass And Return Variables
People NamesPerformance FAQPerformance Forms
Performance LDB LockingPivot TablesPlaintext
Point StructurePopup CalendarPortingAndWikiCheatSheet
PowerPoint from ExcelPrimary Key and Foreign Key
PrintModuleNamesToImmediate
ProcedureProductivity Tips
Progress MeterQuery
Query existQueueQueueFields
QxXMLRDBMSRPad
RandomNumbersRandom Name GeneratorRandomize A String
RebuildRecordRecord Key
Record OrderRecords Within A Defined Range
RecordsetRecordsets for Beginners
RecordsourceRecover Corrupt or Broken Database ObjectsRecursion
Reference a control's labelReferencesReferential Integrity
Referring To Properties And Controls On SubformsRegCloseKeyRegCreateKeyEx
RegDeleteKeyRegDeleteValueRegEnumKeyEx
RegEnumValueRegOpenKeyExRegQueryInfoKey
RegQueryValueExRegSetValueEx
RelatedContent (Template Help)Relationship Diagrams of Access 2010 Web Database templatesRelationships
ReleaseDCRemSpecialRemoveMenu
RemoveSalutationFromFullNameRemove extra spacesRemoving Non-Printable Characters from Data
ReplaceEWQReplaceREReplaceViaPosition
ReplicationReplication Wiki Frequently Asked Jet Replication Questions (FAQ)Report
ReportRevisionDateReports Alternating Row Colors
Reports Blank PagesRequired ControlsReserved Words
Reserved Words In AccessRgltestRibbon
Ribbon DesignRibbon Design An IntroductionRibbon Home (Stock)
Ribbon Stock GalleryRibbon XML Control Codes
RoundToNearestRoundToNextRound Robin Schedule Creator Demo
Route Google Map From AccessRowSourceRunSQL vs Execute
RunTimeRunning SumsSELECT
SHBrowseForFolderSHDeleteKeySHGetPathFromIDList
SQLSQL AzureSQL Query
SQL Reserved WordsSQL ServerSQL to VBA
SaaSSampleSizeSanbox for TonyHine
Sandbox:TestSandbox: AG testing embed videosSandbox: demo embed video
Sandbox: embed videoSandbox:bookmarksSchedule a Macro to Run
ScopeSecurity Attribute StructureSelectDB
SelectObjectSelect Ribbon TabSelect queries
SelectedItemsListSelf-Healing Object VariablesSendMessage
SentenceCaseRESequential NumberingSequential Numbering in Queries and Subforms
SetAllAutocorrectsOffSetFocusSetForegroundWindow
SetSubDatasheetNoneSetTabCycleSetTimer
SetWindowLongPtrSetWindowPos
SharePointSharePoint farmSharing
ShellExecuteShell Form User InterfaceShowMarkup (Template Help)
ShowWindowShowWindow ConstantsShrink Textbox and Corresponding Label in the Absence of Data
SignatureSingleton
Sleep
Sliding Indicator ControlsSorting TextSplitOnCount
SplitXml
SqlsToExcelStackStack (Discussion)
StartupStoring Calculated Values and Audit TrailsStringToFile
Strip Illegal CharactersStrip Unwanted Characters
Summing elapsed time that could go over 24 hoursSurrogate key
SysVerifyPathExistsSys AC VerifyDbMaxSize
Sys AC VerifyDriveExistsSys AC VerifyDriveFreeSpaceInMBSys AC VerifyDriveIsReady
Sys AC VerifyDriveLocationTable
TableexistsTables in Excel
TempVarsText Formatting GuidelinesTextbox (Stock)
Thin Client ConsiderationsTimerProc Callback
ToFileNameToXmlHexToggle Button (Stock)
Tony Hine
ToolbarsTools and Add-InsTracking A Textbox Cursor
TransferSQLDBTranslateMessageTransposing Data With The Offset Function
TrimLeadingZeroTrusted Locations
TypeOfUA Wiki Contributor ResourcesUA Wiki Guidelines
UA Wiki Sitemap
UPDATEURLEncode
Unbound ControlUndeleteTablesUnexpected Type Mismatch
UnitsOfMeasureUse F11 to Show/Hide Navigation Pane
User Defined TypesUser Level Security
Using ADO
VTools AddInsValidateUKPostCode
VariablesVbConstant
VerifyFileVista Access 2007 And Any Earlier VersionVisual Basic for Applications
WANWNetGetConnectionWNetGetUser
Web Enabled AccessWebpageToString
WikiModeratorsWinHelpWizard Design
Work Hours - NetWorkHoursWrapTextXML and Access: Working with Huge Files
XlmFileXmlToXlsXsdCTSequence
YourFunctionNameYour new page name
Custom Search
Thank you for your support!
Disclaimers