That solved my problem very nice.
Thank you.
Best regards,
gabriel
User Profile
Collapse
-
code
Hi again. You were right. it's a accdb.
the code for the login button looks like this:
Private Sub Command5_Click( )
'check if there is a user name
If IsNull(Me.Combo employee) Or Me.Comboemploye e = "" Then
MsgBox "Trebuie introdus un nume de utilizator.", vbOKOnly, "input required"
Me.Comboemploye e.SetFocus
...Leave a comment:
-
Access 2007
Hi. Thx for the answer you provided. But it doest help me because I use Access 2007 as I stated in the subject. I shall give you more details: I use a table with the fields: IDuser, username, password, access_type. and in this table I have 4 records. Two of them has in the access_type field the word "admin" and the other two has the word "user". In my login form i have a combo box where are the names...Leave a comment:
-
Login Access with user rights
Hi all. Being new to access and wanting to build some kind of basic CRM software, I have the following problem. I have a table called users with the fields: UserID, UserName, UserPass and UserType. There are let's say 2 records with "admin" word in the UserType field and 3 more records with the "user" word in the same field. After the user is putting his password and hit login button, i need to open the "base" form....
No activity results to display
Show More
Leave a comment: