Database crashing and coding errors

Hi All,

I used a template to creat a rota to allocate staff to vans, the database crashes when I try to generate a 7 day week, it says Error Overflow... but the employee is as long integer!?

Also I need to ask access to look at the void date table and tell me if that person is off on that day and so ignore them.

Any one out there able to help???