E
ear-lution
Hi
I'm using Access 2003 on a WinXP platform.
My database is basically a glorified register with two linked tables:
'Membership' and 'Attendance'. 'Membership' contains personal data on each
member and 'Attendance' contains their attendance data. They're linked by
ID, so each member will have several fields in 'Attendance' (one for each
date they attend).
I have created a form with sub-form to enter attendance, but it is a tedious
task creating each field then typing the date. I've tried adding a calendar
control (calendar is located on the 'Membership' section of the form), but
all I can figure out is how to click a date on the calendar and have that
date paste into a holding field, then copy and paste into the required
field.
I need the calendar to create a new record with the clicked date in the date
field in the sub-form section.
I have purchases John Viescas' excellent 'Access 2003 Inside Out', but
without working my way through the book (which I don't currently have time
to do), I can't figure this out. Any help would be greatly appriciated,
even if just to point out to the sections/pages of the book will inform me
of what I need to learn.
Thank you for reading me out
RM
I'm using Access 2003 on a WinXP platform.
My database is basically a glorified register with two linked tables:
'Membership' and 'Attendance'. 'Membership' contains personal data on each
member and 'Attendance' contains their attendance data. They're linked by
ID, so each member will have several fields in 'Attendance' (one for each
date they attend).
I have created a form with sub-form to enter attendance, but it is a tedious
task creating each field then typing the date. I've tried adding a calendar
control (calendar is located on the 'Membership' section of the form), but
all I can figure out is how to click a date on the calendar and have that
date paste into a holding field, then copy and paste into the required
field.
I need the calendar to create a new record with the clicked date in the date
field in the sub-form section.
I have purchases John Viescas' excellent 'Access 2003 Inside Out', but
without working my way through the book (which I don't currently have time
to do), I can't figure this out. Any help would be greatly appriciated,
even if just to point out to the sections/pages of the book will inform me
of what I need to learn.
Thank you for reading me out
RM