Heenan, Lambert
Lambert.Heenan at AIG.com
Mon May 12 15:30:07 CDT 2008
Sorry for the delay: been doing some work. :-) "Setting a reference" open up any code module in the mdb that is going to be calling the other database. On the Tools menu select 'References'. In the resulting dialog box click the Browse button and navigate to the location of the other database and select the MDB/MDE file. You now have a reference to the other database and any public code in it can be executed from the first database simply by using the identifier for the Sub/Function (and passing any parameters it may need.) 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 12:54 PM 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