H
Howard Brody
Depends on the type of query you're trying to run.
If it's an Append, Delete, Make-Table or Update query, I
just build the SQL string in VBA and use the DoCmd.RunSQL
command . . . except that dosn't work for Select queries.
I've done this a couple of times. You still need to build
a SQL string but then use the CreateQueryDef method (check
the Help files for the details) for saving it as a query
in your db. Then you can run it.
Hope this helps!
Howard Brody
If it's an Append, Delete, Make-Table or Update query, I
just build the SQL string in VBA and use the DoCmd.RunSQL
command . . . except that dosn't work for Select queries.
I've done this a couple of times. You still need to build
a SQL string but then use the CreateQueryDef method (check
the Help files for the details) for saving it as a query
in your db. Then you can run it.
Hope this helps!
Howard Brody