A2K MDB with SQL Server 200 backend...
Ok, I have read many posts on how not to include time in a criteria
expression of a timestamp...
What if I NEED to include the time? When including the time, the
entire timestamp is being ignored. I used a message box to verify what
my criteria was, look through the records and am getting everything
without any regard to the timestamp criteria. As soon as I format the
date to ignore the time, i get only records on that date:
DoCmd.OpenForm "OLEdit", , , "[SR_ID] = " & intSR & " AND[ListDate] = #" & dtListDate & "#", , , intListType
The open event of the OLEdit form sets the recordsource:
If IsNumeric(Me.OpenArgs) = True Then
strSql = "SELECT * FROM SRSrvcsEquip;"Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12763-timestamp-criteria-being-ignored.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12763
strSql = "SELECT * FROM SRSrvcsEquipDefaults;"
Me.RecordSource = strSql
Thanks, from a most frustrated know-enough-to-be-dangerous