Scheduling

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?
--
yque

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"yque" wrote in message
...
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?
--
yque

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.
--
yque


"Allen Browne" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"yque" wrote in message
...
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?
--
yque

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?
--
yque


"Allen Browne" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"yque" wrote in message
...
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?
--
yque

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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"yque" wrote in message
...
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?
--
yque


"Allen Browne" wrote:

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

"yque" wrote in message
...
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?

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.
--
yque


"Allen Browne" wrote:

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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"yque" wrote in message
...
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?
--
yque


"Allen Browne" wrote:

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

"yque" wrote in message
...
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?