CINXE.COM

<!DOCTYPE HTML><html lang="en"> <head><meta charset="UTF-8"> <meta name="viewport" content="width=1000, initial-scale=1"> <meta http-equiv="Content-Security-Policy" content="default-src 'none'; script-src 'self'; connect-src 'self'; img-src 'self'; style-src 'self' 'unsafe-inline';base-uri 'self';form-action 'self' www.google.com"> <meta name="Description" content="Access commands and functions can be used in the VBA code set to run when form buttons are clicked or other form events run."> <link rel="search" href="https://ss64.com/opensearch.xml" type="application/opensearchdescription+xml" title="SS64.com"> <meta name="viewport" content="width=1000, initial-scale=1"> <link rel="stylesheet" href="../main.css" type="text/css"> <link rel="icon" href="/favicon.ico" sizes="48x48"> <link rel="icon" href="/favicon.svg" sizes="any" type="image/svg+xml"> <title>An A-Z Index of Microsoft Access commands and functions - SS64.com</title> <link rel="canonical" href="https://ss64.com/access/"> <style> .access {color: #990000;} .grn {color: #339900; text-decoration: none; } tr:nth-child(even) td{ background: linear-gradient(0.25turn, #D9D9DE, #D6D6DB, #D9D9DE 700px); background-attachment:fixed;} /* Dark mode */ @media (prefers-color-scheme: dark) { tr:nth-child(even) td{ background-color: #BFBFCA; background: linear-gradient(0.25turn, #BDBDC6, #BFBFC8, #BDBDC6 700px); background-attachment:fixed; } } table{margin-left: 2%;} @media (max-width:1000px){table{margin-left: 1%;}} @media (max-width:700px){table{margin-left: 0;}} </style> <script async src="/js/menu.js"></script> </head> <body> <div id="tnav"><ul> <li class="tbtn"><a href="../">SS64</a></li> <li class=tflat>Access <svg viewBox="0 0 13 20.1" width="13" height="13" style="transform: rotate(0deg);"><path d="M0 2.9l7.2 7.2-7.1 7.1L3 20.1l7.1-7.1 2.9-2.9L2.9 0 0 2.9"></path></svg></li> <li class="tbtn"><a href="syntax.html">How-to <svg viewBox="0 0 13 20.1" width="13" height="13" style="transform: rotate(0deg);"><path d="M0 2.9l7.2 7.2-7.1 7.1L3 20.1l7.1-7.1 2.9-2.9L2.9 0 0 2.9"></path></svg></a></li> <li><div id="search"><form action="https://www.google.com/search" method="get"> <input type="text" name="q" id="qu" size="27" maxlength="255" aria-label="Search text"> <input class="submit mousetrap" value="Search" id="btn" type="submit"> <input type="hidden" name="sitesearch" value="ss64.com"><input type="hidden" name="udm" value="14"></form></div></li> </ul></div> <h1>An A-Z Index of <span class="access">Microsoft Access</span> commands and functions.</h1> <table> <tr> <td class="ix">A</td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="abs.html">Abs</a><a href="addmenu.html">.</a></td> <td>The absolute value of a number (ignore negative sign).</td> </tr> <tr> <td> </td> <td><a href="addmenu.html">AddMenu</a></td> <td>Add a custom menu bar/shortcut bar.</td> </tr> <tr> <td> </td> <td><a href="addnew.html">.AddNew</a></td> <td>Add a new record to a recordset.</td> </tr> <tr> <td> </td> <td><a href="applyfilter.html">.ApplyFilter</a></td> <td>Apply a filter clause to a table, form, or report.</td> </tr> <tr> <td> </td> <td><a href="array.html">Array</a></td> <td>Create an Array.</td> </tr> <tr> <td> </td> <td><a href="asc.html">Asc</a></td> <td>The Ascii code of a character..</td> </tr> <tr> <td> </td> <td><a href="ascw.html">AscW</a></td> <td>The Unicode of a character.</td> </tr> <tr> <td> </td> <td>Atn</td> <td>Display the ArcTan of an angle.</td> </tr> <tr> <td> </td> <td><a href="avg.html">Avg</a></td> <td>(SQL) Average</td> </tr> <tr> <td><a id="b"></a><span class="ix">B</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="beep.html">.Beep</a> (DoCmd)</td> <td>Sound a tone.</td> </tr> <tr> <td> </td> <td><a href="browseto.html">.BrowseTo</a>(DoCmd)</td> <td>Navigate between objects.</td> </tr> <tr> <td><a id="c"></a><span class="ix">C</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>Call</td> <td>Call a procedure.</td> </tr> <tr> <td> </td> <td><a href="cancelevent.html">.CancelEvent</a> (DoCmd)</td> <td>Cancel an event.</td> </tr> <tr> <td> </td> <td><a href="rst-cancelupdate.html">.CancelUpdate</a></td> <td>Cancel recordset changes.</td> </tr> <tr> <td> </td> <td><a href="case.html">Case</a></td> <td>If Then Else.</td> </tr> <tr> <td> </td> <td><a href="cbool.html">CBool</a></td> <td>Convert to boolean.</td> </tr> <tr> <td> </td> <td><a href="cbyte.html">CByte</a></td> <td>Convert to byte.</td> </tr> <tr> <td> </td> <td><a href="ccur.html">CCur</a></td> <td>Convert to currency (number)</td> </tr> <tr> <td> </td> <td><a href="cdate.html">CDate</a></td> <td>Convert to Date.</td> </tr> <tr> <td> </td> <td><a href="cvdate.html">CVDate</a></td> <td>Convert to Date.</td> </tr> <tr> <td> </td> <td><a href="cdbl.html">CDbl</a></td> <td>Convert to Double (number)</td> </tr> <tr> <td> </td> <td><a href="cdec.html">CDec</a></td> <td>Convert to Decimal (number)</td> </tr> <tr> <td> </td> <td><a href="choose.html">Choose</a></td> <td>Return a value from a list based on position.</td> </tr> <tr> <td> </td> <td><a href="chdir.html">ChDir</a></td> <td>Change the current directory or folder.</td> </tr> <tr> <td> </td> <td><a href="chdrive.html">ChDrive</a></td> <td>Change the current drive.</td> </tr> <tr> <td> </td> <td><a href="chr.html">Chr</a><a href="clearmacroerror.html">.</a></td> <td>Return a character based on an ASCII code.</td> </tr> <tr> <td> </td> <td><a href="clearmacroerror.html">ClearMacroError</a> (DoCmd)</td> <td>Clear MacroError.</td> </tr> <tr> <td> </td> <td><a href="close.html">.Close</a> (DoCmd)</td> <td>Close a form/report/window.</td> </tr> <tr> <td> </td> <td><a href="closedatabase.html">.CloseDatabase</a> (DoCmd)</td> <td>Close the database.</td> </tr> <tr> <td> </td> <td><a href="cint.html">CInt</a></td> <td>Convert to Integer (number)</td> </tr> <tr> <td> </td> <td><a href="clng.html">CLng</a></td> <td>Convert to Long (number)</td> </tr> <tr> <td> </td> <td><a href="command.html">Command</a></td> <td>Return command line option string.</td> </tr> <tr> <td> </td> <td><a href="copydatabasefile.html">.CopyDatabaseFile</a><br> (DoCmd)</td> <td>Copy to an SQL .mdf file.</td> </tr> <tr> <td> </td> <td><a href="copyobject.html">.CopyObject</a> (DoCmd)</td> <td>Copy an Access database object.</td> </tr> <tr> <td> </td> <td>Cos Display</td> <td>Cosine of an angle.</td> </tr> <tr> <td> </td> <td><a href="count.html">Count</a> (SQL)</td> <td>Count records.</td> </tr> <tr> <td> </td> <td><a href="csng.html">CSng</a></td> <td>Convert to Single (number.)</td> </tr> <tr> <td> </td> <td><a href="cstr.html">CStr</a></td> <td>Convert to String.</td> </tr> <tr> <td> </td> <td><a href="curdir.html">CurDir</a></td> <td>Return the current path.</td> </tr> <tr> <td> </td> <td><a href="currentdb.html">CurrentDb</a></td> <td>Return an object variable for the current database.</td> </tr> <tr> <td> </td> <td><a href="currentuser.html">CurrentUser</a></td> <td>Return the current user.</td> </tr> <tr> <td> </td> <td><a href="cvar.html">CVar</a></td> <td>Convert to a Variant.</td> </tr> <tr> <td><a id="d"></a><span class="ix">D</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="date.html">Date</a></td> <td>The current date.</td> </tr> <tr> <td> </td> <td><a href="dateadd.html">DateAdd</a></td> <td>Add a time interval to a date.</td> </tr> <tr> <td> </td> <td><a href="datediff.html">DateDiff</a></td> <td>The time difference between two dates.</td> </tr> <tr> <td> </td> <td><a href="datepart.html">DatePart</a></td> <td>Return part of a given date.</td> </tr> <tr> <td> </td> <td><a href="dateserial.html">DateSerial</a></td> <td>Return a date given a year, month, and day.</td> </tr> <tr> <td> </td> <td><a href="datevalue.html">DateValue</a></td> <td>Convert a string to a date.</td> </tr> <tr> <td> </td> <td><a href="davg.html">DAvg</a></td> <td>Average from a set of records.</td> </tr> <tr> <td> </td> <td><a href="day.html">Day</a></td> <td>Return the day of the month.</td> </tr> <tr> <td> </td> <td><a href="dcount.html">DCount</a></td> <td>Count the number of records in a table/query.</td> </tr> <tr> <td> </td> <td><a href="delete.html">Delete</a> (SQL)</td> <td>Delete records.</td> </tr> <tr> <td> </td> <td><a href="deleteobject.html">.DeleteObject</a> (DoCmd)</td> <td>Delete an object.</td> </tr> <tr> <td> </td> <td><a href="deletesetting.html">DeleteSetting</a></td> <td>Delete a value from the users registry.</td> </tr> <tr> <td> </td> <td>.<a href="runcommand.html">DoMenuItem</a> (DoCmd)</td> <td>Display a menu or toolbar command.</td> </tr> <tr> <td> </td> <td><a href="dfirst.html">DFirst</a></td> <td>The first value from a set of records.</td> </tr> <tr> <td> </td> <td><a href="dir.html">Dir</a></td> <td>List the files in a folder.</td> </tr> <tr> <td> </td> <td><a href="dim.html">Dim</a></td> <td>Declare a new variable.</td> </tr> <tr> <td> </td> <td><a href="dlast.html">DLast</a></td> <td>The last value from a set of records.</td> </tr> <tr> <td> </td> <td><a href="dlookup.html">DLookup</a></td> <td>Get the value of a particular field.</td> </tr> <tr> <td> </td> <td><a href="dmax.html">DMax</a></td> <td>Return the maximum value from a set of records.</td> </tr> <tr> <td> </td> <td><a href="dmin.html">DMin</a></td> <td>Return the minimum value from a set of records.</td> </tr> <tr> <td> </td> <td><a href="doevents.html">DoEvents</a></td> <td>Allow the Operating System to process other events.</td> </tr> <tr> <td> </td> <td>DStDev</td> <td>Estimate Standard deviation for domain (subset of records)</td> </tr> <tr> <td> </td> <td>DStDevP</td> <td>Estimate Standard deviation for population (subset of records)</td> </tr> <tr> <td> </td> <td><a href="dsum.html">DSum</a></td> <td>Return the sum of values from a set of records.</td> </tr> <tr> <td> </td> <td>DVar</td> <td>Estimate variance for domain (subset of records)</td> </tr> <tr> <td> </td> <td>DVarP</td> <td>Estimate variance for population (subset of records)</td> </tr> <tr> <td><a id="e"></a><span class="ix">E</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="echo.html">.Echo</a></td> <td>Turn screen updating on or off.</td> </tr> <tr> <td> </td> <td><a href="environ.html">Environ</a></td> <td>Return the value of an OS environment variable.</td> </tr> <tr> <td> </td> <td>EOF</td> <td>End of file input.</td> </tr> <tr> <td> </td> <td>Error</td> <td>Return the error message for an error No.</td> </tr> <tr> <td> </td> <td><a href="eval.html">Eval</a></td> <td>Evaluate an expression.</td> </tr> <tr> <td> </td> <td><a href="execute.html">Execute</a>(SQL/VBA)</td> <td>Execute a procedure or run SQL.</td> </tr> <tr> <td> </td> <td><a href="exp.html">Exp</a></td> <td>Exponential e raised to the <i>n</i>th power.</td> </tr> <tr> <td><a id="f"></a><span class="ix">F</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="filedatetime.html">FileDateTime</a></td> <td>Filename last modified date/time.</td> </tr> <tr> <td> </td> <td><a href="filelen.html">FileLen</a></td> <td>The size of a file in bytes.</td> </tr> <tr> <td> </td> <td><a href="findfirst.html">.FindFirst</a>/Last/<br> Next/Previous</td> <td>Find record</td> </tr> <tr> <td> </td> <td><a href="findrecord.html">.FindRecord</a>(DoCmd)</td> <td>Find a specific record.</td> </tr> <tr> <td> </td> <td><a href="first.html">First</a> (SQL)</td> <td>Return the first value from a query.</td> </tr> <tr> <td> </td> <td><a href="fix.html">Fix</a></td> <td>Return the integer portion of a number.</td> </tr> <tr> <td> </td> <td><a href="for.html">For</a></td> <td>Loop.</td> </tr> <tr> <td> </td> <td><a href="format.html">Format</a></td> <td>Format a Number/Date/Time.</td> </tr> <tr> <td> </td> <td>FreeFile</td> <td>The next file No. available to open.</td> </tr> <tr> <td> </td> <td><a href="from.html">From</a></td> <td>Specify the table(s) to be used in an SQL query.</td> </tr> <tr> <td> </td> <td>FV</td> <td>Future Value of an annuity.</td> </tr> <tr> <td><a id="g"></a><span class="ix">G</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="getallsettings.html">GetAllSettings</a></td> <td>List the settings saved in the registry.</td> </tr> <tr> <td> </td> <td><a href="getattr.html">GetAttr</a></td> <td>Get file/folder attributes.</td> </tr> <tr> <td> </td> <td>GetObject</td> <td>Return a reference to an ActiveX object.</td> </tr> <tr> <td> </td> <td><a href="getsetting.html">GetSetting</a></td> <td>Retrieve a value from the users registry.</td> </tr> <tr> <td> </td> <td><i>form</i>.GoToPage</td> <td>Move to a page on specific form.</td> </tr> <tr> <td> </td> <td><a href="gotorecord.html">.GoToRecord</a> (DoCmd)</td> <td>Move to a specific record in a dataset.</td> </tr> <tr> <td><a id="h"></a><span class="ix">H</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="hex.html">Hex</a></td> <td>Convert a number to Hex.</td> </tr> <tr> <td> </td> <td><a href="hour.html">Hour</a></td> <td>Return the hour of the day.</td> </tr> <tr> <td> </td> <td><a href="hourglass.html">.Hourglass</a> (DoCmd)</td> <td>Display the hourglass icon.</td> </tr> <tr> <td> </td> <td>HyperlinkPart</td> <td>Return information about data stored as a hyperlink.</td> </tr> <tr> <td><a id="i"></a><span class="ix">I</span><a id="j"></a><a id="k"></a></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="if.html">If Then Else</a></td> <td>If-Then-Else function.</td> </tr> <tr> <td> </td> <td><a href="iif.html">IIf</a></td> <td>If-Then-Else</td> </tr> <tr> <td> </td> <td>Input</td> <td>Return characters from a file.</td> </tr> <tr> <td> </td> <td><a href="inputbox.html">InputBox</a></td> <td>Prompt for user input.</td> </tr> <tr> <td> </td> <td><a href="insert.html">Insert</a> (SQL)</td> <td>Add records to a table (append query).</td> </tr> <tr> <td> </td> <td><a href="instr.html">InStr</a></td> <td>Return the position of one string within another.</td> </tr> <tr> <td> </td> <td><a href="instrrev.html">InstrRev</a></td> <td>Return the position of one string within another.</td> </tr> <tr> <td> </td> <td><a href="int.html">Int</a></td> <td>Return the integer portion of a number.</td> </tr> <tr> <td> </td> <td>IPmt</td> <td>Interest payment for an annuity</td> </tr> <tr> <td> </td> <td><a href="isarray.html">IsArray</a></td> <td>Test if an expression is an array</td> </tr> <tr> <td> </td> <td><a href="isdate.html">IsDate</a></td> <td>Test if an expression is a date.</td> </tr> <tr> <td> </td> <td><a href="isempty.html">IsEmpty</a></td> <td>Test if an expression is Empty (unassigned).</td> </tr> <tr> <td> </td> <td><a href="iserror.html">IsError</a></td> <td>Test if an expression is returning an error.</td> </tr> <tr> <td> </td> <td><a href="ismissing.html">IsMissing</a></td> <td>Test if a missing expression.</td> </tr> <tr> <td> </td> <td><a href="isnull.html">IsNull</a></td> <td>Test for a NULL expression or Zero Length string.</td> </tr> <tr> <td> </td> <td><a href="isnumeric.html">IsNumeric</a></td> <td>Test for a valid Number.</td> </tr> <tr> <td> </td> <td><a href="isobject.html">IsObject</a></td> <td>Test if an expression is an Object.</td> </tr> <tr> <td><a id="l"></a><span class="ix">L</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="last.html">Last</a> (SQL)</td> <td>Return the last value from a query.</td> </tr> <tr> <td> </td> <td>LBound</td> <td>Return the smallest subscript from an array.</td> </tr> <tr> <td> </td> <td><a href="lcase.html">LCase</a></td> <td>Convert a string to lower-case.</td> </tr> <tr> <td> </td> <td><a href="left.html">Left</a></td> <td>Extract a substring from a string.</td> </tr> <tr> <td> </td> <td><a href="len.html">Len</a></td> <td>Return the length of a string.</td> </tr> <tr> <td> </td> <td>LoadPicture</td> <td>Load a picture into an ActiveX control.</td> </tr> <tr> <td> </td> <td>Loc</td> <td>The current position within an open file.</td> </tr> <tr> <td> </td> <td><a href="locknavigationpane.html">.LockNavigationPane<br> </a>(DoCmd)</td> <td>Lock the Navigation Pane.</td> </tr> <tr> <td> </td> <td>LOF</td> <td>The length of a file opened with Open()</td> </tr> <tr> <td> </td> <td><a href="log.html">Log</a></td> <td>Return the natural logarithm of a number.</td> </tr> <tr> <td> </td> <td><a href="ltrim.html">LTrim</a></td> <td>Remove leading spaces from a string.</td> </tr> <tr> <td><a id="m"></a><span class="ix">M</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="max.html">Max</a> (SQL)</td> <td>Return the maximum value from a query.</td> </tr> <tr> <td> </td> <td><a href="maximise.html">.Maximize</a> (DoCmd)</td> <td>Enlarge the active window.</td> </tr> <tr> <td> </td> <td><a href="mid.html">Mid</a></td> <td>Extract a substring from a string.</td> </tr> <tr> <td> </td> <td><a href="min.html">Min</a> (SQL)</td> <td>Return the minimum value from a query.</td> </tr> <tr> <td> </td> <td><a href="minimise.html">.Minimize</a> (DoCmd)</td> <td>Minimise a window.</td> </tr> <tr> <td> </td> <td><a href="minute.html">Minute</a></td> <td>Return the minute of the hour.</td> </tr> <tr> <td> </td> <td><a href="mkdir.html">MkDir</a></td> <td>Create directory.</td> </tr> <tr> <td> </td> <td><a href="month.html">Month</a></td> <td>Return the month for a given date.</td> </tr> <tr> <td> </td> <td><a href="monthname.html">MonthName</a></td> <td>Return a string representing the month.</td> </tr> <tr> <td> </td> <td><a href="move.html">.Move</a></td> <td>Move through a Recordset.</td> </tr> <tr> <td> </td> <td><a href="movefirst.html">.MoveFirst</a>/Last/<br> Next/Previous</td> <td>Move to Record.</td> </tr> <tr> <td> </td> <td><a href="movesize.html">.MoveSize</a> (DoCmd)</td> <td>Move or Resize a Window.</td> </tr> <tr> <td> </td> <td><a href="msgbox.html">MsgBox</a></td> <td>Display a message in a dialogue box.</td> </tr> <tr> <td> </td> <td><a href="for.html">Next</a></td> <td>Continue a <i>for</i> loop.</td> </tr> <tr> <td><a id="n"></a><span class="ix">N</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="now.html">Now</a></td> <td>Return the current date and time.</td> </tr> <tr> <td> </td> <td><a href="nz.html">Nz</a></td> <td>Detect a NULL value or a Zero Length string.</td> </tr> <tr> <td><a id="o"></a><span class="ix">O</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="oct.html">Oct</a></td> <td>Convert an integer to Octal.</td> </tr> <tr> <td> </td> <td><a href="onclick.html">OnClick, OnOpen</a></td> <td>Events.</td> </tr> <tr> <td> </td> <td><a href="openform.html">.OpenForm</a> (DoCmd)</td> <td>Open a form.</td> </tr> <tr> <td> </td> <td><a href="openquery.html">.OpenQuery</a> (DoCmd)</td> <td>Open a query.</td> </tr> <tr> <td> </td> <td><a href="openrecordset.html">.OpenRecordset</a></td> <td>Create a new Recordset.</td> </tr> <tr> <td> </td> <td><a href="openreport.html">.OpenReport</a> (DoCmd)</td> <td>Open a report.</td> </tr> <tr> <td> </td> <td><a href="outputto.html">.OutputTo</a> (DoCmd)</td> <td>Export to a Text/CSV/Spreadsheet file.</td> </tr> <tr> <td><a id="p"></a><span class="ix">P</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="partition.html">Partition</a> (SQL)</td> <td>Locate a number within a range.</td> </tr> <tr> <td> </td> <td>.PrintOut (DoCmd)</td> <td>Print the active object (form/report etc.)</td> </tr> <tr> <td><a id="q"></a><span class="ix">Q</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="quit.html">Quit</a></td> <td>Quit Microsoft Access</td> </tr> <tr> <td><a id="r"></a><span class="ix">R</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="refreshrecord.html">.RefreshRecord</a> (DoCmd)</td> <td>Refresh the data in a form.</td> </tr> <tr> <td> </td> <td><a href="rename.html">.Rename</a> (DoCmd)</td> <td>Rename an object.</td> </tr> <tr> <td> </td> <td>.RepaintObject (DoCmd)</td> <td>Complete any pending screen updates.</td> </tr> <tr> <td> </td> <td><a href="replace.html">Replace</a></td> <td>Replace a sequence of characters in a string.</td> </tr> <tr> <td> </td> <td><a href="requery.html">.Requery</a></td> <td>Requery the data in a form or a control.</td> </tr> <tr> <td> </td> <td><a href="restore.html">.Restore</a> (DoCmd)</td> <td>Restore a maximized or minimized window.</td> </tr> <tr> <td> </td> <td><a href="rgb.html">RGB</a></td> <td>Convert an RGB colour to a number.</td> </tr> <tr> <td> </td> <td><a href="right.html">Right</a></td> <td>Extract a substring from a string.</td> </tr> <tr> <td> </td> <td><a href="rnd.html">Rnd</a></td> <td>Generate a random number.</td> </tr> <tr> <td> </td> <td><a href="round.html">Round</a></td> <td>Round a number to <i>n</i> decimal places.</td> </tr> <tr> <td> </td> <td><a href="rtrim.html">RTrim</a></td> <td>Remove trailing spaces from a string.</td> </tr> <tr> <td> </td> <td><a href="runcommand.html">.RunCommand</a></td> <td>Run an Access menu or toolbar command.</td> </tr> <tr> <td> </td> <td>.RunDataMacro (DoCmd)</td> <td>Run a named data macro.</td> </tr> <tr> <td> </td> <td><a href="runmacro.html">.RunMacro</a> (DoCmd)</td> <td>Run a macro.</td> </tr> <tr> <td> </td> <td>.RunSavedImportExport<br> (DoCmd)</td> <td>Run a saved import or export specification.</td> </tr> <tr> <td> </td> <td><a href="runsql.html">.RunSQL</a> (DoCmd)</td> <td>Run an SQL query.</td> </tr> <tr> <td><a id="s"></a><span class="ix">S</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="save.html">.Save</a> (DoCmd)</td> <td>Save a database object.</td> </tr> <tr> <td> </td> <td><a href="savesetting.html">SaveSetting</a></td> <td>Store a value in the users registry</td> </tr> <tr> <td> </td> <td><a href="searchforrecord.html">.SearchForRecord</a>(DoCmd)</td> <td>Search for a specific record.</td> </tr> <tr> <td> </td> <td><a href="second.html">Second</a></td> <td>Return the seconds of the minute.</td> </tr> <tr> <td> </td> <td>Seek</td> <td>The position within a file opened with <i>Open</i>.</td> </tr> <tr> <td> </td> <td><a href="select.html">Select</a> (SQL)</td> <td>Retrieve data from one or more tables or queries.</td> </tr> <tr> <td> </td> <td><a href="select-into.html">Select Into</a> (SQL)</td> <td>Make-table query.</td> </tr> <tr> <td> </td> <td><a href="select-subquery.html">Select-Subquery</a> (SQL)</td> <td>SubQuery.</td> </tr> <tr> <td> </td> <td>.SelectObject (DoCmd)</td> <td>Select a specific database object.</td> </tr> <tr> <td> </td> <td><a href="sendobject.html">.SendObject</a> (DoCmd)</td> <td>Send an email with a database object attached.</td> </tr> <tr> <td> </td> <td><a href="sendkeys.html">SendKeys</a></td> <td>Send keystrokes to the active window.</td> </tr> <tr> <td> </td> <td><a href="setattr.html">SetAttr</a></td> <td>Set the attributes of a file.</td> </tr> <tr> <td> </td> <td>.SetDisplayedCategories<br> (DoCmd)</td> <td>Change Navigation Pane display options.</td> </tr> <tr> <td> </td> <td><a href="setfilter.html">.SetFilter</a> (DoCmd)</td> <td>Apply a filter to the records being displayed.</td> </tr> <tr> <td> </td> <td><a href="setfocus.html">SetFocus</a></td> <td>Move focus to a specified field or control.</td> </tr> <tr> <td> </td> <td>.SetMenuItem (DoCmd)</td> <td>Set the state of menubar items (enabled /checked)</td> </tr> <tr> <td> </td> <td><a href="setorderby.html">.SetOrderBy</a> (DoCmd)</td> <td>Apply a sort to the active datasheet, form or report.</td> </tr> <tr> <td> </td> <td><a href="setparameter.html">.SetParameter</a> (DoCmd)</td> <td>Set a parameter before opening a Form or Report.</td> </tr> <tr> <td> </td> <td><a href="setwarnings.html">.SetWarnings</a> (DoCmd)</td> <td>Turn system messages on or off.</td> </tr> <tr> <td> </td> <td><a href="sgn.html">Sgn</a></td> <td>Return the sign of a number.</td> </tr> <tr> <td> </td> <td><a href="showallrecords.html">.ShowAllRecords</a>(DoCmd)</td> <td>Remove any applied filter.</td> </tr> <tr> <td> </td> <td><a href="showtoolbar.html">.ShowToolbar</a> (DoCmd)</td> <td>Display or hide a custom toolbar.</td> </tr> <tr> <td> </td> <td><a href="shell.html">Shell</a></td> <td>Run an executable program.</td> </tr> <tr> <td> </td> <td>Sin</td> <td>Display Sine of an angle.</td> </tr> <tr> <td> </td> <td>SLN</td> <td>Straight Line Depreciation.</td> </tr> <tr> <td> </td> <td><a href="space.html">Space</a></td> <td>Return a number of spaces.</td> </tr> <tr> <td> </td> <td><a href="sqr.html">Sqr</a></td> <td>Return the square root of a number.</td> </tr> <tr> <td> </td> <td>StDev (SQL)</td> <td>Estimate the standard deviation for a population.</td> </tr> <tr> <td> </td> <td><a href="str.html">Str</a></td> <td>Return a string representation of a number.</td> </tr> <tr> <td> </td> <td><a href="strcomp.html">StrComp</a></td> <td>Compare two strings.</td> </tr> <tr> <td> </td> <td><a href="strconv.html">StrConv</a></td> <td>Convert a string to Upper/lower case or Unicode.</td> </tr> <tr> <td> </td> <td><a href="string.html">String</a></td> <td>Repeat a character <i>n</i> times.</td> </tr> <tr> <td> </td> <td><a href="sum.html">Sum</a> (SQL)</td> <td>Add up the values in a query result set.</td> </tr> <tr> <td> </td> <td><a href="switch.html">Switch</a></td> <td>Return one of several values.</td> </tr> <tr> <td> </td> <td>SysCmd</td> <td>Display a progress meter.</td> </tr> <tr> <td><a id="t"></a><span class="ix">T</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>Tan</td> <td>Display Tangent of an angle.</td> </tr> <tr> <td> </td> <td><a href="time.html">Time</a></td> <td>Return the current system time.</td> </tr> <tr> <td> </td> <td>Timer</td> <td>Return a number (single) of seconds since midnight.</td> </tr> <tr> <td> </td> <td><a href="timeserial.html">TimeSerial</a></td> <td>Return a time given an hour, minute, and second.</td> </tr> <tr> <td> </td> <td><a href="timevalue.html">TimeValue</a></td> <td>Convert a string to a Time.</td> </tr> <tr> <td> </td> <td><a href="transferdatabase.html">.TransferDatabase</a> (DoCmd)</td> <td>Import or export data to/from another database.</td> </tr> <tr> <td> </td> <td><a href="transfersharepointlist.html">.TransferSharePointList</a><br> (DoCmd)</td> <td>Import or link data from a SharePoint Foundation site.</td> </tr> <tr> <td> </td> <td><a href="transferspreadsheet.html">.TransferSpreadsheet<br> </a>(DoCmd)</td> <td>Import or export data to/from a spreadsheet file.</td> </tr> <tr> <td> </td> <td><a href="transfersqldatabase.html">.TransferSQLDatabase<br> </a>(DoCmd)</td> <td>Copy an entire SQL Server database.</td> </tr> <tr> <td> </td> <td><a href="transfertext.html">.TransferText</a> (DoCmd)</td> <td>Import or export data to/from a text file.</td> </tr> <tr> <td> </td> <td><a href="transform.html">Transform</a> (SQL)</td> <td>Create a crosstab query.</td> </tr> <tr> <td> </td> <td><a href="trim.html">Trim</a></td> <td>Remove leading and trailing spaces from a string.</td> </tr> <tr> <td> </td> <td>TypeName</td> <td>Return the data type of a variable.</td> </tr> <tr> <td><a id="u"></a><span class="ix">U</span></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>UBound</td> <td>Return the largest subscript from an array.</td> </tr> <tr> <td> </td> <td><a href="ucase.html">UCase</a></td> <td>Convert a string to upper-case.</td> </tr> <tr> <td> </td> <td><a href="undo.html">Undo</a></td> <td>Undo the last data edit.</td> </tr> <tr> <td> </td> <td><a href="union.html">Union</a> (SQL)</td> <td>Combine the results of two SQL queries.</td> </tr> <tr> <td> </td> <td><a href="update.html">Update</a> (SQL)</td> <td>Update existing field values in a table.</td> </tr> <tr> <td> </td> <td><a href="rst-update.html">.Update</a></td> <td>Save a recordset.</td> </tr> <tr> <td><a id="v"></a>V</td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="val.html">Val</a></td> <td>Extract a numeric value from a string.</td> </tr> <tr> <td> </td> <td>Var (SQL)</td> <td>Estimate variance for sample (all records)</td> </tr> <tr> <td> </td> <td>VarP (SQL)</td> <td>Estimate variance for population (all records)</td> </tr> <tr> <td> </td> <td>VarType</td> <td>Return a number indicating the data type of a variable.</td> </tr> <tr> <td><a id="w"></a><span class="ix">W</span><a id="x"></a></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="weekday.html">Weekday</a></td> <td>Return the weekday (1-7) from a date.</td> </tr> <tr> <td> </td> <td><a href="weekdayname.html">WeekdayName</a></td> <td>Return the day of the week.</td> </tr> <tr> <td><a id="y"></a><span class="ix">Y</span><a id="z"></a></td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td><a href="year.html">Year</a></td> <td>Return the year for a given date.</td> </tr> </table> <p>To scroll this page, press [ a – z ] on the keyboard, or '<span class="code">\</span>' to Search.</p> <p>Microsoft: <a href="https://docs.microsoft.com/office/vba/api/overview/access/object-model">Access 2016 Object Model Reference</a>, <a href="https://docs.microsoft.com/previous-versions/office/developer/office-2003/aa212176(v=office.11)">Functions</a>, <a href="https://msdn.microsoft.com/library/ff841695.aspx">SQL</a><br> <a href="../links/access.html">Books, Links, Websites</a></p><hr> <div id=bl> </div> <div id=br>Copyright © 1999-2025 <a href="https://ss64.com/">SS64.com</a><br> Some rights reserved</div></body> </html>