REPOST: A2000 and Win98

[Darren]

I posted this orginally below and Greg provided a good
suggestion on cleaning up the program. However it does not
fix the problem....

I'll try to provide as much info as I can.

I have an application in A2000 that contains a lot of
reports. I have built a form that acts as a switchboard or
menu with lots of buttown that exceutre PREVIEW's of each
report on the screen.

I need to keep the report menus open (they pass data to
the queries that the reports are based on). I have put a
little code in the buttons that activate the report to
minize my report menu and maximize the report. Here is a
sample:

stDonName = "Sales Lead Report - Detail"
DoCmd.OpenReport stDocName, acPreview

DoCmd.SelectObject acForm, "CReportMenu"
DoCmd.Minimize
DoCmd.SelectObject acReport, stDocName
DoCmd.Minimize

This opens the report then minimizes the menu then
maximizes the report.

In the "On Close" for the report I have the following code:

DoCmd.SelectObject acForm, "CReportsMenu"
DoCmd.Restore

This restores my report menu so that the user can select
another report.

This was developed on a machine running W2000 and my
current version of MS Access is (9.0.6926 SP-3).

When this is run on some machines with Win 98 I get an
error saying "This operation cannot be run at this time"
or something similar at the point just after the report is
activated and the menu is being selected so that it can be
minimized. The program halts and will not respond.

Futhermore I get wierd results on the report itself. For
example, if the report should contain 5 pages the first
page will be OK, then there will be 6 blank pages. The
close box will not work and the only way to get out is to
C-A-Delete.

I had this problem a couple of weeks ago on a W98 machine
and was told by the local IT guy that it was that computer
and he would rebuild it. He did, it still does not work.

I did an installation myself today on two machines and had
the problems on both. I noticed that the client's Office
2000 had not been updated. So I spent several hours doing
al the patches and got Access upgraded to the same version
as mine, no luck.

Any suggestions? HELP

 

[Dan Artuso]

Hi,
You can try it with simpler logic and see if that works.
In the Open event of the report simply use:
DoCmd.Maximize

In the close event of the report:
DoCmd.Restore

See if that works for you