Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro Name not recognized 1

Status
Not open for further replies.

ZoomerZ

MIS
Jul 15, 2004
230
US
I ran into some problem I don't know what to make of it...

I am writing a Macro in Access:
___________________________________________________________
Action Comment
---------------------------------
OpenQuery 01 - Delete Some Table

---------------------------------
QueryName 01 - Delete Some Table
View Datasheet
DataMode Edit
----------------------------------------------------------
and I am getting message: "The action required a Query Name Argument...You left the Query Argument Blank"

Manualy Query runs as a dream...
I did not misspelled Name as I selected from drop down menu and copy/pasted it in comments.

Any thoughts?

THANKS
 
ZoomerZ
If you have spaces in your object names, you have to enclose the name in sqare brackets. That's why it's best not to have spaces in object names.

Tom
 
Thanks again, I usualy write it with underscores...THANKS
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top