Dynamic Big Buttons Forms for Data Entry, Part 6

In this Microsoft Access tutorial, I will show you how to add a cancel button to a dynamic form with big buttons for data entry, ensuring users can exit gracefully. This is part 6.

Members

In the extended cut, we will build a custom function called OpenBigButtonForm. I will show you how to set parameters like record source, ID field name, button text, where condition, and colors. This will simplify the process for future use, making it easier to create and customize big button forms. We'll also add color parameters for the forms.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Gold Member Bonus

There is also a special Gold Member Extended Cut Bonus. In this video, I'll show you how I added pagination to the BBF so that if you have more than 18 items, you can click Next to go to the next page, Previous to go back. If you're only a Silver member, this is your chance to upgrade!

•  03. Extended Cut Gold Member Bonus Video - Gold Members
•  Gold Bonus Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Big Button Form, Part 5

Links

• Color Picker
• Hex to RGB

Possible Future Upgrades

If you are interested in any of these optional items, post a comment down below and let me know what you'd like to see. If enough people want something, I may make another video about it, or perhaps put together a Template or Seminar on it.

• Center buttons horizontally
• Resize form for fewer buttons
• Proper data entry forms for Make, Model, Year
• Button to add the next year values
• Specify rows x columns in parameters
• "Other" choice which will then open a form with a listbox on it
• Pagination of buttons (so you could have 200 options and just page left and right thru them)
• Breadcrumbs for your choices up top
• Multi-select with option buttons instead of just one choice

Recommended Courses

• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, Dynamic Forms, Big Buttons, Microsoft Access, Data Entry, User Cancel Button, Form Close Events, Button Clicked Event, Resize Form, Temp Variables, VBA Code, Record Source Parameters, Error Handling, No Data Error, OpenBigButtonForm Function, Parameterized Forms, Custom Functions, TechHelp Video