Activate another form in Maximised mode

[Pradeep]

I have a form which opens up another form in pivot chart view. I want
to Save the pivot form as bmp. I have used the code from Steve lebans
to save the form as bmp. My problem is whenever i click on the first
form it opens the pivot form in small size , picture of form is
captured and then the pivot form gets maximised. thus the picture
saved is of small size. Even after maximising the form on its open
event it gets maximised only after the image is captured. If only I
could open the pivot form in maximised mode in the first instance the
complete image will be captured.

Or else I open the pivot form in maxised mode. I go back to the first
form. click on the button which activates the pivot form and captures
the image. but I don't know how to activate the pivot form

I hope my question is clear. Please let me know of any solutions.

 

[gumby]

I have a form which opens up another form in pivot chart view. I want
to Save the pivot form as bmp. I have used the code from Steve lebans
to save the form as bmp. My problem is whenever i click on the first
form it opens the pivot form in small size , picture of form is
captured and then the pivot form gets maximised. thus the picture
saved is of small size. Even after maximising the form on its open
event it gets maximised only after the image is captured. If only I
could open the pivot form in maximised mode in the first instance the
complete image will be captured.

Or else I open the pivot form in maxised mode. I go back to the first
form. click on the button which activates the pivot form and captures
the image. but I don't know how to activate the pivot form

I hope my question is clear. Please let me know of any solutions.

Create a command button on your form to call the pivot form with the
following function (You can also do this with a macro). I assume you
are talking about a pivot chart.

Function MaxFormPivotChart()
On Error GoTo MaxFormPivotChart_Err

DoCmd.Echo True, ""
DoCmd.OpenForm "Enter Form Name Here", acFormPivotChart, "", "", ,
acNormal
DoCmd.Echo True, ""
DoCmd.Maximize
DoCmd.Maximize


MaxFormPivotChart_Exit:
Exit Function

MaxFormPivotChart_Err:
MsgBox Error$
Resume MaxFormPivotChart_Exit

End Function

 

[Pradeep]

Create a command button on your form to call the pivot form with the
following function (You can also do this with a macro). I assume you
are talking about a pivot chart.

Function MaxFormPivotChart()
On Error GoTo MaxFormPivotChart_Err

DoCmd.Echo True, ""
DoCmd.OpenForm "Enter Form Name Here", acFormPivotChart, "", "", ,
acNormal
DoCmd.Echo True, ""
DoCmd.Maximize
DoCmd.Maximize

MaxFormPivotChart_Exit:
Exit Function

MaxFormPivotChart_Err:
MsgBox Error$
Resume MaxFormPivotChart_Exit

End Function

Thanks

I'll give it a try and let you know.