Holiday dates!!!

[jameshall]

Hello

I have been given the task of sorting a in house timelogger for my department. It fails to take into account bank holidays.
can this be done programatically? i want to validate each entry as they are entered.
if this cannot be not done through a system function, i will build a table and have all relevant holidays manually entered, then i will compare each date entry to the contents of the table.
Is there a more efficient way of completing this task, so i dont have to rely on my MANAGER to input the holidays.

Thank You

 

[Petemush]

Try this FAQ out.

faq181-261

There are a number of FAQS and posts about this subject but this is the first one I found.

Cheers,

Pete

 

[MichaelRed]

Thanks Petemush!

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[oharab]

Also, have a look at

http://mvps.org/access/datetime/date0012.htm

For another, probably quicker way of doing it.

B ----------------------------------------
Ben O'Hara
Home: bpo@SickOfSpam.RobotParade.co.uk
Work: bo104@SickOfSpam.westyorkshire.pnn.police.uk
(in case you've not worked it out get rid of Sick Of Spam to mail me!)
Web:

http://www.RobotParade.co.uk

----------------------------------------

 

[MichaelRed]

Ben O'Hara.

You state that MVPS version of Stan Getz's process in " . probably quicker ... " than the FAQ posted by Petemush. Have you actually used both? I had avoided the use of an array (either as a passed set of values, or an embeded listing) as I felt that there were issues with either.

The passed arg list relies on the user (caller) having generated the list more or less on the fly. As a 'human' I considered this to be at best risky, while from a prgramatic approach, the calling function would need to do a similar "look-up" or have the data (Holiday dates) supplied by hte (Human) user. In the former instance, it just shifts the overhead of the recorfdset lookup to a different / seperate procedure while adding the overhead of arg passing to the overall process.

The use of an internal (embeded) array appeared (to me) to be fraught with maintenance issues, requiring the programmer to manually maintain and update the array. while this could be done in a VERY small system, for a while, it is at best awkward, and is (in my opinion) a mis-allocation of programmer's time. When I have employed the procedure, I include a Form for the use of an administrative assistant to enter hte holiday dates as they becom available.

Interested in hearing your opinion.


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over