ActiveX

[Lauri]

I'm using Access 2000. I have an ActiveX control mscal.calendar.7. The
properties can be set to default to a specific date. I want to default it
to today. Can I do that? If so, How?

Thank you

 

[GVaught]

Not sure I am following. I brought the calendar control into my database and
it shows me today's date. It should show me tomorrow's date if I open it
tomorrow. Exactly what are you trying to do with this calendar?

 

[Lauri]

When I open my form, the calendar shows the date set in the properties.

Properties of ActiveX Control:[control name]
Other Tab
Value property is set to a specific date 1/1/2004.

I want the value to be set to today. I can't seem to set it to a variable.
It only accepts a real date, then that is the default value when the form is
opened and the calendar is shown.

-Lauri

 

[Jeff Conrad]

Place this code in the Form's Load event:

Private Sub Form_Load()
Me.actCalendar.Today
End Sub

Replace actCalendar with your calendar contol name.
The form should now open with the calendar showing the
current day.

Hope that helps,
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
When I open my form, the calendar shows the date set in the properties.

Properties of ActiveX Control:[control name]
Other Tab
Value property is set to a specific date 1/1/2004.

I want the value to be set to today. I can't seem to set it to a variable.
It only accepts a real date, then that is the default value when the form is
opened and the calendar is shown.

-Lauri

Not sure I am following. I brought the calendar control

into my database
and

it shows me today's date. It should show me tomorrow's date if I open it
tomorrow. Exactly what are you trying to do with this calendar?

I want to default
it

.

 

[Lauri]

THANK-YOU!
Many hugs your way.

-Lauri

Place this code in the Form's Load event:

Private Sub Form_Load()
Me.actCalendar.Today
End Sub

Replace actCalendar with your calendar contol name.
The form should now open with the calendar showing the
current day.

Hope that helps,
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
When I open my form, the calendar shows the date set in the properties.

Properties of ActiveX Control:[control name]
Other Tab
Value property is set to a specific date 1/1/2004.

I want the value to be set to today. I can't seem to set it to a variable.
It only accepts a real date, then that is the default value when the form is
opened and the calendar is shown.

-Lauri

Not sure I am following. I brought the calendar control

into my database
and

it shows me today's date. It should show me tomorrow's date if I open it
tomorrow. Exactly what are you trying to do with this calendar?

I'm using Access 2000. I have an ActiveX control mscal.calendar.7. The
properties can be set to default to a specific date.

I want to default
it

to today. Can I do that? If so, How?

Thank you

--
Lauri
Application Support Technician
Bellingham Public Schools
Microsoft Office Specialist Instructor

.

 

[Jeff Conrad]

Ahhh...<blush>...you're quite welcome.
I feel all warm and fuzzy now.
Thanks for that.

--
Jeff Conrad
Access Junkie
Bend, Oregon
Install the latest Windows Updates:
http://www.microsoft.com/security/security_bulletins/200404_windows.asp

THANK-YOU!
Many hugs your way.

-Lauri

Place this code in the Form's Load event:

Private Sub Form_Load()
Me.actCalendar.Today
End Sub

Replace actCalendar with your calendar contol name.
The form should now open with the calendar showing the
current day.

Hope that helps,
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
When I open my form, the calendar shows the date set in the properties.

Properties of ActiveX Control:[control name]
Other Tab
Value property is set to a specific date 1/1/2004.

I want the value to be set to today. I can't seem to set it to a variable.
It only accepts a real date, then that is the default value when the form is
opened and the calendar is shown.

-Lauri

Not sure I am following. I brought the calendar control into my database
and
it shows me today's date. It should show me tomorrow's date if I open it
tomorrow. Exactly what are you trying to do with this calendar?

I'm using Access 2000. I have an ActiveX control mscal.calendar.7. The
properties can be set to default to a specific date. I want to default
it
to today. Can I do that? If so, How?

Thank you

--
Lauri
Application Support Technician
Bellingham Public Schools
Microsoft Office Specialist Instructor






.