Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update queries - update several at once

Status
Not open for further replies.
Zonie32

Zonie32

Technical User
Jan 13, 2004
242
US
Hi. I have about 42 update queries that I need to run each week. Is there a way to have these run at once? Or do I need to run them separately every time? Can a macro be written to make them run with one click of a button? Any help is appreciated.
 
Sort by date Sort by votes
A macro is a very easy solution.

Another option is create a macro for one and use the facility to save it as a VBA procedure. Then go in and edit it to do the other 41 queries.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
1K
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
2K
TheresAlwaysAWay
TheresAlwaysAWay
MattGreer
  • Locked
  • Question
Can't update a field from a query result due to 'Group By'
Replies
2
Views
314
dhookom
dhookom
BTilson
  • Locked
  • Question
Virtually Identical Select Queries - One Works, Other Doesn't?
Replies
2
Views
452
combo
combo

Part and Inventory Search

Sponsor

Back
Top