[AccessD] Running a report in an external database

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Sat Mar 19 18:25:37 CST 2005


Stuart:

That did it. Thanks.

Rocky

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Saturday, March 19, 2005 3:03 PM
Subject: Re: [AccessD] Running a report in an external database


> On 19 Mar 2005 at 11:23, Rocky Smolin - Beach Access S wrote:
>
>>
>> 'Open Reports.mdb hidden, print Report and close that mdb.
>>
>> Dim acc As Access.Application
>> Set acc = CreateObject("access.application")
>> acc.OpenCurrentDatabase ("c:\Acessdat\Reports.mdb")
>> acc.DoCmd.OpenReport "rptEvictionCase-MemoToSet", acViewNormal
>> acc.CloseCurrentDatabase
>> Set acc = Nothing
>
> You have told the hidden Access Application to close its current database,
> but not to close itself, so you still have a hidden instance of Access 
> with
> no open database.
>
> Try acc.Quit instead of  acc.CloseCurrentDatabase.
>
>
>
> -- 
> Stuart
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list