UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Search Between Two Time, Any Version    
 
   
2ME
post Jun 2 2020, 05:46 PM
Post#1



Posts: 751
Joined: 13-May 10
From: Egypt


Hi,
I am trying to search records between two time fields in a from

CODE
If TimeValue(Me.STF) Then
   '     ' Add it to the predicate - exact
       strWhere = strWhere & " AND " & "qry_SRSF.[SampleTime] >= " & GetDateFilter(Me.STF)
    End If
  ''  ' If Date To
   If TimeValue(Me.STT) Then
  ''      ' Add it to the predicate - exact
        strWhere = strWhere & " AND " & "qry_SRSF.[SampleTime] <= " & GetDateFilter(Me.STT)
    End If

but timevalue doesn't work for VBA, any suggestion
thanks

--------------------
Mostafa Osman
Go to the top of the page
 
GroverParkGeorge
post Jun 2 2020, 06:18 PM
Post#2


UA Admin
Posts: 37,480
Joined: 20-June 02
From: Newcastle, WA


Actually TimeValue() DOES work in VBA.

What error does your function raise?

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    8th July 2020 - 02:49 AM