Access DB Forms Codiding vb

[Guest]

Hi,

New again to Access programming and not to familiar with VB. Would like to
use the DoCmd.RunSQL to excute a SQL command to select a value from a table.
Finaly got the SQL statement correct, I.E. copied form SQL builder, and it
runs with no problem. However when runing with the DoCmc.RunSQL SQLString,
where SQLString contains the SQL statement I need to run I get an erron at
runtime. Seems to be a problem with the DoCmd.RunSQL method. Followed
syntax as in help files. Not sure what the problem is? Also where is the
results of the fromthe qwery so tht I can do further calculations on it?

Any help would be greatly appreciated.

Clinton

 

[Duane Hookom]

RunSQL is for running action queries such as update or append queries.

What are you attempting to do with your query records?