Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Reports

Status
Not open for further replies.

PeterL

IS-IT--Management
Joined
Oct 30, 2000
Messages
129
Location
US
I open 2 reports in preview mode using a macro. The reports open on top of each other. How can I control the placement of the reports on the screen? I would like to open the 2 reports side by side.

Thanks
 
look into this
DoCmd.RunCommand acCmdTileVertically
 
Thanks, this works but it tiles the forms that are open at the same time. I want to leave the form centered and position only the 2 reports.
 
This code will exclude forms before tiling vertically
Dim frm as form
For each frm in forms
DoCmd.SelectObject acForm, frm.Name
DoCmd.Minimize
Next


Best of luck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top