[foxboro] Aim*,ODBC, And MS Access alarm messages

I am involved in using access to obtain historical alarms from Aim* via odbc
link. I have a doc from tac showing how to set up a query. It works fine,
however I want to link the search criteria field in access query to a form
so it can be linked to a start time and end time for reports and form views.
The query works fine when I manually enter the following in the search
criteria field of the query;
Between 1/1/2006 AND 4/1/2006
it transforms (by access) into
BETWEEN #1/1/2006# AND #4/1/2006#
Access uses the # sign to denote dates.
I have tried several ways to indicate the start date and end dates but all I
get is a ODBC CALL FAILED ERROR (0) or invalid search criteria.
Anyone trying such a thing as this or know access really well?
Thanks
Ron Schafer
rschafer@xxxxxxxxxxxxxxxxxxxxxx

 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: