Access queries failing after transfer to XP

I hope this is a relevant place for this query.
I have an Access application running on four machines. Some of these have
been replaced and XP is the operating system.
The application works on some XP machines but fails on others in one
particular form. The problem has been isolated to a query using a comparison
'Is Null or Date()'.
Remove the Date() function and the query works.
The application is written in Access 97 because that is the oldest version
still being used in the operating area.

I would be grateful for any indication as to where to look to resolve this.

Thanks

--
John Mullan

Likely to be missing References or Reference errors.

See Douglas J. Steele's article:

http://www.accessmvp.com/djsteele/Ac...nceErrors.html

--
HTH
Van T. Dinh
MVP (Access)


"John Mullan" wrote in message
...
I hope this is a relevant place for this query.
I have an Access application running on four machines. Some of these have
been replaced and XP is the operating system.
The application works on some XP machines but fails on others in one
particular form. The problem has been isolated to a query using a
comparison
'Is Null or Date()'.
Remove the Date() function and the query works.
The application is written in Access 97 because that is the oldest version
still being used in the operating area.

I would be grateful for any indication as to where to look to resolve
this.

Thanks

--
John Mullan

Yes, that is correct - many thanks for pointing me in that direction.

JohnM


"Van T. Dinh" wrote in message
...
Likely to be missing References or Reference errors.

See Douglas J. Steele's article:

http://www.accessmvp.com/djsteele/Ac...nceErrors.html

--
HTH
Van T. Dinh
MVP (Access)