unknown function in query

  • Thread starter Thread starter Hans Kemper
  • Start date Start date
H

Hans Kemper

Hello,

I use for years functions in queries, ie date(), trim(), dateserial() or own
build functions to pass paramaters like funKey(). We have an access
application that worked perfect for years under windows98. We migrated to
WindowsXPprofessional recently. The strange thing is that on some systems
(not all) all queries that invokes a function, stop with the following
message 'Unknown function 'date' in query' or 'Unknown function 'trim' in
query'
Does anyone recognise this problem?
Thank you for your help.

Hans Kemper
The Netherlands
 
Hi,

Are you using vba in the application?
Probably one of the references in VBA is broken so check these if not you
can resolve it by sorting the references differently.

- Raoul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
unknown function name in query 4
Trim function in a query 1
Trim in Query Error 1
function error in query (unknown function name) 5
unknown function name in query expression 9
Undefined Function error - Complex 3
Query/Function/Parameter Troubles... 2

Back
Top