User defined function/procedure in query

  • Thread starter Thread starter Poerno
  • Start date Start date
P

Poerno

I'm newby in Access 2K ADP, trying to conver Access 97
into 2K ADP, In Access 97, I can put my own user defined
function/precedure in queries to get the result. Can I
still have one in Acess 2K ADP?if not, then is there other
way to have?

Thanks
 
I'm newby in Access 2K ADP, trying to conver Access 97
into 2K ADP, In Access 97, I can put my own user defined
function/precedure in queries to get the result. Can I
still have one in Acess 2K ADP?if not, then is there other
way to have?
Click to expand...

No, you can not use you own custom VBA functions in the sql when using a ADP
project.

So, of course, if you upgrade from access97 to access 2000, or access 2002,
then you can continue to use your user defined functions (UDF) in the sql.
However, if you use a ADP project, then the sql is running on the
server...it can't go back to the access application.

So, either you figure out a way to do what you need in sql...or you can't
use a adp project...
 
Back
Top