[AccessD] Cannot run query in code.

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Sep 4 16:32:42 CDT 2007


I have a module in which I compose several queries and run them. They
all work fine. I added one more and now get a message of "A RunSQL
action requires an argument consisting of an SQL statement". Below is
the problem code. I have run out of ideas as to what the problem is. A
compact and repair did nothing. Thanks.

 

strSQL = "Select * from Monthly_Appended "

DoCmd.RunSQL strSQL

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

 




More information about the AccessD mailing list