By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
463,081 Members | 556 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 463,081 IT Pros & Developers. It's quick & easy.

Restrict field selection based on criteria in ms access

P: 5
i have an employee table which has a field named department.i want the users to receive a message that no more employees can be assigned to this department because a certain limit has reached.the users will be using forms in ms access to insert the details.is it possible to do so using vba?

What I have tried:

i have created a query which calculates the current no of employees in department.the limit lets say currently is 5,more than 5 employees in a department is not allowed.i tried validation criteria on table level but no luck there as the expression is wrong.
3 Weeks Ago #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.