OpenQuery Command

S

Sok

Can someone please tell me why this line of code isn't
working?

DoCmd.OpenQuery("Requirements Master Table Query",
acViewPreview, acEdit)

Please let me know, thanks.
 
C

Cheryl Fischer

I think this is run without parentheses, for example:

DoCmd.OpenQuery "Requirements Master Table Query", acViewPreview,
acEdit

Also, if you use acViewPreview instead of acViewNormal, you will not be able
to edit the resultset.


hth,
 

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

Using variables as table names in an append sql statemnt 1
Make Table Query / Append Query ??? 2
Export to Excel with Parameter in Filename 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
query runs on entire table not just current record 6
suppress macro messages 1
Double entry of parameters used in query 5

Top