Hi,
I am looking to restrict users to accessing certain forms, tables and reports.
I'm not sure what the best way to go by doing this.
Basically there will be two user logins (maybe a 3rd for the Admin).
the 1st User logins will be for the Manager and Supervisor (same login and password). They will have full access to the Data etc.
The 2nd Set of user logins are for the rest of the staff. They will all use the same login and password. They will only be able to access one button on the main menu which is a form. Restrictions on certain fields will also be on the Form.
- I'm guessing I need to
A) Create a form for the logins
B) Hide and lock fields from them in the property sheet. And either disable all the buttons except for the one on the main form or Just Hide them. Or is it more technical than this?
If there is alot of VBA coding, which i'm guessing there is especially for the Logins. What do I put in there? Do I need A workgroup to put my users in?