Manny has attended:
Access Intermediate course
Access Advanced course
2 forms, seperate monitors, full screen
Hello all,
I would like to launch a "dual screen" view on my application.
I tried stretching one form across the 2 screens but it seems i cannot do so.
So i decided to open 2 seperate forms and maxmise them.
How do i go about getting the size of each across both monitors? i have tried
DoCmd.MoveSize 3, 3, 25000, 15500 but i am just guessing.
the process will work like this
1. on click
2. open 2 seperate forms and full size them form1 on screen1 and form2 on screen2.
Please help :)
RE: 2 forms, seperate monitors, full screen
Hi Manny,
The quick answer is I'm not sure.
I've had a quick google on the forums and there are code samples out there for controlling the position of your user form but the main concern seems to be the opposite of yours. Most people are concerned with the form staying on the same monitor as excel rather than going to the primary monitor.
Access VBA is just different enough from Excel VBA so I can't give you anything more helpful than that. I'm assigning this to Jens but I know he's doing a lot of delivery at the moment. He will get back to you as soon as he can and I hope he can give you something more helpful.
thanks
Claire
RE: 2 forms, seperate monitors, full screen
Hi Manny,
Thank you for the forum question.
I hope that you are fine.
I do not have dual screens, but by doing some research I found some links (see below). I cannot test it with only one monitor, but please see if the code below is doing what you want.
You need as you suggested yourself to use DoCmd.
The line:
DoCmd.MoveSize -500, 0, 1200, 1200
will move the second form 500 pixels to the left of your primary monitor and place it on the secondary monitor.
DoCmd.OpenForm "FactualExpenses", acNormal, "", "", , acNormal
DoCmd.Maximize
DoCmd.OpenForm "tblDepartment", acNormal, "", "", , acNormal
DoCmd.MoveSize -500, 0, 1200, 1200
DoCmd.Maximize
If you look at the links below you will find other solutions:
https://www.experts-exchange.com/questions/23543186/Open-form-on-a-second-monitor.html
https://groups.google.com/forum/ #!topic/comp.databases.ms-access/ctPwUEeV9kQ
https://accessdatabasetutorial.com/open-access-database-full-screen-opening-form-maximized/
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
