Alvaro
April 27th, 1999, 04:59 PM
Hi,
I've created a database in Access 97 which has a Module with a few functions in it. I have placed the functions inside several of my Queries and they work fine when executed from within Access.
Here's one of the queries (the function is "ConvertFromJulian" and its in my "Dates" module):
SELECT PDLITM AS [Part Number], PDUORG AS Quantity, ConvertFromJulian([PDTRDJ]) AS [Order Date]
FROM F4311
Again, this works fine within Access but when I try to execute it using the CDAORecordset class in the DAOVIEW sample application, it gives me error 3085 saying that ConvertFromJulian is undefined. If I don't use my own functions but instead use a VB function like Mid or Len, it works fine. It's my functions that it doesn't recognize for some reason.
Can you help? Why can't I use my own functions?
Thanks!
Alvaro
I've created a database in Access 97 which has a Module with a few functions in it. I have placed the functions inside several of my Queries and they work fine when executed from within Access.
Here's one of the queries (the function is "ConvertFromJulian" and its in my "Dates" module):
SELECT PDLITM AS [Part Number], PDUORG AS Quantity, ConvertFromJulian([PDTRDJ]) AS [Order Date]
FROM F4311
Again, this works fine within Access but when I try to execute it using the CDAORecordset class in the DAOVIEW sample application, it gives me error 3085 saying that ConvertFromJulian is undefined. If I don't use my own functions but instead use a VB function like Mid or Len, it works fine. It's my functions that it doesn't recognize for some reason.
Can you help? Why can't I use my own functions?
Thanks!
Alvaro