User Profile

Collapse

Profile Sidebar

Collapse
gbaii
gbaii
Last Activity: Mar 5 '09, 01:00 PM
Joined: Feb 27 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • gbaii
    replied to Login Access with user rights
    That solved my problem very nice.
    Thank you.
    Best regards,
    gabriel
    See more | Go to post

    Leave a comment:


  • gbaii
    replied to Login Access with user rights
    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
    ...
    See more | Go to post

    Leave a comment:


  • gbaii
    replied to Login Access with user rights
    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...
    See more | Go to post

    Leave a comment:


  • gbaii
    started a topic Login Access with user rights

    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....
    See more | Go to post
No activity results to display
Show More
Working...