unknown function in query

[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

 

[Guest]

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

 

[Van T. Dinh]

It is likely to be Reference Errors.

See Douglas J. Steele's article:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html