VBA -- Me.bidTimeCombo = Now() to only Time

[johnseito]

How can I make this code in VBA to become only time, rather than date and time as it is now.

Me.bidTimeCombo = Now()

[orange]

see http://www.techonthenet.com/access/f.../date/time.php

[johnseito]

Ok, do you know how that could be done using SQL.

I tried this:

 
SELECT time ()  as t

and it say undefined function time in expression.

[johnseito]

I put this in my VBA access,

   Me.bidTimeCombo = Time()

and I get compile error: Can't find project or library.

It can only work when it is like this,

   Me.bidTimeCombo = Now()

[johnseito]

the same reason for this error.

https://www.accessforums.net/access/...now-37885.html

[June7]

AFAIK, Time() is not an intrinsic function. Use Format(). The result will be a string. Why not just save the full date/time? Can always manipulate the value later.

[orange]

?time()
6:24:18 PM

works for me with A2010

[June7]

I am trying Access 2010 and doesn't work. What am I missing? Year(), Month(), Day(), Hour(), Second() all work. Oh, wait, Time() doesn't have an argument. Oh wow!

[johnseito]

AFAIK, Time() is not an intrinsic function. Use Format(). The result will be a string. Why not just save the full date/time? Can always manipulate the value later.

Yes I am trying to use the now() and manipulate it, but then I have to cast it back to time after manipulating the dates/time combo. What is AFAIK?

[ItsMe]

As far as I know AFAIK is an acronym

Dim strTime As String
strTime = Format(Now(), "yyyymmdd_hh:mm:ss")
Me.txtTest.Value = Right(strTime, 8)