forms seperate monitors

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » 2 forms, seperate monitors, full screen

2 forms, seperate monitors, full screen

resolvedResolved · High Priority · Version 2016

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

Fri 21 Feb 2020: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips


Server loaded in 0.07 secs.