Current Date and Time

[Guest]

Hi

How do I add the Current date and time on a form? I also would like to add
the calender for 2005, divided into subforms of months displaying on one
screen every day for say, the month of May on the screen with all the days
listed underneath. I want to use this by entering some text next to each day,
almost like a diary, but I want to display only the current month at a time.
After the month it must automatically display the calender for the next month.

Thanks!

 

[Kai Apel \(Berlin\)]

1. The Current Date and time you would get with NOW(the actual time with
date) or DATE (if you only need the date):
For example:
Private Sub Form_Open(Cancel As Integer)
Me.NameOfYourTextbox = Now
End Sub

2. For handling with the calendar your would found a sample here:
http://www.mvps.org/access/downloads/Calendar_pg.zip

Greets

Kai Apel (Germnny - Berlin)