Inputbox

L

legendv

Registered User.
Local time
Today, 10:43
Joined
Mar 18, 2002
Messages
99
On the doubleclick event I have an input box that asks for a password.

I want the form to open if inputbox = txtPassword and cancel if it doesn't.

I can't seem to "call" the inputbox string.

In the Open event looks something similar...

if txtpassword.text = inputbox.text then
'do nothing
else
docmd.close
form_frmMainMenu.visible = true
endif

How do you "call"/"recall" the inputbox's string that was entered?
 
Code: 
Dim strResponse as String

strResponse = InputBox("What is the password?","Logging in")

If strResponse <> txtPassword Then
   MsgBox "Sorry, wrong password. This database will now close.", vbCritical, "My Database"
   DoCmd.Quit
Else
   DoCmd.OpenForm "frmMainMenu", acNormal
EndIf
 
Mile,
You are wonderful!
Thanks!
Jon
 
You must log in or register to reply here.

Similar threads

T
Can someone please assist with the VBA code Below - Error Message 3075
Replies
16
Views
1,034
CJ_London
C
S
Password mask in InputBox massage
Replies
7
Views
1,841
Pat Hartman
P
U
LogIn hidden
Replies
16
Views
647
Mike Krailo
Mike Krailo
MajP
Using A Collection Class to Raise Common Event
2
Replies
33
Views
847
Pat Hartman
P
N
Solved Receiving Emails in Access Database using CDO 2000 library
Replies
10
Views
518
sonic8
S

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom