A2K blank pages in report (error 2486)

[wvmitchell]

When you select a report from the custom menu, the report Open event opens a modal popup form where the user selects the criteria and group/sort expression, then clicks OK to preview the report with those settings. The report Close event closes the popup form. Simple enough, you would think.

On three out of about 15 PC's, as you click to view successive pages, from page 7 & up (of 22 pages) the report is blank. After you view the blank pages, you can still navigate forwards & backwards thru the report, and zoom in and out, but - Access stops responding to the close button (top right corner) on the report window. If you click the close button on the main Access window, it displays error 2486:

"You can't carry out this action at the present time. You tried to run a macro or used the DoCmd object in Visual Basic to carry out an action. However, Microsoft Access is performing another activity that prevents this action from being carried out now."

Clicking Debug on the error message highlights the DoCmd.Close "name of the modal popup form" in the report Close event. This same logic is used on dozens of other reports, and they work just fine.

The three "bad" machines are: Win95, no SR-1; Win98, no SR-1; Win98, with SR-1 installed. They all connect to the same network printer. A fourth machine using the same printer works OK.

 

[Lozere]

I'm a little bit surprised you open a modal form in the Report_Open - why there? - and wait till the Report_Close to close it?
A suggestion:
Why don't you select the parameters (Group/sort and criteria) in your main form, put them in Public variables and further get them from these variables in the Report_Open?

Could be more ruggerised.

 

[wvmitchell]

Sorry, I didn't mean both modal and popup, you wouldn't be able to see the report behind the form.

This was an inherited project. I don't care for the previous developer's methods, but I need to make his stuff work :-(

 

[Lozere]

OK, clearer!

BUT... I have no other suggestion that the ones I gave you last night or something like that move this form launched from the report to a form closed before the report opens.

For sure I can't appreciate how tricky it is to make such a move!

 

[Guest_imported]

I have found the same problem!! Did you manage to solve it? This error 2486 is driving me crazy!!

I hope you can help me too!

 

[Guest_imported]

I have recently encountered the same problem. Does anybody know a fix for it? It seems that Access gets lost and doesn't properly release internal locks when a docmd is completed. Any Help out there?? Thanks n Cheers Gary

 

[johnss]

My database has been working fine for several months and then today I started getting the same error that was mentioned above. I had a back up copy on my harddrive and used it without any problems. The original database was on the network now neither will work. Any ideas?