Heenan, Lambert
Lambert.Heenan at AIG.com
Mon May 12 10:57:24 CDT 2008
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