Danny
12-27-2009, 11:03 PM
I am using ADO to get a recordset from an access query into excel. Then populate a userform with the data in that recordset. I have been doing this without a problem until I created a query in access that uses a user defined function in one of the fields. The UDF is stored in module 1 of the access database. This query works fine when it is executed within access, but when I try to pull it into a recordset from excel it gives the error : Runtime-error '-2147217900 (80040e14)' Undefined function 'WrkDay' in expression. I would appreciate any ideas for a solution.
Thanks,
Danny
Thanks,
Danny