Converting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
 
Back
Top