Prev: Print Preview (Close button) Toolbar
Next: Deploy a tool Developed in Access 2003
From: Phil on 15 Apr 2010 13:22
I have a report (RptPaymentRecord) which if I open it in preview and then
print it - no problems If I open the report in preview from a form
(PaymentRecord) which basically shows the same data as in the report then
print it, again no problems
If I open that form from a Menu form, then open the PaymentRecord Form then
open the RptpaymentRecord in preview, again no problems. If I then go to
print the report, the printer queue shows it is spooling, then that message
vanishes and nothing prints.

Obviously the problem appears to be "Too many databases open" though I don't
get an error message. I don't really want to close the PaymentRecord form
prior to printing, as it takes quite a few seconds to open again . Somehow I
would like to close the preview version of the report and open it again
normally (ie in print mode).

Any bright ideas please?

Phil
From: Salad on 15 Apr 2010 13:43
Phil wrote:
> I have a report (RptPaymentRecord) which if I open it in preview and then
> print it - no problems If I open the report in preview from a form
> (PaymentRecord) which basically shows the same data as in the report then
> print it, again no problems
> If I open that form from a Menu form, then open the PaymentRecord Form then
> open the RptpaymentRecord in preview, again no problems. If I then go to
> print the report, the printer queue shows it is spooling, then that message
> vanishes and nothing prints.
>
> Obviously the problem appears to be "Too many databases open" though I don't
> get an error message. I don't really want to close the PaymentRecord form
> prior to printing, as it takes quite a few seconds to open again . Somehow I
> would like to close the preview version of the report and open it again
> normally (ie in print mode).
>
> Any bright ideas please?
>
> Phil

You aren't a newbie and know what you're doing so maybe some
experimentation is required. Why not create a new database, copy your
mainmenu, form, and report over along with your tables/links and
requisite queries for the process and try it from the new database?
Same thing?
From: Phil on 15 Apr 2010 19:12
On 15/04/2010 18:43:12, Salad wrote:
> Phil wrote:
>> I have a report (RptPaymentRecord) which if I open it in preview and then
>> print it - no problems If I open the report in preview from a form
>> (PaymentRecord) which basically shows the same data as in the report then
>> print it, again no problems
>> If I open that form from a Menu form, then open the PaymentRecord Form then
>> open the RptpaymentRecord in preview, again no problems. If I then go to
>> print the report, the printer queue shows it is spooling, then that message
>> vanishes and nothing prints.
>>
>> Obviously the problem appears to be "Too many databases open" though I don't
>> get an error message. I don't really want to close the PaymentRecord form
>> prior to printing, as it takes quite a few seconds to open again . Somehow I
>> would like to close the preview version of the report and open it again
>> normally (ie in print mode).
>>
>> Any bright ideas please?
>>
>> Phil
>
> You aren't a newbie and know what you're doing so maybe some
> experimentation is required. Why not create a new database, copy your
> mainmenu, form, and report over along with your tables/links and
> requisite queries for the process and try it from the new database?
> Same thing?
>

Spot on, Salad. I was convinced it was a "Too many databases open error". I
have found in the past that that particular error is not always reported
correctly, but as you surmised, it was a corrupt Db

Thanks again

Phil
From: Salad on 15 Apr 2010 20:33
Phil wrote:

> On 15/04/2010 18:43:12, Salad wrote:
>
>>Phil wrote:
>>
>>>I have a report (RptPaymentRecord) which if I open it in preview and then
>>>print it - no problems If I open the report in preview from a form
>>>(PaymentRecord) which basically shows the same data as in the report then
>>>print it, again no problems
>>>If I open that form from a Menu form, then open the PaymentRecord Form then
>>>open the RptpaymentRecord in preview, again no problems. If I then go to
>>>print the report, the printer queue shows it is spooling, then that message
>>>vanishes and nothing prints.
>>>
>>>Obviously the problem appears to be "Too many databases open" though I don't
>>>get an error message. I don't really want to close the PaymentRecord form
>>>prior to printing, as it takes quite a few seconds to open again . Somehow I
>>>would like to close the preview version of the report and open it again
>>>normally (ie in print mode).
>>>
>>>Any bright ideas please?
>>>
>>>Phil
>>
>>You aren't a newbie and know what you're doing so maybe some
>>experimentation is required. Why not create a new database, copy your
>>mainmenu, form, and report over along with your tables/links and
>>requisite queries for the process and try it from the new database?
>>Same thing?
>>
>
>
> Spot on, Salad. I was convinced it was a "Too many databases open error". I
> have found in the past that that particular error is not always reported
> correctly, but as you surmised, it was a corrupt Db
>
> Thanks again
>
> Phil

Glad you are onto other issues! :)
 | 
Pages: 1
Prev: Print Preview (Close button) Toolbar
Next: Deploy a tool Developed in Access 2003