Hi,
I want to develop a cafeteria tracking system using Access & VB. Below are my requirements.
Users will key in food details in the system which will can be generated as reports for breakfast, lunch, dinner etc. into a excel file.
1. Users will key in their employee id (unique#), password set option to be available (password set, reset, unlock features for Admin)
Multiple Admin profile can be provided.
2. On entering employee id, User name, project details will be displayed.
3. User will select (Breakfast, lunch, snacks, dinner, midnight snacks, drinks) from the drop down to indicate when are they taking food.
4. User will be allowed maximum 28 entries in a month for drinks, system will not allow if exceeded
5. Breakfast, lunch, snacks, dinner, midnight snacks cannot be taken twice for a same employee id.
Can this be done in Access using VB script?
Please help. Thanks a lot.