[SOLVED] Ms Access Date and Time

James Tembo · 06-26-2009, 03:31 AM

Hello guys,
thanks for every thing you are doing,you are really helping us
hey guys i need help on this one,

i have created a form on my access project,on the form i have inserted a textboxes which will be showing the date.
now i want this textbox or label to be picking the system date and time(from the computer)

you are always appreciated for your help.

cheers.

**Dragoen** · 06-26-2009, 12:37 PM

Hi James,

Probably the easiest way is to create a text box for date and a text box for time if you want that shown also. In the Control Source property for the text boxes put "=Now()" without the double quote marks. Then in the Format property for each text box, select the desired Date or Time format from the list. Be aware, that Access uses the Windows Regional settings for these date and time displays so if the end user has different formats for their dates and times, the displayed date and time will look different than yours.

HTH,

James Tembo · 06-27-2009, 03:26 AM

Hey thanks very much Dragoen.

06-26-2009, 03:31 AM	#1 (permalink)
James Tembo Registered User Join Date: May 2009 Location: Kitwe, Zambia Posts: 52 OS: windows xp sp2,Professional Edition,Version2002	[SOLVED] Ms Access Date and Time Hello guys, thanks for every thing you are doing,you are really helping us hey guys i need help on this one, i have created a form on my access project,on the form i have inserted a textboxes which will be showing the date. now i want this textbox or label to be picking the system date and time(from the computer) you are always appreciated for your help. cheers.

06-26-2009, 12:37 PM	#2 (permalink)
Dragoen TSF Enthusiast Join Date: Apr 2009 Location: Harrisburg, PA Posts: 1,024 OS: Windows Vista Home Premium (6.0, Build 6001) My System	Re: Ms Access Date and Time Hi James, Probably the easiest way is to create a text box for date and a text box for time if you want that shown also. In the Control Source property for the text boxes put "=Now()" without the double quote marks. Then in the Format property for each text box, select the desired Date or Time format from the list. Be aware, that Access uses the Windows Regional settings for these date and time displays so if the end user has different formats for their dates and times, the displayed date and time will look different than yours. HTH, __________________ Dragoen ========================================================= Just because we can, doesn't mean we should...

06-27-2009, 03:26 AM	#3 (permalink)
James Tembo Registered User Join Date: May 2009 Location: Kitwe, Zambia Posts: 52 OS: windows xp sp2,Professional Edition,Version2002	Re: Ms Access Date and Time Hey thanks very much Dragoen.