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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you run a macro in another database

Status
Not open for further replies.
ToyFox

ToyFox

Programmer
Jan 24, 2009
161
US
I have a macro that runs a number of queries. However, one query resides in another database. I would like to run this macro from the "main macro"....How would I accomplish this?

Thx
 
Sort by date Sort by votes
The easiest way would be to import that query into your database and create links to the tables that it uses. You can do it in VBA code but the only way I know is a messy one of creating another instance of Access.

Geoff Franklin
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
662
renigar
renigar
ameedoo3000
  • Locked
  • Question
switch between two open database
Replies
12
Views
907
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
3K
grnzbra
grnzbra
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
569
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top