Maxinize Report

Just started having a problem with maximizing a report window.

The report has Docmd.Maximize in the on open event. The report is not Modal. The problem seems to be intermittent and I cannot for the life of me see what is causing it. Access 2002.
Derek BrownMDAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
Try to insert:

  DoEvents

before maximizing.

/gustav
0
Derek BrownMDAuthor Commented:
Thank you, thank you.

Confused though! Why only some reports and do we really have yo say "Do something" and then say "No, we really want you to do it this time!"

Why some and not others?
0
Gustav BrockCIOCommented:
Hard to tell, but such issues are often timing issues; the report both renders and reads code at the same time. DoEvents pauses until Access thinks it is not busy doing other Things.

Another option could be to move the maximize command to the Load event.

/gustav
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Jeffrey CoachmanMIS LiasonCommented:
Try Gustav's suggestion first, then report back to him...

...and this report has not been modified in any way?
Has this database ever recently been opened/modified in Access 2003 or newer?
There were some issue with Report settings specific to 2003 and newer, affecting reports in prior versions (event though those properties were not used..)

Is this only for this one report or all reports?
Is this issue for all users or only one user?

The report may also be going corrupt, ...so make sure you do the usual...
...Compile the code and run the Compact/repair utility on a regular basis.

At the extreme end you can try creating a new db and importing all the objects...

But if you posted a small sample database with a report that exhibits this issue, I am sure any expert can spot what the issue is...

;-)

Jeffcoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Derek BrownMDAuthor Commented:
Thank you both

Taking out Docmd.Maximize in the on open event fixed it .

Taking out the instruction to maximize the report solved the problem and made the report maximize anyway. What is going on????

That is so weird.
0
Gustav BrockCIOCommented:
Weird. However, I don't maximize reports so I have no idea.

/gustav
0
Jeffrey CoachmanMIS LiasonCommented:
Well if the report was "nearly" maxed when you closed it, it will open that size again.

A lot here is not know for sure.
What "Document Window" option you have set?
What state is the form in when it is closed?
Any other code that would affect this...

In other word, please do not accept posts as the solution if the solution is unknown.

JeffCoachman
0
Derek BrownMDAuthor Commented:
OK Jeff

So Docmd.Maximize does not maximize eh?  Just when I thought I had this Access stuff cracked.

Thanks jeff
0
Jeffrey CoachmanMIS LiasonCommented:
<Docmd.Maximize does not maximize eh? >
I never said that...
;-)

You never replied to my questions?

The only way to be sure is if you posted a sample of this database that demonstrated this issue.

But again, if my post did not solve your issue, then please request that it be un-accepted.

;-)

JeffCoachman
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.