[AccessD] FW: Run Report in Another Database

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Mon May 12 13:02:14 CDT 2008


Lambert:

Never mind.  I figured it out from your post.  

Thanks. 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: Rocky Smolin at Beach Access Software [mailto:rockysmolin at bchacc.com] 
Sent: Monday, May 12, 2008 9:54 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Run Report in Another Database

Lambert:

Can you be more specific about "set a reference"?

Thanks

Rocky
 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Monday, May 12, 2008 8:57 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Run Report in Another Database

The simplest way is to define a public Sub or Function in the other database
that runs the report. Then in your first MDB set a reference to the other
database. Once the reference has been set you will be able to call the Sub
or Function and have the report run. 

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Monday, May 12, 2008 11:02 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Run Report in Another Database

Dear List:
 
What's the command or syntax look like to run a report which is in another
MDB?
 
MTIA
 
Rocky
 


 	
	
 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 

 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.16/1427 - Release Date: 5/11/2008
1:08 PM
 




More information about the AccessD mailing list