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
 
Back
Top