MoveSize for form AND report

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

I have a report which is opened from a menu from.

DoCmd.OpenReport "Pain_Diary_Detail", acViewPreview, , , acWindowNormal

That report opens a menu form using:

DoCmd.Restore
DoCmd.MoveSize 300, 1750
DoCmd.OpenForm "ManageReports", acNormal, , , acReadOnly, acWindowNormal,
"Pain_Diary_Detail"
DoCmd.SelectObject acForm, "ManageReports"
DoCmd.MoveSize 7000, 700

What I'm trying to do is to open the report, do a movesize as above, then
open the form "ManageReports" and do a movesize for the form. The movesize
for the report works great...the movesize for the form does not.

The report is setup:
AutoResize = No
AutoCenter=No
PopUp = Yes
Modal = No
BorderStyle=Dialog

The form is setup:
AutoResize = No
AutoCenter=No
PopUp = Yes
Modal = No
BorderStyle=Thin

I need to move the form out from under the report so the users can see/use
it. Does anyone see anything I'm doing wrong? What I'm looking for is the
report on the left side of the screen and the form on the right side of the
screen. Like I said the report is positioning properly. I just don't get it.

Thanks in advance for your help.
 
PeterM said:
I have a report which is opened from a menu from.

DoCmd.OpenReport "Pain_Diary_Detail", acViewPreview, , , acWindowNormal

That report opens a menu form using:

DoCmd.Restore
DoCmd.MoveSize 300, 1750
DoCmd.OpenForm "ManageReports", acNormal, , , acReadOnly, acWindowNormal,
"Pain_Diary_Detail"
DoCmd.SelectObject acForm, "ManageReports"
DoCmd.MoveSize 7000, 700

What I'm trying to do is to open the report, do a movesize as above, then
open the form "ManageReports" and do a movesize for the form. The
movesize
for the report works great...the movesize for the form does not.

The report is setup:
AutoResize = No
AutoCenter=No
PopUp = Yes
Modal = No
BorderStyle=Dialog

The form is setup:
AutoResize = No
AutoCenter=No
PopUp = Yes
Modal = No
BorderStyle=Thin

I need to move the form out from under the report so the users can see/use
it. Does anyone see anything I'm doing wrong? What I'm looking for is
the
report on the left side of the screen and the form on the right side of
the
screen. Like I said the report is positioning properly. I just don't get
it.

Thanks in advance for your help.
Click to expand...
 
PeterM said:
I have a report which is opened from a menu from.

DoCmd.OpenReport "Pain_Diary_Detail", acViewPreview, , , acWindowNormal

That report opens a menu form using:

DoCmd.Restore
DoCmd.MoveSize 300, 1750
DoCmd.OpenForm "ManageReports", acNormal, , , acReadOnly, acWindowNormal,
"Pain_Diary_Detail"
DoCmd.SelectObject acForm, "ManageReports"
DoCmd.MoveSize 7000, 700

What I'm trying to do is to open the report, do a movesize as above, then
open the form "ManageReports" and do a movesize for the form. The
movesize
for the report works great...the movesize for the form does not.

The report is setup:
AutoResize = No
AutoCenter=No
PopUp = Yes
Modal = No
BorderStyle=Dialog

The form is setup:
AutoResize = No
AutoCenter=No
PopUp = Yes
Modal = No
BorderStyle=Thin

I need to move the form out from under the report so the users can see/use
it. Does anyone see anything I'm doing wrong? What I'm looking for is
the
report on the left side of the screen and the form on the right side of
the
screen. Like I said the report is positioning properly. I just don't get
it.

Thanks in advance for your help.
Click to expand...
 
Try moving the MoveSize into the Open event of the form itself. That's where
I usually put MoveSize.
 
Back
Top