Get User Input with InputBox in Access VBA

In today's video, I'll show you how to use the InputBox function in Microsoft Access VBA to prompt the user for some input. We will create a Manager Menu form and if the user attempts to open it, he will be asked for a password.

Nasir from Baltimore, Maryland (a Platinum Member) asks: I have a few forms in my database that have some sensitive information on them, like employee payroll data. Is there any way I can password protect just those forms?

Members

Members will learn how to create a password form that echo's asterisks (*) as the user types. This will keep any nosey Nancys in your office from spying your password over your shoulder.

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

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!

Recommended Course

• Access Developer 3: https://599cd.com/ACD3

Pre-Requisites

• Simple Security: https://599cd.com/SimpleSecurity
• Intro to VBA: https://599cd.com/IntroVBA
• If Then: https://599cd.com/IfThen
• Variables: https://599cd.com/Variables
• MsgBox: https://599cd.com/MsgBox

Links

• Security Seminar: https://599cd.com/Security
• Error Handling: https://599cd.com/ErrorHandling

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

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, inputbox function, prompt for user input, username, password, Hide Password in Input Box