Converting

[Guest]

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

 

[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

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?