Help with Docmd.RunSql Please

  • Thread starter Thread starter Shadow
  • Start date Start date
S

Shadow

How can I create a UNION query with DoCmd.RunSql statement in VBA?

this doesn't work for me.

PerRst = "SELECT * FROM tblInOutDoc UNION SELECT * FROM tblTempInOutDoc;"
DoCmd.RunSQL PerRst



thanks for any kind of advice/
 
RunSQL is for action queries.

If you want to examine the results programmatically, use OpenRecordset().
If you want to view the results on screen, use OpenQuery.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DoCmd.RunSQL - Need help! 1
UNION Error 9
Select statement in code 6
Record Copy 3
DoCmd.RunSQL gives 2342 error 3
Select From 1
How to Build an SQL Query on the Fly for Data Export to Excel 3
Help with Sub Forms 3

Back
Top