querydef

I

inungh

I just wanted to make my app clean, because there are too many queries
stored on the mdb file.

I tried to stored my SQL in my table like tblSQLstring and retrieve
them to use currentDB.execute strMYSQL, dbFailOnError

It works fine,

The only thing is when I need run more than one query to get my result
set.

I need run second query against the first recordset.

I tried to use querydef.SQL and use mydb.execute strMYSQL.

Are there any better solution for this method?

Your help is great appreciated,
 

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

running SQL in the VBA code 2
currentdb.execute 10
3022 error while run update SQL 1
running VBA code to run Crosstab query 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Runnign a QueryDef from CmdBtn on a form 4
Help with calling Stored Procedure on SQL Server 5
query to show where no data in a stated column 0

Top