MS Access Form to prompt for username and password for an approval

lbradbury

New Member
Joined
May 14, 2020
Messages
46
Office Version
  1. 365
Platform
  1. Windows
Hello,

I have a database that I'm developing for a purchase requisition, I have the form mostly designed. I have field that will require a username and password input. I'm just not sure how to do that, when the field is clicked to approve the form, to prompt for a username and password.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

lbradbury

New Member
Joined
May 14, 2020
Messages
46
Office Version
  1. 365
Platform
  1. Windows
I guess, I'm more asking of having a field on a form, that when clicked prompts for a username and password and looks to the table for validation.
 

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,827
Office Version
  1. 2019
Platform
  1. Windows
At its most basic, you can just lookup the password in a table.
Probably the pieces you would (or could, rather) use are:
  • environ("username") - (in the vba form code) to get the current logged in users name (unless you want to have your own login names in the database in a Users table)
  • DLookup() - (in the vba form code) to lookup the password entered in
  • a way to hide the password that is being typed in ( so it looks like ********* ) but I don't recall how to do this in Access
  • a Users table to store loginname/passwords
  • Hide the table from easy view (minimally)
It is difficult to overstate how weak and insecure this all is. But that would be the basics.

A more robust method (if you have the time and energy) has been posted here:
 
Last edited:

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
885
  • a way to hide the password that is being typed in ( so it looks like ********* ) but I don't recall how to do this in Access
Input Mask. Password option
 

Watch MrExcel Video

Forum statistics

Threads
1,129,512
Messages
5,636,764
Members
416,939
Latest member
Rajakumaran

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top