Dual Screen and VBA

[FoeHunter]

I have a form, cleverly called “background” that is maximized to “hide” the access program. The only problem is when someone is using more than 1 monitor, the background is sometimes is displayed on the other monitor…hiding nothing. Is there a way to have access check to see what screen it is displayed on and put it all on the same one or is this just a windows quirk?

Clear as mud?

 

[FoeHunter]

I found a website that explains this perfectly, however, the solution

http://www.ozgrid.com/forum/showthread.php?t=39176&page=1

   Me.Top = Application.Top
   Me.Left = Application.Left

appears to only apply to excel (or possibly only older versions of office?)

 

[FoeHunter]

Probably not the “right” way to do this, but by using the following code, I move the form to the screen that access is open on, then executes the rest.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

Private Sub Form_Load()
' Resizes the window
    'http://msdn.microsoft.com/en-us/library/aa221370(v=office.11).aspx
    Forms(0).Move _
        Left:=0, Top:=0, Width:=0, Height:=0
    DoCmd.Maximize
' Centers the image horizontally
    Me.Image1.Left = (Me.InsideWidth - Me.Image1.Width) * 0.5
' Places the image just above vertical center
    Me.Image1.Top = (Me.InsideHeight - Me.Image1.Height) * 0.4
    DoCmd.OpenForm "MainMenu"
End Sub

I figured someone else will find a use for this in the future.