[AccessD] Run Report in Another Database

 Could it be something like this ?

    Dim zzForm             As Form
    . . .
    ' *******************************************************
    '  Call some VBA Public Code from another Form.
    '
    Set zzForm = [Forms]![zJP709aBookEdit]
    Call zzForm.aaLoadBookMark
    Set zzForm = Nothing


-----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