#Microsoft access database examples update#

New! Download a running example of the Docmd.RunSQL Method The programmer has the ability to perform all the logic and data validation functions within VBA and has the power of SQL all within the same environment. The RunSQL command is one of the most powerful features of Access Visual Basic. If you leave this argument blank, the default (True) is assumed. See our tutorial on Access Transaction Processing. Use False (0) if you don’t want to use a transaction.

Use True (-1) to include this query in a transaction.

Examples are Update, Delete, Insert Into, etc., queries. SQL Statement – A required variant string expression that is a valid SQL statement for an action query or a data-definition query. If you want to work with the data in VBA then you would do a Select Query using a Recordset operation.

#Microsoft access database examples update#

Typically you would want to use the nsql for Update Queries and Delete Queries. This command is used to execute sql query code within Access Visual Basic. The Microsoft Access RunSQL method performs the RunSQL action in Visual Basic.