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 2000 Replication FAQ
Access 2003 - Set Form Under ControlAccess 2007 and Sub MenusAccess 2007 and the Ribbon - It's no big deal
Access 97: Ole server may not be registeredAccess 97 Form Events And When They OccurAccess Basics Tutorial
Access Controls (Definitions)Access Custom Right-click MenuAccess History
Access LimitsAccess LinksAccess Object Model
Access On Other PlatformsAccess Queries And MoreAccess Services
Access Web AppAccess Web DatabaseAccess and the web HTML Object Library
Access wiki - Access Help and How-to - Microsoft Office :CopyrightsAccess wiki - Access Help and How-to - Microsoft Office :General disclaimer
Accessor
Action Queries
Add-insAddTrustedLocationAdd A User Defined Function To Excel
Add 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
ArrayToExcel
Array FormulasArray Sort in VBAArrays
Article Layout ExamplesArticle Layout GuidelinesArticle Layout Guidelines (Compact)
Asynchronous HTTP Request ClassAutoNum
AutonumbersAzure
BLOOKUP a Binary Lookup For Excel
BackupBase Ten to Base Letter
Beginners Guide To ODBCBinding
BookmarkProperty
BoundBuildInClause
BuildNameButton (Stock)ByVal vs ByRef
CRUDCalculated Data Types Microsoft Access 2010
CallerCalling Action Queries
CamelCase
Cascading Combo Boxes
Cascading Dropdown Lists (Non-VBA)Cascading Dropdown Lists (VBA)Categories of Applications
ChangeFileExtensionChoosing between DAO and ADO
ClassesCloseAllForms
CloseDesignFormsCloud Computing
Code ArchiveCollection Class
Combo Box
Combobox (Stock)Combobox NotInList EventCommand-Line Switches
Compact and RepairCompact and Repair Database over a NetworkCompiler Directives
Composite Indexes vs Composite Primary Keys
Connection StringContinuous Forms: Highlight Current Row
Control Stock GalleryConvertQuoteConvertToWordDoc
CopyFileCopyMemoryCorruption
CountNodesCrashCreateDC
CreateFontIndirectCreateWindowExCreate A New Disambiguation Page (HowTo)
Create a Help Topic (HowTo)Create a Subform with Alternating Color RowsCreating MDE, ADE, and ACCDE Files
Creative Commons License FAQCurrency: an underestimated Type (Money with Sql-Server)Cursors
DAODDMMSStoDD
DSN-Less ConnectionDab:Sample
Data Analysis for the Faint of HeartData Macro
Data ModelingData Source Names
Data ValidationDate/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
Expanding a Hierarchical Data StructureExportToCSV
ExpressionExpression Service
FL UsageFat database
Featured ContentFieldFileExists
FileToByteArrayFileToStringFile Extensions
Filter FieldFindWindowFindWindowEx
Find Missing Dates or Numbers within a RangeFind RecordFirstDayOfCurrentWeek
FirstDayOfWeekFirstLinesFirst Last Nth Occurance
FiscalStartFixQuotesFixText
FixText DigitsFixText Letters
FormForm Design 101Form Event Quirks
Form FiltersForm and Report TemplatesForm splitter control
Formatting CodeFractionsAsTextFreeLibrary
Frustrated Join
FunctionLibrary:Comparing strings with accents
FunctionLibrary:FixQuotesFunctionLibrary:Self-Healing Object Variables
GetActiveDirectoryFullNameGetActiveWindowGetAlphaOnly
GetAncestorGetBEFolderGetClassName
GetClientRectGetCurrentControlValueGetCurrentThreadId
GetDCGetDesktopWindowGetDeviceCaps
GetDigitsOnlyGetDirContentsGetFileExtension
GetFilePathGetFilenameFromPathGetFocus
GetKeyMasksGetLastDayOfMonthGetLinkTarget
GetListItemGetMaxArrayValueGetMember
GetMessageGetMinArrayValueGetOpenFileName
GetParentGetProfileStringGetQueryCriteria
GetRecordValuesGetSQLRecordcountGetSaveFileName
GetStrOccurrencesGetSummaryInfoGetSystemMenu
GetSystemMetricsGetTempFileNameGetTempPath
GetTextMetricsGetUnicodeFileIntoArrayGetVersionEx
GetWinCalcVal2GetWindowLongPtrGetWindowRect
GetWindowTextGetting Ready To Backup An Access Database (97 upwards)Global Variables
Google Map UtilityGracePeriodValidHL7 To XML
Hash
HideNavigationPaneHow To Open Windows XP Regional Settings In Code
HttpRequest ClassHyperlink (Stock)Hyperlinks
IF AND OR NOTISI Am Anonymous
IaaSIdentity
Immediate WindowImported DataInStrRev
IncrementDomainIndexesInstance
Is64BitOfficeIsActiveControlIsAllCaps
IsAlphaOnlyIsArrayInitializedIsBoolean
IsFolderEmptyIsFractionIsIn Find an Item in a List
IsMixedNumberIsNumbersOnlyIsObjectOpen
IsParentFormIsQueryIsSubform
IsSubformFocusIsTableIsWindowVisible
IsWordUnique
Jet
Jet Sandbox Mode
Junction Tables (Many-to-Many Relationships)KeyNavigator
Keyboard UI DesignKillTimer
LPadLabel (Stock)
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 SystemMicrosoft-Access-User-LimitationsMoveMemory
MoveWindowMsg StructureMulDiv
MultiValue Combobox (Stock)MultiValue Listbox (Stock)
Myths About Access FE With ODBC BE
Naming ConventionsNatural Vs Surrogate Keys
NewGUIDNews:2011-04-01
News:2011-05-10News:2011-05-15News:2011-12-09
News:2012-01-11News:2012-01-14News:2012-01-15
News:2012-01-18News:2012-08-28News:FeedHistory
NodeNormalizationNormalization Terms and Concepts
Normalizing A DatabaseNormalizing Existing DataNthDowInMonthVBA
Nulls And Their BehaviorNumber of Mondays in a Date Range
Numbers Stored as Text - Text Stored as NumbersNumericDateEntryNumericInput
ODBCODBC Connection VBA CodeOSVersionInfo Structure
Object ExistsOffset and Dynamic RangesOn-premise
Once-off Queries
OpenFileName Structure
Opening Files From AccessOption Explicit
Option Group (Stock)Options Design
Organize Code and Reference InfoOutputModulesOverview of Packaging Access 2003 Applications
PaaSPage Break (Stock)
Page NotificationsPage Numbering by Group
Parameter Query
ParseHyperlinkField
ParsePrintNumberRangePass And Return VariablesPeople Names
Performance FAQPerformance FormsPerformance LDB Locking
Pivot TablesPlaintextPoint Structure
Popup CalendarPortingAndWikiCheatSheetPowerPoint from Excel
Primary Key and Foreign Key
PrintModuleNamesToImmediateProcedure
Productivity TipsProgress Meter
QueryQuery exist
QueueQueueFieldsQxXML
RDBMSRPadRandomNumbers
Random Name GeneratorRandomize A StringRebuild
RecordRecord KeyRecord Order
Records Within A Defined RangeRecordset
Recordsets for BeginnersRecordsource
Recover Corrupt or Broken Database ObjectsRecursionReference a control's label
ReferencesReferential IntegrityReferring To Properties And Controls On Subforms
RegCloseKeyRegCreateKeyExRegDeleteKey
RegDeleteValueRegEnumKeyExRegEnumValue
RegOpenKeyExRegQueryInfoKeyRegQueryValueEx
RegSetValueExRelatedContent (Template Help)
Relationship Diagrams of Access 2010 Web Database templatesRelationshipsReleaseDC
RemSpecialRemoveMenuRemoveSalutationFromFullName
Remove extra spacesRemoving Non-Printable Characters from DataReplaceEWQ
ReplaceREReplaceViaPositionReplication
Replication Wiki Frequently Asked Jet Replication Questions (FAQ)ReportReportRevisionDate
Reports Alternating Row ColorsReports Blank Pages
Required ControlsReserved WordsReserved Words In Access
RgltestRibbonRibbon Design
Ribbon Design An IntroductionRibbon Home (Stock)Ribbon Stock Gallery
Ribbon XML Control CodesRoundToNearest
RoundToNextRound Robin Schedule Creator DemoRoute Google Map From Access
RowSourceRunSQL vs ExecuteRunTime
Running SumsSELECTSHBrowseForFolder
SHDeleteKeySHGetPathFromIDListSQL
SQL AzureSQL QuerySQL Reserved Words
SQL ServerSQL to VBASaaS
SampleSizeSanbox for TonyHineSandbox:Test
Sandbox: AG testing embed videosSandbox: demo embed videoSandbox: embed video
Sandbox:bookmarksSchedule a Macro to RunScope
Security Attribute StructureSelectDBSelectObject
Select Ribbon TabSelect queriesSelectedItemsList
Self-Healing Object VariablesSendMessageSentenceCaseRE
Sequential NumberingSequential Numbering in Queries and SubformsSetAllAutocorrectsOff
SetFocusSetForegroundWindowSetSubDatasheetNone
SetTabCycleSetTimer
SetWindowLongPtrSetWindowPosSharePoint
SharePoint farmSharingShellExecute
Shell Form User InterfaceShowMarkup (Template Help)ShowWindow
ShowWindow ConstantsSignature
Singleton
SleepSliding Indicator ControlsSorting Text
SplitOnCountSplitXml
SqlsToExcelStack
Stack (Discussion)StartupStoring Calculated Values and Audit Trails
StringToFileStrip Illegal CharactersStrip Unwanted Characters
Summing elapsed time that could go over 24 hoursSurrogate key
SysVerifyPathExists
Sys AC VerifyDbMaxSizeSys AC VerifyDriveExistsSys AC VerifyDriveFreeSpaceInMB
Sys AC VerifyDriveIsReadySys AC VerifyDriveLocation
TableTableexists
Tables in ExcelTempVarsText Formatting Guidelines
Textbox (Stock)Thin Client Considerations
TimerProc CallbackToFileNameToXmlHex
Toggle Button (Stock)Tony Hine
ToolbarsTools and Add-Ins
Tracking A Textbox CursorTransferSQLDBTranslateMessage
Transposing Data With The Offset FunctionTrimLeadingZeroTrusted Locations
TypeOfUA Wiki Contributor Resources
UA Wiki GuidelinesUA Wiki Sitemap
URLEncode
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