Access Save Position Template

Open Databases Exactly Where You Want Them

S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark

          Only $99
          Members pay as low as $49.50

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

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. Keep in mind that most of my templates are not like off-the-shelf software. They're starting points for developers to be able to modify and use as their own. It really is going to be in your benefit to watch all of the prerequisite videos so you understand the database and how it works moving forward. This is not like QuickBooks where you just install it and use it. My templates are mostly designed for people who already have an understanding of how Microsoft Access works.

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, position access application window

Comments for Access Save Position Template

Age	Subject	From
3 years	Cant Copy Over the Forms	Kathy Henry
3 years	Updater and Save Position	Eduardo Benaim
4 years	Maximizing Feature	James Yoder

Subscribe to Access Save Position Template
Get notifications when this page is updated

Intro

In this video, I will show you how to use the Save Position Template for Microsoft Access to make your databases remember and restore their exact position and size on your screen each time they are opened. We will talk about how this feature can help if you work with multiple databases and want each one to open in a specific spot every time. I will show you how easy it is to set up using only built-in Microsoft Access features, without any third-party add-ins, and how to install it in your own databases quickly.

Transcript

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 want them to open up in their own spots whenever the database opens? That is why I built the Save Position Template.

Hi, this is Richard Rost with AccessLearningZone.com. As you can imagine, I have several databases that I use throughout the day. I have my customer database, my task database, my calendar database, and lots more.

Let's say I open up my customer database and it opens up over here. I set it in position there and close it. Now, I open up my task database and now it is over here, where the last database was closed. I have to move it over where I want it, resize it like this, and make this menu bigger. I might want it tall vertically so I can do stuff next to it, maybe even use this database. Then, I close this one and then I close the other one.

When I come in tomorrow, I open up my customer database again, and it is opening up over here now because that is the way that Access works. It opens up wherever you last closed it. If you are working with multiple databases and want each to have its own position on the screen, that is tough to do.

That is why I invented the Save Position Template for my own sanity more than anything. I can open up my customer database and it opens up in the spot that I have designated for it. Then, I can open up my task database and it opens up and snaps over here. If I close this one and I close the other one, and come back tomorrow and open up my task database, it knows where to go. It knows its spot. If I open up the customer database, it knows to go over here. It might start to open up over here, but once it loads, Access moves it over here.

That is how this template works. It works with any Microsoft Access database using just Microsoft Access features. There are no third-party components or anything you have to install. There is a complete user guide on my website. It also comes with a template you can install in any database. It takes about five minutes. You just have to rename a few things and copy a couple of objects over to your database. That's it.

I have also provided a basic developer guide if you decide you want to make any customizations. For more information on the Save Position Template, if you want your Access databases to open up exactly where you want them on your monitors, check out my Save Position Template.

Again, this is Richard Rost with Access Learning Zone. If you have any questions, feel free to post them down below or contact me. Thanks.

Quiz

Q1. What problem does the Save Position Template solve in Microsoft Access?
A. It ensures databases open to the position and size you want every time.
B. It allows databases to open faster.
C. It increases the storage capacity of the database.
D. It changes the background color of database windows.

Q2. Why does Richard Rost mention he created the Save Position Template?
A. For his own sanity while working with multiple databases.
B. To improve database search speed.
C. To allow simultaneous editing by multiple users.
D. To reduce Access installation time.

Q3. What happens by default when you open a Microsoft Access database?
A. It opens in the position where you last closed any Access database.
B. It opens maximized across all monitors.
C. It always opens in a default top left position.
D. It opens in a minimized state.

Q4. What is required to use the Save Position Template?
A. Copy a few objects and rename some items in your database.
B. Install third-party components.
C. Upgrade to the latest version of Windows.
D. Modify the Access installation files.

Q5. Does the Save Position Template require any third-party software?
A. No, it uses only Microsoft Access features.
B. Yes, it requires paid add-ons.
C. Yes, it needs additional drivers.
D. Yes, an internet connection is needed at all times.

Q6. What additional resources does Richard provide along with the template?
A. A user guide and a developer guide.
B. Free Microsoft Access license.
C. Video editing software.
D. Annual maintenance support.

Q7. How long does it typically take to install the Save Position Template?
A. About five minutes.
B. A few hours.
C. An entire business day.
D. Over a week.

Q8. What can you do if you want to customize the Save Position Template?
A. Use the provided developer guide.
B. Contact Microsoft technical support only.
C. Rewrite the template from scratch.
D. Only use it as is without any changes.

Answers: 1-A; 2-A; 3-A; 4-A; 5-A; 6-A; 7-A; 8-A

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Access Learning Zone discusses how you can control where your Microsoft Access databases appear when you open them. If you often work with several Access databases at once, you might have noticed that they tend to open wherever the previous database was last closed. This behavior can get frustrating, especially if you like to keep your databases organized on your screen in particular spots.

I run into this situation myself because I regularly use multiple databases throughout my day, such as my customer database, my task database, my calendar, and several others. For instance, I might position my customer database in one area of my screen, close it, and then open my task database only to find it pops up in that same spot instead. I end up constantly moving and resizing windows to get everything the way I like it. This gets even more tedious when I come back the next day and have to do it all over again, since each database always opens in the last-used position.

Because of this, I created the Save Position Template. With this tool, each database remembers its own designated place on your screens. When I open my customer database, it appears right where I want it. When I switch over to my task database, it moves into the spot I picked for that one. The next day, each database remembers where it should go and restores itself to the spot I indicated, even if Access tries to start it somewhere else initially.

The Save Position Template works with any standard Microsoft Access database and does not require any third-party software or installs. Everything you need is included, along with a full user guide to help you get set up. Installing it in your own database only takes a few minutes and involves renaming a few items and copying some objects over.

If you want to customize the template further, a basic developer guide is included as well. So, if you want your Access databases to always appear exactly where you want on your monitors, I recommend trying out my Save Position Template.

For more information, visit my website to find a complete video tutorial with step-by-step instructions on everything we discussed here. Live long and prosper, my friends.

Topic List

This is a promotional overview describing the Save Position Template for Microsoft Access, which lets users control where each Access database window opens on their screen.