| | |
|
|
|
HELP!!! VIEWING REPORTS IN NORMAL WINDOW |
|---|
| message from Chris on 19 May 2004 |
I HAVE A FRONT END DATABASE WHERE I SETED UP THE FORMS TO MAXIMIZE AT OPEN.
THE PROBLEM IS THAT THE REPORTS ARE ALLWAYS OPENING IN THE SAME WAY
(MAXIMIZED), WHILE I NEED THEM IN A NORMAL WINDOW.
IF I MODYFY THE SIZE OF THE REPORT WINDOW, THE FORMS ARE DOING THE SAME
AUTOMATIC.
HOW CAN I SOLVE THIS PROBLEM?
I AM THANKING YOU FOR ANY HELP PROVIDED!!!
|
| John Vinson replied to Chris on 19 May 2004 |
First off... please lay off the CAPS LOCK KEY. It is hard to read and
looks like you are SHOUTING AT US. All lower case is preferable if you
have trouble with the shift key.
Maximizing any Access object automatically maximizes all of them. You
can put a little bit of VBA code in the Open event of a Form or Report
to maximize or restore the object:
Private Sub Form_Open(Cancel as Integer)
DoCmd.Maximize
End Sub
Private Sub Report_Open(Cancel as Integer)
DoCmd.Restore
End Sub
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| =?Utf-8?B?Um9zY28=?= replied to Chris on 19 May 2004 |
Chris,
Try this.
In a module
Function OpenReport_Your_Report_Name()
DoCmd.OpenReport " Your_Report_Name",acPreview
DoCmd.Restore
End Function
Use the fuction to open the report
If your forms were set to open in normal mode, and you want the report to open maximized,
change the restoore command to:
DoCmd.Maximize
Hope this helps
Rosco
FYI - Please do not use all caps in your posts. It is considered impolite, and is difficult for some people to read.
Thanks
|
| Chris replied to =?Utf-8?B?Um9zY28=?= on 22 May 2004 |
Thank you very much!
and is difficult for some people to read.
|
|
Archived message: HELP!!! VIEWING REPORTS IN NORMAL WINDOW (MS Access Error Message)
