Access Project (adp) Function in Query doesn't work

[cmmrfrds]

I am developing an application using Access project as opposed to an Access MDB. In Access MDB, I was accustomed to using functions in my queries, but I get an error when trying to use a function in Access Project. The error is "funtion not recognized". I put it in a public module just like when coding an MDB. Is this not supported in a project? Do I need to qualify the function? Do I need to set reference libraries? Any ideas?

Thank you
Jerry

 

[Durkin]

You can't do it because you are not using Jet anymore you are using the database engine of your backend. All the data processing is done on the server so it can't see any routines you have written on the local machine. You need to write stored procedures to put functions in your SQL. Durkin
alandurkin@bigpond.com

 

[cmmrfrds]

If I change the RecordSource in the Form, I can use the function and it works okay. It will accept the function, but in the query builder it won't. I have noticed other problems in the query builder. For example, I used the CASE statement in my stored procedure but it wouldn't accept it in the query builder. It seems to me the query builder in an adp is deficient.

Thank you,
Jerry