Assistance with User-Defined Function call with Array variable 1

[AustinMan]

I am trying to Update a table with a user-defined function using this below.

 DoCmd.RunSQL "UPDATE tblTickler SET tblTickler.DueDate=dhAddWorkDaysA(10,[tblTickler]![SignedForOn],[b]Array(#10/08/2007#,#11/12/2007#))"/b

dhAddWorkDaysA is a function taken from MVP/ Access revised from VBA Handbook to get next workday with array of holidays. (found on mvps.org/access) - Date/Time - Doing WorkDay Math in VBA hyperlink.

I am at a lost when stepping thru and Array function errors out in VBA.

How can I update this with Array function in Design view ?

 

[PHV]

SQL don't like arrays, period.
You may try to revise your function to deal with ParamArray (look at the VBA help)

Another (safer IMO) way is to have a table of holidays ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886