Using single button to run multiple query

  • Thread starter Thread starter Gajanan
  • Start date Start date
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?
 
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/
 
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/
 
Back
Top