Search results

Hmm... i'm not exactly sure i'm afraid. I'm good at adapting code but not at fixing it! The only thing i have noticed is that you seem to have more brackets at the beginning of your code than you have at the end which could cause a problem. Good luck!

Great code - further help please! Hi, this piece of code works great and i have been able to adapt it to the working hours of my site. However i also need to be able to take holidays and shutdowns out of the timings. I have a table called holidays with one field called HolDate. This field...

can anyone help.........???? please????

I found a module on this forum that provides me with a function to calculate the number of working hours between two dates/times. It works really well but now i need to be able to take out bank holidays/company shutdowns etc. I have made up a table called "Holidays" with a field called...

This could very well be the problem! I am using UK date format - dd/mm/yyyy - i didnt realise that Access assumes dates are US format. How would i use the code shown in the link you posted? Apologies for my ignorance!

Hi - i got the following piece of code from this site and it works brilliantly for calculating working hours only and removing weekend days from the calculation. However - the removing holidays bit doesnt work and i cant figure out why! I'm not great with the VBA side of things, i can adapt...

Yippee!! Just thought i would finish off this thread as i finally found some code that works! In case anyone else needs the same kind of help here it is. Public Function NetWorkhours(dteStart As Date, dteEnd As Date) As Single Dim intGrossDays As Integer Dim intGrossHours As Single Dim...

Nearly! Gemma, Thanks for speedy reply - your suggestion seems to work partly but has thrown up a different problem. The way the forms work is that when the first form is closed a second one linked to it opens. When the second one opens it has a macro in its "on load" property which closes...

Ok - really need some help here. I have searched and searched but i think my problem is slightly different to the ones i am finding. Basically i have a form and i want to force users to fill in one out of 4 tick boxes. If none of them are ticked when they press the close button i want the...

hi, i will be looking to exclude public holidays but the most important thing at the moment is that i can exclude non working time - between 3.30pm and 6.30am and weekends. I must be able to calculate it in hours rather than days though.

I have searched the forum for this answer but no luck. :( I'm trying to calculate the amount of WORKING time between two dates in an Access database. At the moment i am just subtracting one date from another but this gives me all of the time in between including weekends and evenings. I need...