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

Umpire

Member
Local time
Yesterday, 21:24
Joined
Mar 24, 2020
Messages
46
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, 05:24
Joined
Sep 21, 2011
Messages
7,898
Exactly that, check for "Go Knights Go!"
 

Umpire

Member
Local time
Yesterday, 21:24
Joined
Mar 24, 2020
Messages
46
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, 05:24
Joined
Sep 21, 2011
Messages
7,898
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

Member
Local time
Yesterday, 21:24
Joined
Mar 24, 2020
Messages
46
Must have been something like that.
Thanks. Sometime having the obvious pointed out helps.
 

Users who are viewing this thread

Top Bottom