 | |
access2007 maximizing a report
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
access2007 maximizing a report -
11-29-2010
, 02:53 PM
#2
| |||
| |||
|
|
I have the following function that usually works but occassionally, the "DoCmd.RunCommand acCmdZoom100" statement fails with a The command or action 'Zoom100%' isn't available now. , i'm thinking it's a timing issue, ie. the report is not yet opened is there a way of making sure the report is opened / displaying data ? Public Sub openReport(strReport As String, Optional strWhere As String = "") On Error GoTo fErr DoCmd.openReport strReport, acViewPreview, , strWhere DoEvents DoCmd.RunCommand acCmdZoom100 DoEvents DoCmd.Maximize DoEvents fExit: On Error Resume Next Exit Sub fErr: If (Err <> 2501) Then errorLog "openReport " & strReport & " " & strWhere End If Resume fExit |
You're right, the open event is too soon to do that. Try
using the Activate event or the report header section's
Print event. If all else fails, the safe place is back in
the form that opens the report, right after the OpenReport
line.
--
Marsh
#3
| |||
| |||
|
|
Roger wrote: I have the following function that usually works but occassionally, the "DoCmd.RunCommand acCmdZoom100" statement fails with a *The command or action 'Zoom100%' isn't available now. , i'm thinking it's a timing issue, ie. the report is not yet opened is there a way of making sure the report is opened / displaying data ? Public Sub openReport(strReport As String, Optional strWhere As String = "") * *On Error GoTo fErr * *DoCmd.openReport strReport, acViewPreview, , strWhere * *DoEvents * *DoCmd.RunCommand acCmdZoom100 * *DoEvents * *DoCmd.Maximize * *DoEvents fExit: * *On Error Resume Next * *Exit Sub fErr: * *If (Err <> 2501) Then * * * *errorLog "openReport " & strReport & " " & strWhere * *End If * *Resume fExit You're right, the open event is too soon to do that. *Try using the Activate event or the report header section's Print event. *If all else fails, the safe place is back in the form that opens the report, right after the OpenReport line. -- Marsh- Hide quoted text - - Show quoted text - |
the report without the need to change every report, so using the
activate / print event would defeat that goal
as to putting the zoom after the call to openReport, it would only be
a doevents and a 'maximize' later, I doubt the report would be open
maybe I can check the reports collection, with error checking, hoping
that once the report is in the collection, it is loaded
#4
| |||
| |||
|
|
maybe I can check the reports collection, with error checking, hoping that once the report is in the collection, it is loaded |
contains only open reports. You can use the Reports collection and
try to match the name of the report you are trying to open. The
Documents collection can be used to list of all the reports in the
database, whether open or closed.
James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com
#5
| |||
| |||
|
|
I'm looking for a generic 'open report' function, so that I maximize the report without the need to change every report, so using the activate / print event would defeat that goal |
--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.