mjwillyone
Registered User.
- Local time
- Today, 09:56
- Joined
- Aug 3, 2004
- Messages
- 27
Friends,
I have an Access database which I am working on that will keep track of employee insurance contacts we make to them/on their behalf.
I am attepting to automate the procedure of sending dependent student certifications forms to these employees by e-mail and recording this step as having been done.
Here is what I have:
The main form: StaffInfo
The sub form: ChldSubForm
Here is what I want to be able to do:
1. select a child from the subform (select the whole record??)
2. click a button (or something) that begins the process of sending the information to a MSWord Document (Name of employee from the form, name of child, etc. from the sub-form)
3. have another table set up so that information on the child, college, date, and user are placed so that we have a record that we processessed this form. This table should be linked so that we can view it on the employee's (parent's) form.
I know I am asking alot ... but I am lost when doing this.
Thanks,
Mike
I have an Access database which I am working on that will keep track of employee insurance contacts we make to them/on their behalf.
I am attepting to automate the procedure of sending dependent student certifications forms to these employees by e-mail and recording this step as having been done.
Here is what I have:
The main form: StaffInfo
The sub form: ChldSubForm
Here is what I want to be able to do:
1. select a child from the subform (select the whole record??)
2. click a button (or something) that begins the process of sending the information to a MSWord Document (Name of employee from the form, name of child, etc. from the sub-form)
3. have another table set up so that information on the child, college, date, and user are placed so that we have a record that we processessed this form. This table should be linked so that we can view it on the employee's (parent's) form.
I know I am asking alot ... but I am lost when doing this.
Thanks,
Mike
Last edited: