Converting

A

augustus

Hi

I know we could convert Macros to VBA in access, but is there way that we could convert queries to VBA or MS SQL
THank
Augustus
 
N

Nikos Yannacopoulos

Augustus,

Open your query and change view to SQL (View > SQL view). Access will have
the equivalent SQL statement ready for you! You can copy it to use in your
VBA code.
If it's a Selet query then it can be used either to define a recordset to
perform operations on, or as the recordsource for a form or report.
If it's an action query (Append, Update, Make Table, Delete) it can be run
directly in a DoCmd.RunSQL statement to perform the action.

HTH,
Nikos

augustus said:
Hi,

I know we could convert Macros to VBA in access, but is there way that we
Click to expand...
could convert queries to VBA or MS SQL?
 
Top