G
Guest
I am an access novice, when i originally biult my database last year i did do
some coding but what is it they say if you dont use it you lose it, well its
gone.
I will describe what i want to happen and give what details i think you
might need and can someone please help.
I have a database which i use to manage courses that i run, before the
course runs i send out an information pack, which is done via a button on a
form chich adds a date to a field. the only problem i have is when i have
someone who books in latter than the info pack has been sent out what i would
like to do is when i register someone if the date is after the date the info
pack is sent, for the database to prompt me to send out another info pack.
and if i press yes it will automatically print out the report.
The relevent data i think you will need is: -
I have three tables with corresponding forms (same names)
Attendees
Registration
Events
for an attendee to be booked onto a course it is via the attendees form for
demographic details and Registration for booking onto an event Registration
and Attendees are linked via [AttendeesID] and registration and Events are
linked via [EventsID]. once the information pack (it is three reports which
hold all the info) is sent a field [DateSent] is automatically filled, the
date of registration is a field [RegistrationDate], the reports i would want
to generate are
Welcome Letter
VenueandDates
Replyslip
i am sorry that this is such a large query, i just dont know where to begin,
i would expect the code would go in the on close event for the registration
form but apart from that i am stuck. i have recieved a lot of help from here
before and greatly appreciate any help
Phil
some coding but what is it they say if you dont use it you lose it, well its
gone.
I will describe what i want to happen and give what details i think you
might need and can someone please help.
I have a database which i use to manage courses that i run, before the
course runs i send out an information pack, which is done via a button on a
form chich adds a date to a field. the only problem i have is when i have
someone who books in latter than the info pack has been sent out what i would
like to do is when i register someone if the date is after the date the info
pack is sent, for the database to prompt me to send out another info pack.
and if i press yes it will automatically print out the report.
The relevent data i think you will need is: -
I have three tables with corresponding forms (same names)
Attendees
Registration
Events
for an attendee to be booked onto a course it is via the attendees form for
demographic details and Registration for booking onto an event Registration
and Attendees are linked via [AttendeesID] and registration and Events are
linked via [EventsID]. once the information pack (it is three reports which
hold all the info) is sent a field [DateSent] is automatically filled, the
date of registration is a field [RegistrationDate], the reports i would want
to generate are
Welcome Letter
VenueandDates
Replyslip
i am sorry that this is such a large query, i just dont know where to begin,
i would expect the code would go in the on close event for the registration
form but apart from that i am stuck. i have recieved a lot of help from here
before and greatly appreciate any help
Phil