hi. im so lost now. teying to look fro a reason for this error but come up empty.

heres me problem, Im using MS access as my DB. and VB.net

i have a query in my DB that uses a USER-DEFINE FUNCTION...

If i open my query in the ACCESS,, it works fine.. it computes date as it was designed.

So last thing to do is Select the QUERY table in VB.net like this:


SELECT * from qryDates

NOTE that the qrydates uses a USERDEFINE FUNCTION Get_Date().


now my problem is it promtps : Undefined function 'Get_Date' in expression.


why it happens?
thanks...

Can we see the code for this?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.