Running SQL statements in VB

A

AL

Why does this SQL run command always produces a syntax error. The string was
copied from a select query in Access that worked on the desktop.

Dim SQL As String
SQL = "SELECT StudentTable.SeqNO FROM StudentTable WHERE
((StudentTable.SeqNO)=2)"
DoCmd.RunSQL SQL
 
S

Sylvain Lafontaine

Your sql string is not an update, insert or delete query; so it doesn't make
sense to use it with DoCmd.RunSQL.
 

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

Update does not read content of variable 1
SQL VBA -- INNER JOIN Syntax 6
Subquery Correllated In Select Clause - Is this possible? 3
Another runtime error 3075 8
SQL code works in Access SQL window but not in VBA SQL code 61
run-time error '3075' 2
Immediate Window? 2
Retrieve SQL statements from MS-Access in VS2008 2

Top