Calendar Time

  • Thread starter Thread starter T23459
  • Start date Start date
T

T23459

I have two seperate questions regarding Access 2000.

1. I have a field called ContactTime. Currently the format chosen is
medium time.
I would like system to use the 12 hr clock system. When I type 2.30 (to
mean 2.30pm),
the result is actually 2.30 AM.


2. I have inserted the Calendar (ActiveX) in a form. Unfortunately it does
not show the current date reflected in the depressed button of the calendar
when it is opened. Is there a way to create some code to allow the calendar
to recognize the current date by default when it is opened.

Any help is much appreciated.
 
T23459 said:
I have two seperate questions regarding Access 2000.

1. I have a field called ContactTime. Currently the format chosen is
medium time.
I would like system to use the 12 hr clock system. When I type 2.30
(to mean 2.30pm),
the result is actually 2.30 AM.
Click to expand...

How is Access to know you want PM rather than AM? In 12 hour notation
2.30 is not a valid time. It needs AM or PM.
 
T23459 said:
I have two seperate questions regarding Access 2000.

1. I have a field called ContactTime. Currently the format chosen is
medium time.
I would like system to use the 12 hr clock system. When I type 2.30 (to
mean 2.30pm),
the result is actually 2.30 AM.


2. I have inserted the Calendar (ActiveX) in a form. Unfortunately it does
not show the current date reflected in the depressed button of the calendar
when it is opened. Is there a way to create some code to allow the calendar
to recognize the current date by default when it is opened.
Click to expand...

I used the following which works.

Private Sub Form_Load()
Calendar.Value = Date
End Sub
 
Back
Top