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

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