<div>
Have you tried using the datepart function <br />
<br />
where datepart(&quot;hh&quot;YourDateField<wbr />) BETWEEN #7# &nbsp;AND #8#<br />
<br />
you may have to play with parenthasis and pound sign
</div>


Have you tried using the datepart function

where datepart("hh"YourDateField) BETWEEN #7#  AND #8#

you may have to play with parenthasis and pound sign

<div>
Forgot the comma <br />
datepart(&quot;hh&quot;,YourDateFiel<wbr />d) 
</div>


Forgot the comma
datepart("hh",YourDateField)

<div>
It works perfect. I could not remember for this solution. <br />
Thank you AkAlan.<br />
<br />
This is Access version of the AkAlan code, if someone else maybe need it:<br />
[code]DatePart(&quot;h&quot;;[YourDa<wbr />teField])[<wbr />/code]
</div>


It works perfect. I could not remember for this solution.
Thank you AkAlan.

This is Access version of the AkAlan code, if someone else maybe need it:
[code]DatePart("h";[YourDateField])[/code]

<div>
<pre><code id="code-20-35123335-1">DatePart(&quot;h&quot;;[YourDateField])</code></pre>
<br />

</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have &nbsp;an application with Access database. In database I need to query records between ONLY times. <br />
I have in vb.net code on Button_click like this:<br />

<pre><code id="code-10-26883603-1">OnlyTimeTextBox.text = TimeString</code></pre>
But, when I save record, then database get value like 13.3.2011 19:05:10.<br />
<br />
How can I get only time? <br />
My goal is to query like. But, of course it is not working, because the Date is also include.<br />

<pre><code id="code-10-26883603-2">Between #7:00:00# and #8:00:00#</code></pre>
<br />
Thank you in advance for help to anyone.
</div>
</div>


Hello,

I have  an application with Access database. In database I need to query records between ONLY times. 
I have in vb.net code on Button_click like this:
(CODE)
But, when I save record, then database get value like 13.3.2011 19:05:10.

How can I get only time? 
My goal is to query like. But, of course it is not working, because the Date is also include.
(CODE)

Thank you in advance for help to anyone.

How to store only time into MSaccess database?

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,