Using single button to run multiple query

G

Gajanan

I want to use single button on the form to run multiple queries. How it can
be done? Where should I write queries and code?
 
J

Jeff Boyce

One way to do this would be to create your queries, then use the command
button to run code that calls each query. Another approach would be to
create all your queries, then create a macro that runs all your queries, and
call that macro using code behind a command button.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
G

Gajanan

Can you provide me sample code?

Jeff Boyce said:
One way to do this would be to create your queries, then use the command
button to run code that calls each query. Another approach would be to
create all your queries, then create a macro that runs all your queries, and
call that macro using code behind a command button.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 

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

Top