Learn about using macros and VBA code in Access databases to program and automate your applications.

ANSI-89 describes the traditional Access SQL syntax, which is the default for Access databases. The wildcard characters conform to the Microsoft Visual Basic® for Applications (VBA) …

This article contains links to articles that provide details about common functions used in expressions in Access. They are arranged first by group and then are arranged alphabetically …

When you open a report that is based on a query, Access triggers the Open event for the report before it runs the underlying query. As a result, you can set the criteria for the report by using …

In Access desktop databases you can use the DLookup function to get the value of a particular field from a specified set of records (a domain). Use the DLookup function in a Visual Basic for …

Use the DMin and DMax functions in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control. For example, you could use the DMin and DMax …

Use these Access type conversion functions to coerce an expression to a specific data type. For example, you can use the CDate function to convert a string to the Date data type.

Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in …

Use the DCount function in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control. For example, you could use the DCount function in a …

Note: This example demonstrates the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop …