Edward S Zuris
edzedz at comcast.net
Mon May 12 14:08:55 CDT 2008
For the curious, what is the answer ? -----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] FW: Run Report in Another Database 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com