2uzhan.com
Advertisement
Now Place:2uzhan.com » Run SQL statement in VBA?

Run SQL statement in VBA?

Microsoft Access @ March 1, 2004   Views:0

Can we run an SQL statement from VBA? If so what is the Syntax?

Rgds

--------------Solutions-------------

Check this out...not sure if it's what you want...

DoCmd.RunCommand acCmdRunMacro

You can use:

Docmd.RunSQL strSQL

strSQL is your Query

Like strSQL="Select * from Table"

And of course you could change and save the SQL statement of an existing query and then run that revised query.

Tags:
© 2018 2uzhan.com Contact