How to compare Text instead of number in a Macro (1 Viewer)

Umpire

New member
Local time
Today, 06:54
Joined
Mar 24, 2020
Messages
22
I have a macro to check for a password before opening a form. (I know not the most secure but secure enough for my need)
I have it working with a number password, but I would like to use a text password. Right now it is "5234" and i want it to be, for example "Go Knights Go!"
What do I need to change in this macro to do that?

Thanks
MACRO Password.PNG
 

Gasman

Enthusiastic Amateur
Local time
Today, 14:54
Joined
Sep 21, 2011
Messages
7,465
Exactly that, check for "Go Knights Go!"
 

Umpire

New member
Local time
Today, 06:54
Joined
Mar 24, 2020
Messages
22
OK, Now I feel stupid. I tried that before and It would not work. Now it does. It kept saying it could not find the name "Go Knights Go!"
Now it works fine.
Thanks for helping
 

Gasman

Enthusiastic Amateur
Local time
Today, 14:54
Joined
Sep 21, 2011
Messages
7,465
OK, Now I feel stupid. I tried that before and It would not work. Now it does. It kept saying it could not find the name "Go Knights Go!"
Now it works fine.
Thanks for helping
You probably did not surround the string with those double quotes (or single quotes) and so it thought you were talking about a variable, but I would have thought Access would think then it was just called Go, unless you surrounded it with [ and ]?
Never mind you have it working now.
 

Umpire

New member
Local time
Today, 06:54
Joined
Mar 24, 2020
Messages
22
Must have been something like that.
Thanks. Sometime having the obvious pointed out helps.
 

Users who are viewing this thread

Top Bottom