Create a Data Entry Form in Microsoft Access

In this video, I'm going to to teach you what a Data Entry Form is. You'll see how to take an existing form and make it a Data Entry Form. I'll also show you how to create two separate buttons to open a form normally, or in Data Entry mode. 

Billie from Winnipeg, Manitoba (a Gold Member) asks: is there a way that I can have my secretary click a button and just start entering in new contacts for a customer? I don't really want her seeing the entire contact history, just log new calls and messages. Thanks!

Members

Members will learn how to open a form in Data Entry mode using VBA, and will also see how to password protect the "show previous contacts" button, and switch Data Entry mode OFF with one click.

• Extended Cut Video - Silver
• Gold Member Template Download - Gold

Silver Members and up get access to an Extended Cut of this video. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to contact me so I can set up your account here on my web site. If you're not a member, Join Today!

Links

• Intro to VBA: https://599cd.com/IntroVBA
• Simple Security: https://599cd.com/SimpleSecurity
• Security Seminar: https://599cd.com/Security

Learn More FREE Access Beginner Level 1 Access Level 2 for $1.00 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? Questions? Please feel free to post your questions or comments below or submit them via the TechHelp page.

Keywords

microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, What is data entry, data entry forms, how do you do data entry, enter data into, Data Entry property, DataEntry, adFormAdd, ApplyFilter, cancel filter, cancel apply filter, disable filter