need code for form

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

I need to make a form for a vacation system we want people
to sign up for their vac on it but we want to limit the
number so after a certain number is reached on a certain
day, we like it to stop accepting vacation on the full
days,....any ideas on the code?


Thanks
Dean
 
Dean,

If you create a normal table and form with all the fields you need. You
could code the before insert event for a form to count how many existing
records there are for a certain day and then stop the record from being
added if it exceeds your limit (how u specify your limit depends on how the
limit is worked out...). The DCount function would be usefull for this type
of thing...

HTH,

Neil.
 
Back
Top