Page Navigation Controls show up only sometimes?

[scs]

I have a macro for maximize and a macro for minimize. I use them on a
reports open and close events. I like for a report to open maximized and
then when I close it restore everything else.

My problem is that when I open some reports with multiple pages sometimes I
can see the page navigation controls in the lower left corner of the report
and somtimes I can't. If I click restore and then maximize again the
controls always show up. It there a way to make them always appear when I
first open a report using the maximzie macro?

Quite possibly there is a better way to have a report open maximized than my
macro method. If so I'd be grateful for the advice.

TIA
Steve

 

[Pieter Wijnen]

Several Ways
Simple solution:
Add DoCmd.Maximize To the report Open Event And / Or Activate Event
either in Code [Event Procedure]
'-->
Sub Report_Open(Cancel As Integer)
Access.Docmd.Maximze
End Sub
Sub Report_Activate()
Access.Docmd.Maximze
End Sub

And Then on The Close / Deactivate:
Sub Report_Open(Cancel As Integer)
Access.Docmd.Restore
End Sub
Sub Report_Activate()
Access.Docmd.Restore
End Sub

Or Assign your Max/restore Macros to the OnOpen/Activate/Close/deactivate
Properties of the Report

Personally the only Macro I ever use is the AutoKeys macro in my systems,
but ...

HTH

Pieter

 

[scs]

Thanks much!

Several Ways
Simple solution:
Add DoCmd.Maximize To the report Open Event And / Or Activate Event
either in Code [Event Procedure]
'-->
Sub Report_Open(Cancel As Integer)
Access.Docmd.Maximze
End Sub
Sub Report_Activate()
Access.Docmd.Maximze
End Sub

And Then on The Close / Deactivate:
Sub Report_Open(Cancel As Integer)
Access.Docmd.Restore
End Sub
Sub Report_Activate()
Access.Docmd.Restore
End Sub

Or Assign your Max/restore Macros to the OnOpen/Activate/Close/deactivate
Properties of the Report

Personally the only Macro I ever use is the AutoKeys macro in my systems,
but ...

HTH

Pieter

I have a macro for maximize and a macro for minimize. I use them on a
reports open and close events. I like for a report to open maximized and
then when I close it restore everything else.

My problem is that when I open some reports with multiple pages sometimes
I can see the page navigation controls in the lower left corner of the
report and somtimes I can't. If I click restore and then maximize again
the controls always show up. It there a way to make them always appear
when I first open a report using the maximzie macro?

Quite possibly there is a better way to have a report open maximized than
my macro method. If so I'd be grateful for the advice.

TIA
Steve

 

[scs]

I changed my database to use vba to max and min reports. I noticed I still
have the issue of the page navigation buttons not showing up. I narrowed it
down to this: It only happens when I have show tools bars off in startup
options. I need to play with this but it appears that when show tool bars
is off, reports that open maximized may not show their page navigation
buttons in the lower left corner.

Thanks
Steve

Several Ways
Simple solution:
Add DoCmd.Maximize To the report Open Event And / Or Activate Event
either in Code [Event Procedure]
'-->
Sub Report_Open(Cancel As Integer)
Access.Docmd.Maximze
End Sub
Sub Report_Activate()
Access.Docmd.Maximze
End Sub

And Then on The Close / Deactivate:
Sub Report_Open(Cancel As Integer)
Access.Docmd.Restore
End Sub
Sub Report_Activate()
Access.Docmd.Restore
End Sub

Or Assign your Max/restore Macros to the OnOpen/Activate/Close/deactivate
Properties of the Report

Personally the only Macro I ever use is the AutoKeys macro in my systems,
but ...

HTH

Pieter

I have a macro for maximize and a macro for minimize. I use them on a
reports open and close events. I like for a report to open maximized and
then when I close it restore everything else.

My problem is that when I open some reports with multiple pages sometimes
I can see the page navigation controls in the lower left corner of the
report and somtimes I can't. If I click restore and then maximize again
the controls always show up. It there a way to make them always appear
when I first open a report using the maximzie macro?

Quite possibly there is a better way to have a report open maximized than
my macro method. If so I'd be grateful for the advice.

TIA
Steve