| A | ||
| Abs. | The absolute value of a number (ignore negative sign). | |
| AddMenu | Add a custom menu bar/shortcut bar. | |
| .AddNew | Add a new record to a recordset. | |
| .ApplyFilter | Apply a filter clause to a table, form, or report. | |
| Array | Create an Array. | |
| Asc | The Ascii code of a character.. | |
| AscW | The Unicode of a character. | |
| Atn | Display the ArcTan of an angle. | |
| Avg | (SQL) Average | |
| B | ||
| .Beep (DoCmd) | Sound a tone. | |
| .BrowseTo(DoCmd) | Navigate between objects. | |
| C | ||
| Call | Call a procedure. | |
| .CancelEvent (DoCmd) | Cancel an event. | |
| .CancelUpdate | Cancel recordset changes. | |
| Case | If Then Else. | |
| CBool | Convert to boolean. | |
| CByte | Convert to byte. | |
| CCur | Convert to currency (number) | |
| CDate | Convert to Date. | |
| CVDate | Convert to Date. | |
| CDbl | Convert to Double (number) | |
| CDec | Convert to Decimal (number) | |
| Choose | Return a value from a list based on position. | |
| ChDir | Change the current directory or folder. | |
| ChDrive | Change the current drive. | |
| Chr. | Return a character based on an ASCII code. | |
| ClearMacroError (DoCmd) | Clear MacroError. | |
| .Close (DoCmd) | Close a form/report/window. | |
| .CloseDatabase (DoCmd) | Close the database. | |
| CInt | Convert to Integer (number) | |
| CLng | Convert to Long (number) | |
| Command | Return command line option string. | |
| .CopyDatabaseFile (DoCmd) |
Copy to an SQL .mdf file. | |
| .CopyObject (DoCmd) | Copy an Access database object. | |
| Cos Display | Cosine of an angle. | |
| Count (SQL) | Count records. | |
| CSng | Convert to Single (number.) | |
| CStr | Convert to String. | |
| CurDir | Return the current path. | |
| CurrentDb | Return an object variable for the current database. | |
| CurrentUser | Return the current user. | |
| CVar | Convert to a Variant. | |
| D | ||
| Date | The current date. | |
| DateAdd | Add a time interval to a date. | |
| DateDiff | The time difference between two dates. | |
| DatePart | Return part of a given date. | |
| DateSerial | Return a date given a year, month, and day. | |
| DateValue | Convert a string to a date. | |
| DAvg | Average from a set of records. | |
| Day | Return the day of the month. | |
| DCount | Count the number of records in a table/query. | |
| Delete (SQL) | Delete records. | |
| .DeleteObject (DoCmd) | Delete an object. | |
| DeleteSetting | Delete a value from the users registry. | |
| .DoMenuItem (DoCmd) | Display a menu or toolbar command. | |
| DFirst | The first value from a set of records. | |
| Dir | List the files in a folder. | |
| Dim | Declare a new variable. | |
| DLast | The last value from a set of records. | |
| DLookup | Get the value of a particular field. | |
| DMax | Return the maximum value from a set of records. | |
| DMin | Return the minimum value from a set of records. | |
| DoEvents | Allow the Operating System to process other events. | |
| DStDev | Estimate Standard deviation for domain (subset of records) | |
| DStDevP | Estimate Standard deviation for population (subset of records) | |
| DSum | Return the sum of values from a set of records. | |
| DVar | Estimate variance for domain (subset of records) | |
| DVarP | Estimate variance for population (subset of records) | |
| E | ||
| .Echo | Turn screen updating on or off. | |
| Environ | Return the value of an OS environment variable. | |
| EOF | End of file input. | |
| Error | Return the error message for an error No. | |
| Eval | Evaluate an expression. | |
| Execute(SQL/VBA) | Execute a procedure or run SQL. | |
| Exp | Exponential e raised to the nth power. | |
| F | ||
| FileDateTime | Filename last modified date/time. | |
| FileLen | The size of a file in bytes. | |
| .FindFirst/Last/ Next/Previous |
Find record | |
| .FindRecord(DoCmd) | Find a specific record. | |
| First (SQL) | Return the first value from a query. | |
| Fix | Return the integer portion of a number. | |
| For | Loop. | |
| Format | Format a Number/Date/Time. | |
| FreeFile | The next file No. available to open. | |
| From | Specify the table(s) to be used in an SQL query. | |
| FV | Future Value of an annuity. | |
| G | ||
| GetAllSettings | List the settings saved in the registry. | |
| GetAttr | Get file/folder attributes. | |
| GetObject | Return a reference to an ActiveX object. | |
| GetSetting | Retrieve a value from the users registry. | |
| form.GoToPage | Move to a page on specific form. | |
| .GoToRecord (DoCmd) | Move to a specific record in a dataset. | |
| H | ||
| Hex | Convert a number to Hex. | |
| Hour | Return the hour of the day. | |
| .Hourglass (DoCmd) | Display the hourglass icon. | |
| HyperlinkPart | Return information about data stored as a hyperlink. | |
| I | ||
| If Then Else | If-Then-Else function. | |
| IIf | If-Then-Else | |
| Input | Return characters from a file. | |
| InputBox | Prompt for user input. | |
| Insert (SQL) | Add records to a table (append query). | |
| InStr | Return the position of one string within another. | |
| InstrRev | Return the position of one string within another. | |
| Int | Return the integer portion of a number. | |
| IPmt | Interest payment for an annuity | |
| IsArray | Test if an expression is an array | |
| IsDate | Test if an expression is a date. | |
| IsEmpty | Test if an expression is Empty (unassigned). | |
| IsError | Test if an expression is returning an error. | |
| IsMissing | Test if a missing expression. | |
| IsNull | Test for a NULL expression or Zero Length string. | |
| IsNumeric | Test for a valid Number. | |
| IsObject | Test if an expression is an Object. | |
| L | ||
| Last (SQL) | Return the last value from a query. | |
| LBound | Return the smallest subscript from an array. | |
| LCase | Convert a string to lower-case. | |
| Left | Extract a substring from a string. | |
| Len | Return the length of a string. | |
| LoadPicture | Load a picture into an ActiveX control. | |
| Loc | The current position within an open file. | |
| .LockNavigationPane (DoCmd) |
Lock the Navigation Pane. | |
| LOF | The length of a file opened with Open() | |
| Log | Return the natural logarithm of a number. | |
| LTrim | Remove leading spaces from a string. | |
| M | ||
| Max (SQL) | Return the maximum value from a query. | |
| .Maximize (DoCmd) | Enlarge the active window. | |
| Mid | Extract a substring from a string. | |
| Min (SQL) | Return the minimum value from a query. | |
| .Minimize (DoCmd) | Minimise a window. | |
| Minute | Return the minute of the hour. | |
| MkDir | Create directory. | |
| Month | Return the month for a given date. | |
| MonthName | Return a string representing the month. | |
| .Move | Move through a Recordset. | |
| .MoveFirst/Last/ Next/Previous |
Move to Record. | |
| .MoveSize (DoCmd) | Move or Resize a Window. | |
| MsgBox | Display a message in a dialogue box. | |
| Next | Continue a for loop. | |
| N | ||
| Now | Return the current date and time. | |
| Nz | Detect a NULL value or a Zero Length string. | |
| O | ||
| Oct | Convert an integer to Octal. | |
| OnClick, OnOpen | Events. | |
| .OpenForm (DoCmd) | Open a form. | |
| .OpenQuery (DoCmd) | Open a query. | |
| .OpenRecordset | Create a new Recordset. | |
| .OpenReport (DoCmd) | Open a report. | |
| .OutputTo (DoCmd) | Export to a Text/CSV/Spreadsheet file. | |
| P | ||
| Partition (SQL) | Locate a number within a range. | |
| .PrintOut (DoCmd) | Print the active object (form/report etc.) | |
| Q | ||
| Quit | Quit Microsoft Access | |
| R | ||
| .RefreshRecord (DoCmd) | Refresh the data in a form. | |
| .Rename (DoCmd) | Rename an object. | |
| .RepaintObject (DoCmd) | Complete any pending screen updates. | |
| Replace | Replace a sequence of characters in a string. | |
| .Requery | Requery the data in a form or a control. | |
| .Restore (DoCmd) | Restore a maximized or minimized window. | |
| RGB | Convert an RGB colour to a number. | |
| Right | Extract a substring from a string. | |
| Rnd | Generate a random number. | |
| Round | Round a number to n decimal places. | |
| RTrim | Remove trailing spaces from a string. | |
| .RunCommand | Run an Access menu or toolbar command. | |
| .RunDataMacro (DoCmd) | Run a named data macro. | |
| .RunMacro (DoCmd) | Run a macro. | |
| .RunSavedImportExport (DoCmd) |
Run a saved import or export specification. | |
| .RunSQL (DoCmd) | Run an SQL query. | |
| S | ||
| .Save (DoCmd) | Save a database object. | |
| SaveSetting | Store a value in the users registry | |
| .SearchForRecord(DoCmd) | Search for a specific record. | |
| Second | Return the seconds of the minute. | |
| Seek | The position within a file opened with Open. | |
| Select (SQL) | Retrieve data from one or more tables or queries. | |
| Select Into (SQL) | Make-table query. | |
| Select-Subquery (SQL) | SubQuery. | |
| .SelectObject (DoCmd) | Select a specific database object. | |
| .SendObject (DoCmd) | Send an email with a database object attached. | |
| SendKeys | Send keystrokes to the active window. | |
| SetAttr | Set the attributes of a file. | |
| .SetDisplayedCategories (DoCmd) |
Change Navigation Pane display options. | |
| .SetFilter (DoCmd) | Apply a filter to the records being displayed. | |
| SetFocus | Move focus to a specified field or control. | |
| .SetMenuItem (DoCmd) | Set the state of menubar items (enabled /checked) | |
| .SetOrderBy (DoCmd) | Apply a sort to the active datasheet, form or report. | |
| .SetParameter (DoCmd) | Set a parameter before opening a Form or Report. | |
| .SetWarnings (DoCmd) | Turn system messages on or off. | |
| Sgn | Return the sign of a number. | |
| .ShowAllRecords(DoCmd) | Remove any applied filter. | |
| .ShowToolbar (DoCmd) | Display or hide a custom toolbar. | |
| Shell | Run an executable program. | |
| Sin | Display Sine of an angle. | |
| SLN | Straight Line Depreciation. | |
| Space | Return a number of spaces. | |
| Sqr | Return the square root of a number. | |
| StDev (SQL) | Estimate the standard deviation for a population. | |
| Str | Return a string representation of a number. | |
| StrComp | Compare two strings. | |
| StrConv | Convert a string to Upper/lower case or Unicode. | |
| String | Repeat a character n times. | |
| Sum (SQL) | Add up the values in a query result set. | |
| Switch | Return one of several values. | |
| SysCmd | Display a progress meter. | |
| T | ||
| Tan | Display Tangent of an angle. | |
| Time | Return the current system time. | |
| Timer | Return a number (single) of seconds since midnight. | |
| TimeSerial | Return a time given an hour, minute, and second. | |
| TimeValue | Convert a string to a Time. | |
| .TransferDatabase (DoCmd) | Import or export data to/from another database. | |
| .TransferSharePointList (DoCmd) |
Import or link data from a SharePoint Foundation site. | |
| .TransferSpreadsheet (DoCmd) |
Import or export data to/from a spreadsheet file. | |
| .TransferSQLDatabase (DoCmd) |
Copy an entire SQL Server database. | |
| .TransferText (DoCmd) | Import or export data to/from a text file. | |
| Transform (SQL) | Create a crosstab query. | |
| Trim | Remove leading and trailing spaces from a string. | |
| TypeName | Return the data type of a variable. | |
| U | ||
| UBound | Return the largest subscript from an array. | |
| UCase | Convert a string to upper-case. | |
| Undo | Undo the last data edit. | |
| Union (SQL) | Combine the results of two SQL queries. | |
| Update (SQL) | Update existing field values in a table. | |
| .Update | Save a recordset. | |
| V | ||
| Val | Extract a numeric value from a string. | |
| Var (SQL) | Estimate variance for sample (all records) | |
| VarP (SQL) | Estimate variance for population (all records) | |
| VarType | Return a number indicating the data type of a variable. | |
| W | ||
| Weekday | Return the weekday (1-7) from a date. | |
| WeekdayName | Return the day of the week. | |
| Y | ||
| Year | Return the year for a given date. |
To scroll this page, press [ a – z ] on the keyboard, or '\' to Search.
Microsoft: Access 2016 Object Model Reference, Functions, SQL
Books, Links, Websites