execute query

[Guest]

With the following code, i would like to execute a select query. Prior to
this line I have defined strSourceQuery and the syntax looks fine. If I open
qryDataSource from the query tab, it runs fine. But I get an error "can't
execute query" when I try to run the code. Any suggestions?

With CurrentDb.QueryDefs("qryDataSource")
.SQL = strSourceQuery
.Execute
End With

Thanks!!

 

[Guest]

To open a select query use

docmd.OpenQuery "QueryName"

You execute update/append/delete queries

 

[Guest]

Thanks, Ofer! I figured it was pretty basic. I've not run queries
programmatically before. Hope you live long and prosper, too.