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],Array(#10/08/2007#,#11/12/2007#))"
dhAddWorkDaysA is a function taken from MVP/ Access revised from VBA Handbook to get next workday with array of holidays.
I am at a lost when stepping thru and Array function errors out in design view.
How can I update this with this array listed?
Thanks!
DoCmd.RunSQL "UPDATE tblTickler SET tblTickler.DueDate=dhAddWorkDaysA(10,[tblTickler]![SignedForOn],Array(#10/08/2007#,#11/12/2007#))"
dhAddWorkDaysA is a function taken from MVP/ Access revised from VBA Handbook to get next workday with array of holidays.
I am at a lost when stepping thru and Array function errors out in design view.
How can I update this with this array listed?
Thanks!