Senin, 23 Desember 2013

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

 

Phucon, you are using the Calendar Control and picking up ONLY a date. The time is Zero or 12:00 am. Try adding in the current Time back to it.

7ony

Sent from Yahoo Mail on Android



From: Duane Hookom <duanehookom@hotmail.com>;
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>;
Subject: RE: [MS_AccessPros] How do I format a Date/Time field to display the actual time…
Sent: Mon, Dec 23, 2013 8:12:05 PM

Phucon,
Where are you viewing the NoteDt? Form, table, report, ...?
If in a form, what is the format of the text box?

What do you see if you type ? Now() into the debug/immediate window (press Ctrl+G)

Duane Hookom MVP
MS Access

________________________________

> From: saigonf7q5@yahoo.com
>
> I have been having trouble with the REPLY button or link on this web
> page. There's no response when I clicked on it and it displays Error On
> Page at the bottom left corner. So I reply the messages by using the
> NEW TOPIC button. I am sorry for any inconvenient this may cause.
>
> Thank you all. Originally, the format in the table's field property
> was set as mm/dd/yyyy hh:nn AM/PM.
>
> The date then was entered by selected from a calendar through an
> unbound form which's shown as below:
>
> With rs
>   .AddNew
>     !Sid = Me.txtSID
>     !NoteDt = Format(Me.txtNoteDt, "mm/dd/yyyy hh:nn AM/PM"))
>     !Note = Me.txtNote
>   .Update
>   .Close
> End With
>
> But the time portion of the date was incorrect 12/23/2013 12:00 AM.
>
> Now I changed the line of code from
>
> !NoteDt = Format(Me.txtNoteDt, "mm/dd/yyyy hh:nn AM/PM") to !NoteDt = Now()
>
> With rs
>   .AddNew
>     !Sid = Me.txtSID
>     !NoteDt = Now()
>     !Note = Me.txtNote
>   .Update
>   .Close
> End With

> This displays the date and time correctly ONLY when the selected date
> is a current date. However, If the date is going to be in the past e.g.
> 11/23/2013, then only the time portion is correct, but the date becomes
> a current date 12/23/2013 2:03:56 PM, which is incorrect. ???
>
> Phucon                        


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/MS_Access_Professionals/join
    (Yahoo! ID required)

<*> To change settings via email:
    MS_Access_Professionals-digest@yahoogroups.com
    MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    http://info.yahoo.com/legal/us/yahoo/utos/terms/

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar