Scheduling

[Guest]

I'm trying to recreate a schedule that I produced in excel. the excel
schedule uses the workday() function along with string constants to tell me
when the my next task can begin excluding weekends, holidays, and any delays
i might need to add. i can make a simple expression to drive the dates on
the schedule but i don't know how i can make it skip weekends and holidays
and only give me workdays on the report. is this possible or should I just
stick with excel?

 

[Allen Browne]

See:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

 

[Guest]

Thanks, but I'm still not exactly sure on what to do to put that into action
with what I have to do. I fairly new to access.

 

[Guest]

I am recieving a data type mismatch error when I try to enter an array in the
"adtmDates" portion of the 'dhAddWorkDaysA' function. If I enter a single
date as a holiday it works fine, but when I try to enter an array... ex:
Array(#1/6/2006#,#1/10/2006#) that is when the data type mismatch occurs.
I don't see an array function listed in my expression builder, but I don't
think that's the problem, is there anyting I can do to make it let me enter
an array of holiday dates here?

 

[Allen Browne]

The Array() function works in limited circumstances, but you can also load
your array with:
adtmDates(0) = #1/6/2006#
adtmDates(1) = #1/10/2006#
etc.

 

[Guest]

I still couldn't get the Array() function to work. However, I put an ' If
adtmDates = 0 Then adtmDates = Array(#1/6/2006#,1/10/2006#) End If '
section into the VBA Code and entered ' 0 ' for the adtmDates in the
function, it works perfect. Thanks very much for your help and direction.

 

[Guest]

Yque,

I am trying to do the same thing with a database at work. Is there a way
for me to get a copy of the shell of your database?

Sincerely,

dhuber

dhuber(AT)kbhome.com-remove (AT) and replace with @