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???
What values should we enter to replicate the problem?
In this part of the code vCount never changes, so the loop is endless because vCount<=2 will always be true.
Actually, you appear to be repeating that loop quite a few times in the code and each time you set vCount equal to 1 before the loop starts.
Please Login or Register to view this content.
Last edited by Norie; 10-29-2013 at 10:52 AM.
If posting code please use code tags, see here.
well, I've been starting on 04/11/2013 and finishing on 10/11/2013 and using employee number 1.
Thanks!
See my edit.
so shall I take vCount out? that was part of the template so I just left it
To be honest I don't know what those loops or vCount are for, vCount doesn't appear to be used anywhere else in the code.
Actually I really can't work out what's happening in the code.
For example you have a nested if where every If statement has the same condition.
Where did you get the template from?Please Login or Register to view this content.
Did you make any of the changes that are suggested in the comments?
I got it from here:
http://bytes.com/topic/access/answer...edule-can-done
(I hope its ok to link!)
Basically I have 10 vans, 2 employees need to be on each van for each day, I copied his coding and tried to make it work, as everytime I changed a bit I had another error pop up and so fixed each individual error as it came. Now its a mess
I'm no good with coding, I can play with queries all day but I needed something fast and its just not turning out to be very fast, if anything just stressful! :P
Looks like the database in that link has been created for one person's specific needs rather than as a template.
What is it you actually want to do schedule wise?
well there are 10 vans out every day, 2 people need to be on each van. I need somewhere to type their off days and AL and then it work out that they shouldn't be on the rota. Each person needs to be with a different partner each day of the week, so it needs to be pretty random but not repeat in the same week. I don't know if I'm making sense. Its currently done manually which takes forever! This was the closest I could get to what I needed so I thought I could adapt it with my skills but obviously I'm more dumb than I thought I was as that code just obliterated my brain
Did you come up with any idea of what I could do? I still can't work out how to get this to work..
Thanks
Sorry for not getting back to you.
To be honest I couldn't figure out anything in Access, is this sort of thing perhaps more suited to Excel?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks