D
dave_b
I think I'm going blind. I have programmed SQL statements many times in the
past, and for some reason I simply cannot get anything to work right now...
I've reduced my code down to the most basic statement in order to get some
kind of error code I can comprehend. My code, at the moment, is:
docmd.runsql "Select * from MLS Sales"
Can't get much simpler than that. However, when I try to run that command
I get an error that says "A RunSQL action requires and argument consisting of
an SQL Statement."
Originally I did not use the "*" and had all my field identified. When I
did this I got the error that says "the Select statement includes a reserved
word or an argument name that is misspelled or missing or the punctuation is
incorrect."
This used to be a very simple thing to do. Can anyone give some thoughts on
this?
past, and for some reason I simply cannot get anything to work right now...
I've reduced my code down to the most basic statement in order to get some
kind of error code I can comprehend. My code, at the moment, is:
docmd.runsql "Select * from MLS Sales"
Can't get much simpler than that. However, when I try to run that command
I get an error that says "A RunSQL action requires and argument consisting of
an SQL Statement."
Originally I did not use the "*" and had all my field identified. When I
did this I got the error that says "the Select statement includes a reserved
word or an argument name that is misspelled or missing or the punctuation is
incorrect."
This used to be a very simple thing to do. Can anyone give some thoughts on
this?