simple SELECT question

  • Thread starter robertfuschetto via AccessMonster.com
  • Start date
R

robertfuschetto via AccessMonster.com

I have code to delete the contents of a table. I have code to repopulate it.
This works fine.

I tried adding code to group the table contents and open it and the code
fails with an error.

Dim db As Database
Set db = CurrentDb()
sqlstr = "SELECT tbl_TempList.Name1, tbl_TempList.Table1FROM tbl_TempList
GROUP BY tbl_TempList.Name1, tbl_TempList.Table1;"

DoCmd.RunSQL sqlstr

Error results:
A runSQL action requires an argument consisting of an SQL statement.

Ideas?????
 
A

Allen Browne

Try OpenQuery if you want to see the results, or OpenRecordset if you want
to operate on it programmatically without viewing the query output.
 
F

fredg

I have code to delete the contents of a table. I have code to repopulate it.
This works fine.

I tried adding code to group the table contents and open it and the code
fails with an error.

Dim db As Database
Set db = CurrentDb()
sqlstr = "SELECT tbl_TempList.Name1, tbl_TempList.Table1FROM tbl_TempList
GROUP BY tbl_TempList.Name1, tbl_TempList.Table1;"

DoCmd.RunSQL sqlstr

Error results:
A runSQL action requires an argument consisting of an SQL statement.

Ideas?????
Click to expand...


You're attempting to run a Select query using RunSQL. You cannot run a
Select query using RunSQL, only action queries, i.e. Delete, Update,
etc. Read VBA help files.
 
R

robertfuschetto via AccessMonster.com

....been trying to get them to install the help files so I can...for now I
must look for a book...do you reccomend one?
I have code to delete the contents of a table. I have code to repopulate it.
This works fine.
Click to expand...
[quoted text clipped - 13 lines]
Ideas?????
Click to expand...

You're attempting to run a Select query using RunSQL. You cannot run a
Select query using RunSQL, only action queries, i.e. Delete, Update,
etc. Read VBA help files.
Click to expand...
 
Top