password protected form

ariansman

Registered User.
Local time
Yesterday, 22:13
Joined
Apr 3, 2012
Messages
157
can we make a form to prompt for a password before opening so that only those who know the password can open and use that form?
thank you
 
The code I posted in the Open Form with Password thread should be of use.

Code:
Private Sub Form_Open(Cancel as Integer)
  Dim PassWord As String

  PassWord = InputBox("Enter Administrator Password")
  Cancel = ( PassWord <> "password")

  If Cancel Then MsgBox ("You're not authorized for Administrator access.")
End Sub
 
thank you, that was great :)
 
Hi! I am just new and totally novice to coding and database. Unfortunately I have a problem. I have a database of access'97 in which there is a table which stores passwords for four users. None of the users are available. The VB program along with this inputs data and takes report prints. Now I need the passwords hidden inside the table else I can not proceed any further. I have the particular table exported to new .mdb and .xls but how do I decrypt the codes in which the passwords are stored? I exported this to text file and attached here.
Can some one please help me showing the passwords? Or the way out?
Thanks and regards
=======================================
"SUPER","«¥¶*±¥„„„„"
"NKRC","²¶§•–—„„„„"
"JIT","¥¯‘˜›„„„„„"
"PB","´¦–˜•–•„„"
"CKM","šš””—„„„„"
=========================================
 

Attachments

Users who are viewing this thread

Back
Top Bottom