Report Views...

[Guest]

When you open a form, how do you set it to automatically bring up a report
centered in a full page, with 150% Zoom? I use Access 2000.

Thanks!

 

[Guest]

I can't say for sure on 2000, but on 2003 there's an option "startup" under
the "tools" menu that let's you spedify what to open on startup.

CW

 

[Guest]

Ignore my previous post as the babblings of a complete idiot.

 

[Steve Schapel]

Heidelberg,

You can use a VBA procedure on the Open event of your form. I imagine
it might look something loke this...
DoCmd.OpenReport "NameOfYourReport"
DoCmd.Maximize
DoCmd.RunCommand acCmdZoom150

 

[Guest]

Hi Steve!

I used the following VBA:

Option Compare Database

Private Sub Report_Open(Cancel As Integer)

DoCmd.OpenReport "rptAllAssessmentsParameterBySchool"
DoCmd.Maximize
DoCmd.RunCommand acCmdZoom150

End Sub


However, I get a Run-time error 2585

This action can't be carried out while processing a form or report event.

What am I doing wrong?

Thanks for your help!

 

[Guest]

Hi Cheese whiz,

Thanks for thinking about me. I've seen the good work you did in other
messages. Do you know why I get an error message when I followed Steve's
suggestion?

 

[Guest]

Any more ideas on this?
I tried the code at "on open" in the report.
It maximized, but I get a message that says "The command or action Zoom 150%
isn't available now."
Funny, hehe.

A little tip.
Maximize on open and minimize on close on all my reports has taken away most
of my frustration regarding max/min with reports.

"Heidelberg" skrev:

 

[Guest]

Thanks for the tip...

It can get frustrating at times.

Did you get a Error Run-time 2585?

 

[Guest]

I get 2046.

/Claes

"Heidelberg" skrev:

Thanks for the tip...

It can get frustrating at times.

Did you get a Error Run-time 2585?