PC Review


Reply
Thread Tools Rate Thread

Call query or macro from seperate access db

 
 
samuel
Guest
Posts: n/a
 
      7th Jul 2009
I have a macro that opens two queries in c:\Query.mdb

I want to be able to call this macro (or query) from a seperate database
(C:\seperatedb.mdb)

How do I accomplish this?
 
Reply With Quote
 
 
 
 
Steve Schapel
Guest
Posts: n/a
 
      7th Jul 2009
Samuel,

You can use a RunApp macro in seperatedb. The Command Line argument will
have this type of syntax...
"C:\Program Files\...\Msaccess.exe" "C:\YourFolder\Query.mdb" /x NameOfMacro

--
Steve Schapel, Microsoft Access MVP


"samuel" <(E-Mail Removed)> wrote in message
news:3FBA1546-F936-43F9-A0E6-(E-Mail Removed)...
> I have a macro that opens two queries in c:\Query.mdb
>
> I want to be able to call this macro (or query) from a seperate database
> (C:\seperatedb.mdb)
>
> How do I accomplish this?
>




__________ Information from ESET Smart Security, version of virus signature database 4222 (20090707) __________

The message was checked by ESET Smart Security.

http://www.eset.com



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Call an Access macro from an Excel macro Jason W Microsoft Excel Misc 1 1st May 2008 08:33 PM
Macro to query data from a succession of websites and display in seperate sheets DrSues02 Microsoft Excel Programming 1 20th Oct 2004 09:22 PM
MS Access SQL Query to Seperate a Phone number column into three p =?Utf-8?B?RGFu?= Microsoft Access 6 28th Sep 2004 07:00 PM
How to call a MS Query (.dqy) in a macro? Jouni Microsoft Excel Programming 0 28th Sep 2003 06:30 PM
How to call a MS Query (.dqy) in a macro? madaboutiou Microsoft Excel Programming 0 28th Sep 2003 05:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:07 PM.