Calendar & Access 2002

[Marg]

I have a form with a [Date] field. I have a Calendar Calendar on that form.
When the user clicks a date on the Calendar, I want the [Date] field on the
form to update. Right now, they must either click their mouse in the
[date]field to perform the update or they must do an [Alt] Records Refresh to
see the "Calendar selected date" in the form [date] field. Is there
something really easy that I can do so that when a date is selected in the
Calendar - it will automatically refresh the value in the form.date field?

 

[Gina Whipp]

Marg,

Have a look at this calendar http://allenbrowne.com/ser-51.html which
inserts the date on double-click. As a side note, if your Date field is in
truth named Date you will want to consider renaming the field as it's a
Reserved Word in Access and is sure to cause you problems. For a complete
list see... http://allenbrowne.com/AppIssueBadWord.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Marg]

Thank you so much Gina. Do you happen to know of any "calendar" report
template available for Access 2002? My mgmt team want the report of shifts
for each facility to be printed out on a calendar report. I've searched but
can't find anything.
--
Marg

Marg,

Have a look at this calendar http://allenbrowne.com/ser-51.html which
inserts the date on double-click. As a side note, if your Date field is in
truth named Date you will want to consider renaming the field as it's a
Reserved Word in Access and is sure to cause you problems. For a complete
list see... http://allenbrowne.com/AppIssueBadWord.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a form with a [Date] field. I have a Calendar Calendar on that
form.
When the user clicks a date on the Calendar, I want the [Date] field on
the
form to update. Right now, they must either click their mouse in the
[date]field to perform the update or they must do an [Alt] Records Refresh
to
see the "Calendar selected date" in the form [date] field. Is there
something really easy that I can do so that when a date is selected in the
Calendar - it will automatically refresh the value in the form.date field?

.

 

[Gina Whipp]

Marg,

Here you go...

http://www.access.hookom.net/Samples.htm

....and you're welcome!
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thank you so much Gina. Do you happen to know of any "calendar" report
template available for Access 2002? My mgmt team want the report of
shifts
for each facility to be printed out on a calendar report. I've searched
but
can't find anything.
--
Marg

Marg,

Have a look at this calendar http://allenbrowne.com/ser-51.html which
inserts the date on double-click. As a side note, if your Date field is
in
truth named Date you will want to consider renaming the field as it's a
Reserved Word in Access and is sure to cause you problems. For a
complete
list see... http://allenbrowne.com/AppIssueBadWord.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a form with a [Date] field. I have a Calendar Calendar on that
form.
When the user clicks a date on the Calendar, I want the [Date] field on
the
form to update. Right now, they must either click their mouse in the
[date]field to perform the update or they must do an [Alt] Records
Refresh
to
see the "Calendar selected date" in the form [date] field. Is there
something really easy that I can do so that when a date is selected in
the
Calendar - it will automatically refresh the value in the form.date
field?

.