Calendar & Access 2002

  • Thread starter Thread starter Marg
  • Start date Start date
M

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?
 
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
 
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


Gina Whipp said:
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 said:
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?
Click to expand...


.
Click to expand...
 
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

Marg said:
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


Gina Whipp said:
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 said:
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?
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top