Access DB Forms Codiding vb

A

ArthurB

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
 
D

Duane Hookom

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

What are you attempting to do with your query records?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RunSql to Update Records Question (Access 2007) 2
Passing Variable Values from Current db to External Database 3
Field list is blank 7
Execute SQL Stored Proc from Access 1
VB code in Access not working 1
Calling Access 'form' from other applications 0
SQL Update Issue 16
SQL statement 3

Top