Save Position Template: https://599cd.com/blog/display-article.asp?ID=2520

2 Options:

1. You can stretch Access to cover 2 screens, then Open one Form on one screen and a second Form on the other screen.

2. You can make the 2'nd Form a "Pop-up" Form in the Options Tab of the Properties.  This will allow you to move the Form outside the Access Window.

-Raymond

Thanks for the response Raymond, but it's a Database I want to position not a form. Alex, thank you I'll have a look at that template later today.

PowerToys with FancyZones might be an option.

I can open a second database and drag it onto a different screen.  Are you asking if this can be a default setting for that database?

I tried to find a solution to this online, but found tons of responses for having a application open to a specific screen, but these don't seem to understand that  you can open multiple instances of an application with different files... ie multilple word documents, multiple Excel documents, multiple Access databases... this is where you'd want to tell the application which monitor you want.

Unfortunately, it looks like there is not a solution for this with Windows.  There were several bogus answers that were not correct.

I think this would be a good option to have, but I'm not sure what could be done to make this happen.

-Raymond

Hi all, Thank you all for your suggestions. problem now solved and it was Alexes's first suggestion that reminded me that I did this, with (Richards help of course) in one of the Fitness series. Turns out the answer was in Fitness 38 with the Positioning Module and associated code. My code vault database now appears on my second screen, while my others appear on my main screen! Thanks again to all.

Update. Yesterday it worked fine but today my other databases are following the position and size of my code vault...I don't think that should happen. Have I got to put the positioning code in all databases, even those in development? Or have I done something wrong?

I think an app just remembers which screen it was last open on, so if the last db you close is on 2, the next time you open Access, any db, it'll open there.
Same if it were Chrome or Excel etc

Yes Alex you are right, but databases with Richards positioning Module & code sit where ever you want them. For example I can open Fitness 68 and it always opens on screen 1, then open my code vault database and it sits nicely on screen 2. Both these have the code. If I then open the new database I'm working on it opens on screen 1 or 2 and resizes to match either Fitness or code vault depending on which I had open last.