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

I have tried to use Access and ODBC.  I am failing.  Could you reference =
the document you were sent?  I will try to look it up on CSC.
Thanks in advance.
Bryan Wiggins

-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx
[mailto:foxboro-bounce@xxxxxxxxxxxxx]On Behalf Of Ron Schafer
Sent: Wednesday, May 03, 2006 10:48 AM
To: foxboro@xxxxxxxxxxxxx
Subject: [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

=20
=20
_______________________________________________________________________
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
=20
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Djoin
to unsubscribe:      =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave
=20


 
 
_______________________________________________________________________
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: