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
CopyMemoryCorruptionCountFiles
CountFoldersCountNodesCrash
CreateDCCreateFontIndirectCreateWindowEx
Create A New Disambiguation Page (HowTo)Create a Help Topic (HowTo)Create a Subform with Alternating Color Rows
Creating MDE, ADE, and ACCDE FilesCreative Commons License FAQCurrency: an underestimated Type (Money with Sql-Server)
CursorsDAODDMMSStoDD
DSN-Less Connection
Dab:SampleData Analysis for the Faint of Heart
Data MacroData Modeling
Data Source NamesData ValidationDatatype
Date/Time FunctionsDateDiff() and the "w" intervalDate Pickers
Debatable Content (Template Help)DebuggingDecompile
DeleteDCDeleteLinkedTablesDeleteObject
Deleting RecordsDestroyWindow
DirectoryExistsDispatchMessageDisplay Related Data
Document AssembliesDocument Data MacrosDocument Form RecordSource to Word
Document Query SQL to WordDocument Report RecordSource to WordDomain Functions
DownloadBinaryDrawText
Duplicate Values and Unique ValuesDynamic Charting
Dynamic SQLDynamically Resize Continuous Dialog Form To Match Number Of RecordsEnableMenuItem
EnumChildWindowsEnviron() FunctionEqualGrouping
Error CodesError HandlingError Handling (Global)
European Date ConversionEvalMixedNum
ExpandEnvironmentStringsExpandEnvironmentVariableString
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
GetMessageGetMinArrayValueGetNthPart
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
QuoteFixQxXMLRDBMS
RPadRandomNumbersRandom Name Generator
Randomize A StringReadTextFileRebuild
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:bookmarksSaveStringAsFileSchedule 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
SleepMilliSecondsSliding 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
UPDATE
URLEncodeUnbound ControlUndeleteTables
Unexpected Type MismatchUnitsOfMeasureUse F11 to Show/Hide Navigation Pane
User Defined Types
User Level SecurityUsing ADO
VTools AddIns
ValidateUKPostCodeVariables
VbConstantVerifyFileVista Access 2007 And Any Earlier Version
Visual Basic for ApplicationsWANWNetGetConnection
WNetGetUserWeb Enabled AccessWebpageToString
WikiModeratorsWinHelp
Wizard DesignWork Hours - NetWorkHoursWrapText
XML and Access: Working with Huge FilesXlmFileXmlToXls
XsdCTSequenceYourFunctionNameYour new page name
Custom Search


Thank you for your support!
Disclaimers