Expression Problem

  • Thread starter Thread starter Gavin
  • Start date Start date
G

Gavin

Hi, i had an expression in an Access 2000 database query
which filtered a date field for today's dates. The
expression in used was

Between Date() And Now()

This worked a treat, however i have had to convert the
database to 97, now whenever i try to open the query, or
form based on it i get a system msg:

"This expression is typed incorrectly, or is too complex
to be evealuated"

Any sugestions as to how i can get this working again? I
have tried building the same expression again using the
wizard/builder, and it will allow be to build it, just not
run it!!!

Thanks for any help you have

Gavin
 
Gavin said:
Hi, i had an expression in an Access 2000 database query
which filtered a date field for today's dates. The
expression in used was

Between Date() And Now()

This worked a treat, however i have had to convert the
database to 97, now whenever i try to open the query, or
form based on it i get a system msg:

"This expression is typed incorrectly, or is too complex
to be evealuated"

Any sugestions as to how i can get this working again? I
have tried building the same expression again using the
wizard/builder, and it will allow be to build it, just not
run it!!!
Click to expand...
Hi Gavin,

I don't know why you are getting error..
but why not just use

BETWEEN Date() AND Date()+1

Good luck,

Gary Walter
 
Hi

I think it may be a promlem with the Date() expression,
this function appears to not be working. Now() returns
the corect value, whereas Date() returns #Name? .

Could this be something to do with object libraries, when
i converted the database it said one was missing!?

Thnx for your help

Gavin
 
Hi

I think it may be a promlem with the Date() expression,
this function appears to not be working. Now() returns
the corect value, whereas Date() returns #Name? .

Could this be something to do with object libraries, when
i converted the database it said one was missing!?

Thnx for your help

Gavin
Click to expand...
Hi Gavin,

Yup...you solved it.

from http://support.microsoft.com/default.aspx?scid=kb;EN-US;197110

***quote***
The references that are selected by default at the time
a new Microsoft Access 2000 database is created are:

Visual Basic for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library

***unquote***

Plus, you possibly had DAO Library
Microsoft DAO 3.6 Object Library

So...you probably need to make sure the following
references are set (at least)

Visual Basic for Applications
Microsoft Access 8.0 Object Library
OLE Automation
Microsoft DAO 3.5 Object Library


Or...if any reference is still showing as "misssing,"
uncheck it and find the 97 library equivalent.
 
Back
Top