If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: SQL error

Hey,
I'm trying to write RunSQL command.I copied the SQL statment from the
SQL view and pasted it with the RunSQL.
Access give me the exception "A RunSQL action requires an argument
consisting of SQL statment"
I thought that somthing wrong in the copy-past so I tried many times and the same exception was displayed.
What can be the problem
Thanks...

Re: SQL error

Originally posted by hammbakka
In the first and the second statements there is no actions to be done, like INSERT INTO , DELET FROM or SELECT .... INTO
So that you can not use the DoCmd.Run Sql (yourSql)

The third one is ok....

Hello hammbakka,
You don't give me your suggestion.I want a way to do my queries in Vb.
I have 10 tables,if I make two queries to each table,it isn't suitable.
please give me a link to learn how I can build SQL statments in VB and give them parameters to do the same thing in all of the tables...