How open query in design mode in code

G

Guest

I am using 2007. What is the proper syntax for opening a query in Design
mode? When I run the following I get an "Expected := error". I don't
understand what the compiler is trying to tell me.

DoCmd.OpenQuery ("qry001_invoices",acViewDesign,acEdit)

I have an associate who suggested

DoCmd.OpenQuery (qry001_invoices,acViewDesign,acEdit)
without the quotes,

but this doesn't work either. He says it works on his 2003 version of
Access. Is this some sort of bug in Access 2007
 

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

Append Query problem 2
Display custom Ribbon/Toolbar in Query Design 2
I have a problem with opening a form. 11
New Query Design in Access 2007 MDE 2
On Click event - Create a New Query 2
Using DoCmd.OpenQuery on a query in a remote database 10
Finding name of last query run in VBA code 3
VB command 2

Top