ACCESS FEED: Re: RE: [MS_AccessPros] How do I format a Dat e/Time field to display the actual time…

Rabu, 25 Desember 2013

Re: RE: [MS_AccessPros] How do I format a Dat e/Time field to display the actual time…

From the data I saw in the earlier post, I am assuming you got the Date in txtSID from a Date Picker. Assigning from such a value will remove the Time portion. The date/time field keeps date as whole # and time as fraction. Your time was 12:00 am which equals zero.

7ony

Sent from Yahoo Mail on Android

From: saigonf7q5@yahoo.com <saigonf7q5@yahoo.com>;
To: <MS_Access_Professionals@yahoogroups.com>;
Subject: Re: RE: [MS_AccessPros] How do I format a Dat e/Time field to display the actual time…
Sent: Wed, Dec 25, 2013 2:37:30 PM

Thank you Tony

I assigned the NoteDt as you can see from the code below. Doesn't it already have the time in the Format function?

How do I add the time to it in this case?

With rs
   .AddNew
   !Sid = Me.txtSID
   !NoteDt = Format(Me.txtNoteDt, "mm/dd/yyyy hh:nn AM/PM"))
   !Note = Me.txtNote
   .Update
   .Close
End With