We're a community of 1.1M IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,080,623 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

Create administration in access 2007 using vba (vip)

HI everyone...
i`m working on access 2007.
i have two table called USER, and USER_PRIVILEGES
i created a form with bound text boxes and bound check boxes.
the text boxes are for the user information(first name, last name , ...etc)
the bound check boxes are for (print report, delete, modify ,....etc)
and a button save to add new user.
the question is..
how can i give for every user certain privileges.
example:-
the admin can delete, modify, or insert new data.
the regular agent can only view these data without modifying or deleting and can insert.
so what should be done is when i enter the user information i select some privileges.
so where should the code be........ ???????
i attached a picture of the administration form..
please if can anyone help that will so very kind of him.
thank for reading :)

Attachments administration.jpg 79.39KB
1
Contributor
0
Replies
1
View
deadelgabar
Light Poster
31 posts since Apr 2010
Reputation Points: -1
Solved Threads: 0
Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
View similar articles that have also been tagged:
 
© 2013 DaniWeb® LLC
Page generated in 0.0495 seconds using 2.64MB