Open Databases Exactly Where You Want Them

Do you want your Microsoft Access databases to start right up where you want them instead of just wherever the last database you had open was? Do you use multiple access databases at the same time and you want them to open up in their own spots whenever the database opens? That's why I built the Access Save Position Template.

Videos

•  01. Introduction (2:26) - Free
•  02. User Guide (12:38) - Free
•  03. Developer Guide (13:06) - Paid

Sample Database

If you'd like to download a sample copy of the database template, you can do so here. This is a non-editable ACCDE version of the template which will let you see it work in action. You can save a database's position, close it, and open it back up again to see how it works. However, you cannot access the design of the forms, reports, VBA, etc. The sample database requires 64-bit Access 2013 or higher. If you're still using 32-bit Office, read this.

•  Demo Database Download - Free

Full Developer Database

Once you have purchased the full developer database template, come back to this page and download the full template. This will give you access to the ZIP file containing the Template ACCDB file. The full version will run on 32-bit or 64-bit Access 2007 or higher. Be sure to watch the User Guide video (above), and visit the Instructions page. The Developer Guide video is only for those people who are brave enough to attempt to modify my template. Good luck. LOL.

•  Full Database Download - Paid

Purchase Template

Please be sure to read the Before You Purchase section below before buying this template.

Features

• Remember Database Screen Position
• Save Wherever You Like
• Automatically Move/Size on Startup

As you can imagine, I've got several databases that I use throughout the day. I got my customer database, my task database, my calendar database, and lots. Let's say I open up my customer database and it opens up on the right side of my screen.

OK. Now I'm done working with the customer database, so I close it. Next I want to open up my task database. It opens up where the last database was. 

So I gotta move it over to the left side of the screen where I want it and I have to resize it and make its menu bigger. I also want to size it vertically so I can use the screen area to the right of it. That's a lot of work. 

OK. Done for the day. I come in tomorrow, I open up my customer database again and I, it's opening up on the left side where the task database was. That's the way that Access works. It opens up wherever you last closed it. And if you're working with multiple databases and you want them to each have their own positions on the screen, that's tough.

So that's why I invented the Save Position Template for my own sanity more than anything. So I can open up my customer database and it opens up in the spot that I've got designated for it. And then I can open up my task database and it opens up and then it snaps to its location. And if I close them both and I come back tomorrow and I open up my task database, it knows where to go.

If I open up the customer database, it knows to go to its spot. That's how this template works. It'll work with any Microsoft Access database, with just Microsoft Access objects. There are no third-party components or anything. You can have it installed in any database in about five minutes. You just have to rename a few things, and copy a couple objects over to your database. That's it. And I've also got a basic developer guide video if you decide you wanna make any customizations to it.

Before You Purchase

A few important notes before you purchase this template:

• Please note that this is NOT a teaching database. You should have a strong background in developing Microsoft Access applications before attempting to setup this template with your database. You don't have to be an expert with Visual Basic, but you should know a little VBA. I strongly recommend taking my Access Developer 1 course first or at a bare minimum watching my Intro to VBA video. 
• In order for this template to work properly, you must follow the instructions in the User Guide video, above. I have also written the instructions out, but be sure to watch the video and follow it carefully so that everything works OK in your database. If you post a comment saying that it's not working, and you didn't follow the steps, I'm going to say "I told you so."
• Backup. Backup. Backup again! Be sure to test this on a backup copy of your database first!
• Remember, we do our best to help you here in the Forums on the website, but technical support is not guaranteed.

Possible Future Upgrade Ideas

If you are interested in any of these, please post a comment below.

• Support for maximized databases. The Maximize Application Window TechHelp video shows how to do it. If enough people are interested, I'll add it to the template.

License

For internal use only. This template does NOT come with a royalty-free license. You may only customize the template for your business needs and for use within your organization at one location ONLY. You may not resell or distribute any form of this template to others without express written permission. Contact me for additional information on obtaining a license to distribute if you plan on including this template in a product you are reselling. Additional licenses are required if you plan on using this template with more than ten (10) employees or in multiple locations within your organization.

Not a Finished Product

Please keep in mind that most of my template databases are not designed to be finished products that are ready to go in a working environment. My templates are meant as starting points for you to customize for yourself so you don't have to reinvent the wheel. This requires that you have a basic understanding of Microsoft Access development. To work on most of my databases you should have completed my Access Beginner series and the first couple levels of my Expert series at a minimum. Most of my databases require knowledge of SQL and VBA as well. 

Customize For Your Needs

If you would like to discuss customizing this template for your needs, and integrating it into your current setup, please see my consulting page for details. While I no longer accept custom jobs that are specific to a single user, I may include your features in a future version of this template if they have mass appeal. If you are looking for custom enhancements made to this template just for you, visit my Developer Network.

Technical Support

Please note that technical support is NOT guaranteed for any of my courses, seminars, or templates. If you require help with modifying this template, you may post a question in the Forums, however an answer to your question is not guaranteed. If this template comes with an accompanying Seminar, then you should purchase that Seminar to see how the database was constructed. If not, then you should have taken the suggested courses. Most of my templates are designed on a Developer level and you should have a thorough understanding of SQL and VBA before attempting to modify them. If you have a problem with one of my databases, I will only support the unmodified database exactly as it's downloaded from my site. If you have modified it in any way, it may not be something I can help you with. You can post in the Forums, and I may be able to help you, but if the issue doesn't exist in my unmodified database, it's not something I can support.

Questions?

Got sales or customer service questions about this template? Feel free to contact me. If you have technical "how do I" questions about this template, you discover a bug, or want to suggest a new feature, then please post your comments below.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #template, save database window position, open access database in specific location, move windows