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
GetNthPartGetOpenFileNameGetParent
GetProfileStringGetQueryCriteriaGetRecordValues
GetSQLRecordcountGetSaveFileNameGetStrOccurrences
GetSummaryInfoGetSystemMenuGetSystemMetrics
GetTempFileNameGetTempPathGetTextMetrics
GetUnicodeFileIntoArrayGetVersionExGetWinCalcVal2
GetWindowLongPtrGetWindowRectGetWindowText
Getting Ready To Backup An Access Database (97 upwards)Global VariablesGoogle Map Utility
GracePeriodValidHL7 To XMLHash
HideNavigationPaneHow To Open Windows XP Regional Settings In CodeHttpRequest Class
Hyperlink (Stock)HyperlinksIF AND OR NOT
ISI Am AnonymousIaaS
IdentityImmediate Window
Imported DataInStrRevIncrementDomain
Index.phpIndexesInstance
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)
Labels: Attach And DetachLastDayOfCurrentWeekLastDayOfWeek
LastLinesLast Row or Column Without VBA
Library DatabasesLimitationsLinked List
Linked Table OperationsLinked tableLinks
ListDeleteRecordListFindFormTable
ListInitializeListNewRecordListRenumber
List BoxesListbox (Stock)
ListsLoadLibraryLocalUser
Locking BehaviorLogin SecurityLong Integer
Lookup TableLooping Through A Range Of Cells In VBA
Lorem Ipsum
MS QueryMainMain Page
MakeMyQueryMakeTestQuery
Make TableMaxIf - MinIf AverageIf
Menu BarMenu Bar VBEMerging Multiple Queries
Message EngineMessaging SystemMessenger
Microsoft-Access-User-LimitationsMoveMemoryMoveWindow
Msg StructureMulDivMultiValue Combobox (Stock)
MultiValue Listbox (Stock)
Myths About Access FE With ODBC BENaming Conventions
Natural Vs Surrogate Keys
NewGUIDNews:2011-04-01News:2011-05-10
News:2011-05-15News:2011-12-09News:2012-01-11
News:2012-01-14News:2012-01-15News:2012-01-18
News:2012-08-28News:FeedHistoryNode
NormalizationNormalization Terms and ConceptsNormalizing A Database
Normalizing Existing DataNthDowInMonthVBA
Nulls And Their BehaviorNumber of Mondays in a Date RangeNumbers Stored as Text - Text Stored as Numbers
NumericDateEntryNumericInputODBC
ODBC Connection VBA CodeOSVersionInfo StructureObject Exists
Offset and Dynamic RangesOn-premise
Once-off QueriesOpenFileName Structure
Opening Files From Access
Option ExplicitOption Group (Stock)
Options DesignOrganize Code and Reference Info
OutputModulesOverview of Packaging Access 2003 Applications
PaaSPage Break (Stock)Page Notifications
Page Numbering by Group
Parameter Query
ParseHyperlinkFieldParsePrintNumberRange
Pass And Return VariablesPeople NamesPerformance FAQ
Performance FormsPerformance LDB LockingPivot Tables
PlaintextPoint StructurePopup Calendar
PortingAndWikiCheatSheetPowerPoint from Excel
Primary Key and Foreign KeyPrintModuleNamesToImmediate
Procedure
Productivity TipsProgress Meter
QueryQuery existQueue
QueueFieldsQuoteFixQxXML
RDBMSRPadRandomNumbers
Random Name GeneratorRandomize A StringReadTextFile
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:bookmarksSaveStringAsFile
Schedule a Macro to RunScopeSecurity Attribute Structure
SelectDBSelectObjectSelect Ribbon Tab
Select queriesSelectedItemsListSelf-Healing Object Variables
SendMessageSentenceCaseRESequential Numbering
Sequential Numbering in Queries and SubformsSetAllAutocorrectsOffSetFocus
SetForegroundWindowSetSubDatasheetNoneSetTabCycle
SetTimerSetWindowLongPtr
SetWindowPosSharePointSharePoint farm
SharingShellExecuteShell Form User Interface
ShowMarkup (Template Help)ShowWindowShowWindow Constants
Shrink Textbox and Corresponding Label in the Absence of DataSignature
Singleton
SleepSleepMilliSecondsSliding Indicator Controls
Sorting TextSplitOnCountSplitXml
SqlsToExcel
StackStack (Discussion)Startup
Storing Calculated Values and Audit TrailsStringToFileStrip Illegal Characters
Strip Unwanted CharactersSumming elapsed time that could go over 24 hours
Surrogate key
SysVerifyPathExistsSys AC VerifyDbMaxSizeSys AC VerifyDriveExists
Sys AC VerifyDriveFreeSpaceInMBSys AC VerifyDriveIsReadySys AC VerifyDriveLocation
Table
TableexistsTables in ExcelTempVars
Text Formatting GuidelinesTextbox (Stock)Thin Client Considerations
TimerProc CallbackToFileName
ToXmlHexToggle Button (Stock)
Tony Hine
Toolbars
Tools and Add-InsTracking A Textbox CursorTransferSQLDB
TranslateMessageTransposing Data With The Offset FunctionTrimLeadingZero
Trusted LocationsTypeOf
UA Wiki Contributor ResourcesUA Wiki GuidelinesUA Wiki Sitemap
UPDATEURLEncodeUnbound Control
UndeleteTablesUnexpected Type MismatchUnitsOfMeasure
Use F11 to Show/Hide Navigation Pane
User Defined TypesUser Level SecurityUsing ADO
VTools AddInsValidateUKPostCode
VariablesVbConstantVerifyFile
Vista Access 2007 And Any Earlier VersionVisual Basic for ApplicationsWAN
WNetGetConnectionWNetGetUserWeb Enabled Access
WebpageToStringWikiModerators
WinHelpWizard DesignWork Hours - NetWorkHours
WrapTextXML and Access: Working with Huge FilesXlmFile
XmlToXlsXsdCTSequenceYourFunctionName
Your new page name
Custom Search


Thank you for your support!
Disclaimers