Access Form Profile Template

Many Profiles for Different Screen Sizes, Colors, Etc.

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

          Only $99
          Members pay as low as $49.50

Do you want to make it easy for users with different screen sizes to be able to work with your database? This template allows you to set up custom profiles optimized for different screen sizes, color profiles, visible controls, and lots more. Watch the free Introduction and Feature Walk-Thru videos, and see below for complete details.

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 switch between the different form profiles that I have designed, but you cannot change them, or 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. Be sure to watch the Introduction and Feature Walk-Thru videos (above) to see how to use it.

Full Developer Database

Once you have purchased the full developer database template, come back to this page and click on the Download button below. 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 Notes video is only for those people who are brave enough to attempt to modify my template. Good luck. LOL.

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

Features

Create Multiple Forms for Different Screen Sizes, Color Schemes, Users, etc.
Complete Profile Selector and Editor
Load, Change Design, Save Profile Configuration
Control Profile Loading on Startup via Command Line Switch

Introducing the Form Profile Template brought to you by Access Learning Zone. My name is Richard Rost. Do you want to make it easy for users with different screen sizes to be able to work with your database? This template allows you to set up custom profiles. You can set up special color options, different visible controls, and lots more. This template takes the existing forms in your database and allows you to save and load different versions of them. All the template does is modify the properties of your form and the controls in them. For example, here you see four different profiles for the same standard customer list.

A normal version in both blue and purple on the left, the green cell phone layout in the middle. That's great for remote users who maybe use it on their phones or their tablet devices logged in. And the big red one over on the right is for the power user. With that huge monitor on its desk. Again, this is the same form. So you only have to make design changes to one form. You only have one set of VBA code to worry. You just save multiple profiles for each form.

Here's a different form. The customer form, you see a black and white high contrast version in the upper left, below that a regular blue version. And below that one, a purple version, same form, different profiles. Here it's just different colors.

Some users like to make their own color palette changes, or if their hard of seeing they might want the high contrast version. Or you could have a manager version in purple that shows things like the credit limit and the blue version. For example, for the normal sales people, doesn't show that there's the little green cell phone version on the bottom. And to save space, you can show or hide different fields on each profile, if you want to. And finally up top is the big monster red version for the person with a huge monitor. You can either make the fields bigger. So they're easier to read or just cram a lot more stuff on each screen. The choice is yours.

There's a profile editor form, for the database administrator here. You can make design changes to the form and save them as a particular form profile. Then you switch profiles, load up that. And do it all over again, make as many profiles as you like.

You can allow the user to select which profile they want when the database loads, or you can set a default profile in the settings table.

If you prefer, you can also control which profile loads up by preparing a custom shortcut for each user. The choice is yours.

This template also includes my zoom tool. So if all you want to be able to do is make your forms bigger or smaller by zooming in and out, you can do that as well, without having to set up a custom profile.

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 (#03, above). I have written some of them out below, 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!
This template will only work with forms that have zero or one subform controls. Forms with two or more subforms are not supported. Yet. If there is enough interest, I can add that in the next version.
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 multiple subforms
More developer-friendly form profile setup

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, form profile editor, different screen sizes, zoom in, zoom out, form zoom level, Access Forms using with different screen resolutions, Access Form Resizing Based on Screen Resolution, zoom access forms, zoom access forms, automatic form resizing, form resizer, dynamically resize forms and controls

Comments for Access Form Profile Template

Age	Subject	From
2 days	Support for Multiple Subform	Jeffrey Kraft
3 years	Support for Multiple Subform	Carl Byerley
3 years	Form Profiles Zoom Feature	Carl Byerley
4 years	Access Form Profile Template	Howard Chapell

Subscribe to Access Form Profile Template
Get notifications when this page is updated

Intro

In this video, we will talk about the Form Profile template for Microsoft Access, which makes it easy to set up and manage custom profiles for your database forms to suit different screen sizes and user needs. You will see how to configure profiles with various color schemes, show or hide form controls, and optimize layouts for desktop, tablet, or mobile users, all without needing to redesign multiple forms or duplicate VBA code. We will also look at the profile editor for administrators and demonstrate features like allowing users to select their preferred profile or setting defaults.

Transcript

Introducing the Form Profile template brought to you by AccessLearningZone.com. My name is Richard Rost.

Do you want to make it easy for users with different screen sizes to be able to work with your database? This template allows you to set up custom profiles optimized for different screen sizes. You can set up special color options, different visible controls, and lots more.

This template takes the existing forms in your database and allows you to save and load different versions of them. All the template does is modify the properties of your form and the controls in them. For example, here you see four different profiles for the same standard customer list form - a normal version in both blue and purple on the left. The green cell phone layout in the middle is great for remote users who use it on their phones or their tablet devices logged in. The big red one over on the right is for the power user with that huge monitor on his desk. Again, this is the same form.

So you only have to make design changes to one form. You only have one set of VBA code to worry about. You just save multiple profiles for each form.

Here is a different form, the customer form. You see a black and white high contrast version in the upper left, below that a regular blue version, and below that one a purple version. Same form, different profiles. Here it is just different colors. Some users like to make their own palette changes or, if they are hard of seeing, they might want the high contrast version. Or you could have a manager version in purple that shows things like the credit limit, and the blue version, for example, for the normal sales people, does not show that. There's the little green cell phone version on the bottom. To save space, you can show or hide different fields on each profile if you want to. Finally, up top is the big monster red version for the person with the huge monitor. You can either make the fields bigger so they are easier to read or just fit a lot more stuff on each screen. The choice is yours.

There is a profile editor form for the database administrator. Here you can make design changes to the form and save them as a particular form profile. Then you switch profiles, load up that form and do it all over again. Make as many profiles as you like. You can allow the user to select which profile they want when the database loads, or you can set a default profile in the settings table if you prefer. You can also control which profile loads up by preparing a custom shortcut for each user. The choice is yours.

This template also includes my zoom tool. So if all you want to be able to do is make your forms bigger or smaller by zooming in and out, you can do that as well without having to set up a custom profile.

For more information or to download a sample copy of this template, visit my website at accesslearningzone.com. I have got another video that walks you through using the template and explains some of the features in more detail. You will find a link you can click on in the description down below the video. There it is right there.

Thanks for watching, and if you have any questions, please feel free to post them in the comments down below. Thanks for watching.

Quiz

Q1. What is the main benefit of using the Form Profile template described in the video?
A. It allows users to create multiple forms from scratch for each device.
B. It optimizes forms for different screen sizes and user needs by customizing a single form.
C. It requires users to manually adjust properties each time they use a form.
D. It automatically detects the user's device model and redesigns the database.

Q2. How does the template handle changes for different user needs?
A. It creates separate forms for each user.
B. It allows saving and loading different profiles that modify form properties and controls.
C. It forces all users to use the same standard form settings.
D. It only changes the background color of forms.

Q3. What is one example given in the video of how a profile might be useful for users with special requirements?
A. Adding extra security layers to a form.
B. Creating a separate database for each user.
C. Making a high contrast version of a form for users with vision difficulties.
D. Allowing users to delete database records.

Q4. What does the template allow you to do with form fields in different profiles?
A. Permanently remove fields from all forms.
B. Only change field names for each profile.
C. Show or hide different fields based on the selected profile.
D. Make all fields read-only in every version.

Q5. How are design changes managed when using the template?
A. You must edit every version of the form separately.
B. All design changes must be programmed in VBA for each user.
C. You only make design changes to one form and save multiple profiles.
D. You have to export profiles to an external program.

Q6. What options are available for selecting which profile loads when the database is opened?
A. Only the database administrator can choose.
B. A random profile loads each time.
C. Users can select their preferred profile, set a default in settings, or use a custom shortcut.
D. The oldest profile always loads.

Q7. What additional feature does the template include besides custom profiles?
A. Built-in report writing tools.
B. An automatic backup system.
C. A zoom tool for resizing forms.
D. Email integration for sending forms.

Q8. What is the intended outcome for users when using this template?
A. Users must learn VBA to customize profiles.
B. Users can easily work with forms tailored to their device and needs without complex changes.
C. Users have limited access to form features.
D. Users must adjust their device settings before using forms.

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

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 introduces the new Form Profile template, designed to make it easier for users with various screen sizes to work efficiently in your Access database. I'm Richard Rost, and I'm going excited to show you how this template can help you create custom profiles for your forms, allowing you to optimize them for different devices and user preferences.

With this template, you can create and store multiple versions, or profiles, of the existing forms in your database. Each profile can have its own color scheme, visibility settings for different controls, and other customizations. The template works by modifying the form and its controls' properties, but it still uses the same underlying form. For example, you might have a standard customer list form, and you can save separate profiles for standard users on desktop PCs, remote users accessing via mobile devices, or even power users with large monitors. The style, layout, and colors can be different for each profile, but you only need to maintain one actual form and one set of VBA code.

Let's look at the customer form as another example. Here, you might want a high-contrast black and white version for users with vision challenges, plus regular blue or purple versions for other users. You could have a special manager profile that includes sensitive information like credit limits, while the version for sales staff omits that data. If you want to streamline things for phone or tablet users, you can create a compact green cell phone layout profile and show or hide form fields as you see fit. For users with large screens, a profile can offer larger, more readable fields or simply fit much more data on the screen at once. This approach keeps your database manageable, since everything is tied to just one form per function.

The Form Profile template also includes a profile editor form for administrators. You use this to make design changes to a form and save them as distinct profiles. You can switch between profiles, edit or create new ones, and store as many as you need. When your database opens, you can prompt your users to select a profile or set a default in the settings table. There is also the option to define which profile launches for each user by setting up custom shortcuts. This gives you complete control over each user's experience.

Along with the profile feature set, this template offers a convenient zoom tool. If you only need to adjust your forms' size for readability without making full profile changes, you can simply zoom in or out to suit the user's preference.

For more details or to download a sample version of the Form Profile template, be sure to visit my website at accesslearningzone.com. I've prepared another video tutorial that provides a step-by-step walk-through on using the template and highlights some of the features in greater detail. You will find the link to this on my website.

If you have any questions, just leave a comment and I'll be happy to help. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Overview of the Form Profile template for Access
Creating custom profiles for different screen sizes
Setting color options for different user profiles
Modifying visible controls per profile
Saving and loading form versions as profiles
Managing one form design with multiple profiles
Adjusting profiles for accessibility needs
Showing or hiding fields based on user roles
Using the profile editor to manage form profiles
Allowing users to select a profile on database load
Setting a default profile with a settings table
Assigning custom shortcuts to user profiles
Using the built-in zoom tool to resize forms