Member Avatar for deadelgabar

i`m working with access 2007, i have two tables SYS_USER, ACCOUNT TYPE.
the first table contains (username, password, first name, last name).
the second table is only one field (manager, admin, agent).
there are two forms (administration, login), the administration form adds a new user, the login form makes user log in to the system.
the code is working perfectly, but i`m just missing something, i need a code that checks if the user is admin, agent, or manager. then according to the selection a msgbox appears "hi admin", "hi manager", "hi agent".

i attached the code, the login screen, the admin screen.
thanks in advance.

Create_New_User.png 17.51 KB Login_Screen.jpg 46.6 KB
New_Microsoft_Office_Word_Document.docx (10.46 KB)
  • 2 Contributors
  • 1 Reply
  • 138 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

You need to add USER_TYPE column to SYS_USER table.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.