MoveSize - Extended Monitor

[Tieval]

Hi,

I have a database with a number of pop-up forms with no borders or control buttons (to make it look pretty).

I realise that you cannot do a lot with extended monitors and form positions but can you use a button to move a form?

I am thinking that if I have the database popup form auto-centred on the first screen I could use a button to move it to the second (move to say 25000, 4000,,).

If this is achieved, can other pop-up forms open relative to the form position of the form they have been opened from?

Any help would be greatly appreciated.

 

[llkhoutx]

Yes, you can move a form with action initiated by a button. Using 2 monitors to display forms seems to me to be a poor design. I built and used complex form database programs, but have never seen the necessity or utility of using 2 monitors to display them.

 

[Tieval]

There is a simple answer to this, I have a database that is used on a PC but want to teach people how to use it on a big screen, I do this in extended monitor mode as I like to keep my own monitor private so dual display mode is no good.

I have done it with buttons which is a bit clumsy as each form needs moving with a button whenever it is opened and was hoping to find a way to detect the extended mode.

Unfortunately I do not think this can be done as a PC set to extended mode has an extended monitor whether one is connected or not and therefore it could detect the mode and automatically place the form off-screen (in the area the screen would have been).

 

[CJ_London]

investigate using the form.move method - you can specify coordinates there where 0,0 is top left of the access window.

https://msdn.microsoft.com/en-us/library/office/ff845906.aspx

 

[CJ_London]

with regards detecting a monitor - have a look at this link

http://stackoverflow.com/questions/...ut-on-which-monitor-a-powerpoint-slideshow-is

 

[Tieval]

For anybody else's benefit in future here is what I have done.

I put an option group in the main form with standard monitor or extended monitor and created an if statement for the two states doing a movesize to 1000,1000 for standard and 25000,1000 for extended.

I placed the if statement in the on-update of the option group and used a similar thing for all the buttons that opened sub-forms.

When you select extended monitor it moves it across 24000 (onto the second screen) and opening any of the sub-forms puts them monitor dependent.

A bit crude but it works.