Hello. I want to have a log in screen that triggers a Form based on a query so that the user can only see the records "assigned" to them. is that doable?
20:06 when you entered the password you landed on the User Form with TTT's information pulled, not Jsmith. I've tried using this code and one hiccup i'm running into is that no matter which Username I use, as long as the password entered is featured at all on the user table, it will let the staff logging in to gain access to the main menu. Please advise.
Hello, I have a problem with the command ... User = DLookup ("NameLang", "tblUser", "Personalnummer =" & TempVars! TempUserID) ... I always get a runtime error data conflict in criteria expression. My question is what am I doing wrong. The field data type is short text, with NameLong and with the Personalnummer.
I have something very similar to this in my database, but i would like to remove the password so people just type in a username to login, how would this be done??
hello add 'a tickbox label: 'Remember me' to the form add a field 'computername' to the user table find a code to get activeuser's computername from inyernet on_click event of OK button (after password check) add comp nane to created field on_load event of the login form, if comp name field iş not empty and equal to the active user comp name, log in automatically
You're missing the table where the UserID is stored... I think it should look like: //User = DLookup ("[Full Name]", "UserT", "UserID = " & TempVars!UserID) I use T in the back of my table fields to make it easier to recognize.
I have problem in my cod This message The expression on click you entered as the event property setting produced the following error: member already exists in an object module from which this object module derives
Man just discovered your channel...this password tutorial is very good!
How do you connect the UserType table with the User table, you skipped that part
How did you connect tbluser and UserType table ?
Same... He just cut that part it's frustrating
Great video! Thanks for sharing. Is there a way to add “forget password” link at bottom of user form? If not, how can user reset lost password? Thanks
Hello. I want to have a log in screen that triggers a Form based on a query so that the user can only see the records "assigned" to them. is that doable?
Did you solve this one already ? Would like to know as well
20:06 when you entered the password you landed on the User Form with TTT's information pulled, not Jsmith. I've tried using this code and one hiccup i'm running into is that no matter which Username I use, as long as the password entered is featured at all on the user table, it will let the staff logging in to gain access to the main menu. Please advise.
Is it going to work in MS Access 2016? (The Code) the ms access version seems old in the video. please reply Thank you 😇😇
Hello, I have a problem with the command ...
User = DLookup ("NameLang", "tblUser", "Personalnummer =" & TempVars! TempUserID)
... I always get a runtime error data conflict in criteria expression. My question is what am I doing wrong. The field data type is short text, with NameLong and with the Personalnummer.
Is the "Personalnummer" maybe misspelled "PersonalNumber"? or does that field have an ID?
I tried to follow the steps. the first time It works but after I shut down and I want to reuse nothing happens
Why does dlookup doesn't work in my pc?
I have something very similar to this in my database, but i would like to remove the password so people just type in a username to login, how would this be done??
hello
add 'a tickbox label: 'Remember me' to the form
add a field 'computername' to the user table
find a code to get activeuser's computername from inyernet
on_click event of OK button (after password check) add comp nane to created field
on_load event of the login form, if comp name field iş not empty and equal to the active user comp name, log in automatically
Please in fact I need the whole code to see where am lacking
I keep having this error
User = DLookup("[Full Name]", "UserID = " & TempVars!tempUserID)
You're missing the table where the UserID is stored... I think it should look like:
//User = DLookup ("[Full Name]", "UserT", "UserID = " & TempVars!UserID)
I use T in the back of my table fields to make it easier to recognize.
hello sir what is the user login form expiry set i try the code same of error showing pls any solution sir
I have problem in my cod
This message
The expression on click you entered as the event property setting produced the following error: member already exists in an object module from which this object module derives
You have a duplicate name of your sub procedure and module name.
i have checked.. no duplicate.. it shows "Run time error 13"@@austin72406
@Spanish Killer thank that helps
Can we pass username to the report.
Yes, do same thing like on form
@@austin72406 may I get your email or social network contact?
moving too fast. We are here to learn bro
Thank you
Thanks alot
If someone removes the inputmark and every password is visible. No security at all😁
😂
Молодец !
Too fast, cant even follow thing
Good, but you cut a lot of the work here, so...
Your video isn't clear
AHHHHHHHHHHHHHH
how the fuck your usertypeid work?
i declared it intigers in tbluser but IT DOESNT FCKNG WORK MEN
TOOK ME 3HRS TO DEBUGGING STILL DOESNT FCKING WORK
16:47
THIS VIDEO IS CORRUPTED AND MANY CUTS
It’s long and I have a lot of pause. So I have to cut it short. Sorry if it’s not smooth
@@austin72406 Dude you cut from nothing to navigation form what!?
What a terrible tutorial *sighing