VBA Script

[paulS30berks]

I have set up a delete query and wish to run this through VBA.

Can anyone point me in the right direction on how I can instruct my query to run through VBA code.

Thanks

Paul

 

[KenHigg]

I would recommend docmd.runsql

 

[paulS30berks]

Thanks for your reply

Where can I state my query name within this script?

Thanks

 

[KenHigg]

See if this helps: Link

 

[mihabaki]

you can also try:

docmd.openquery "qryQueryName"