Query Criteria ( In Runtime )

[D Willett]

Strange
In a query I use: ">=Date()-5" as criteria to show records from 5 days ago. The full query:

SELECT tblSales.SalesOrderID, tblSales.Customer, tblSales.Item, tblSales.[Payment Method], tblSales.FitDate, tblSales.FitTime, tblSales.FitDuration, tblSales.FitDone
FROM tblSales
WHERE (((tblSales.FitDate)>=Date()-5) AND ((tblSales.FitDone)=False))
ORDER BY tblSales.FitDate;

In the runtime version of one pc I get the following error, but other pc's on runtime are ok:

[HansV]

It looks like one of the libraries used by the database is missing or not in the expected place on the 'problem' PC.
You can inspect the libraries used in the Visual Basic Editor, by selecting Tools | References...
Do you use non-standard libraries?

[Rudi]

Hi Dave,

Some more info about it to add to Hans's comments...

See this KB article (http://support.microsoft.com/kb/194374) that describes the issue and presents a resolution.
A quick scan on the we also indicates that it is a reference issue in the VBA libraries.

Another links about it:
-- http://www.pcreview.co.uk/forums/funtio ... 55785.html

[D Willett]

Cheers guys. Didn't have time to reply on Saturday. I gathered it was a reference issue, not being registered in older versions of Office.
I did resolve it this morning, changed the "Date()" to "Now()" and it works fine.
However I do try to steer away from Now() because of the time element tagged to the end.
But, for this ourpose it is fixed.

Thanks again Guys.

[HansV]

It's good that you found a workaround, but be alert for the same or a similar problem popping up - missing references can cause weird problems.