Use SQL in VBA Code to Create Dynamic Recordsets.
Saved in:
| Title: | Use SQL in VBA Code to Create Dynamic Recordsets. |
|---|---|
| Authors: | Stockman, Joe |
| Source: | Advisor Guide to Microsoft Access. Nov2006, Vol. 14 Issue 11, p8-13. 5p. 5 Color Photographs. |
| Subject Terms: | SQL, Programming languages, Query languages (Computer science), Computer software, Microsoft software |
| Abstract: | The article offers information on how to use Structured Query Language (SQL), from a Microsoft Access query, in Visual Basic for Applications (VBA) code to create dynamic recordsets. Normally, the SQL statement is formatted by the Access query builder onto multiple lines that the VBA does not recognize immediately. Background information on the SQL and VBA are presented. Several processes are explained, including accessing records in code, using SQL as a source, and adding dynamic criteria. |
| Database: | Supplemental Index |
Nájsť tento článok vo Web of Science Be the first to leave a comment!