B
Brook Morris via AccessMonster.com
Good morning folks,
I am using Access 2000 and need some assistance. I need to know if there is
a way to create a report where the information is extracted from a query and
placed into a MS word document or template. Let me explain the process:
1. A mishap occurs and the investigator responds to the scene and does his
investigation.
2. Investigator returns and puts the info obtained into a database.
3. The database currently has an input screen with multiple tabs for
different info areas of the investigation.
4. The "mishap narrative" is a memo box that contains the sequence of events
in chronological order.
5. Then we fill in the causation in another tabbed memo field called
"Causation".
6. Again another called "Recommendations".
7. In order for the investigator to compile the formal report we have an MS
word template where we cut and paste the info in steps 4-6 into the template.
Step 7 above is what I want to avoid!
Is there a way to force a new document any time one of those three fields are
filled with data?
I'm at a big loss here folks.
Thanks for your time in this matter
Sincerely
Brook
I am using Access 2000 and need some assistance. I need to know if there is
a way to create a report where the information is extracted from a query and
placed into a MS word document or template. Let me explain the process:
1. A mishap occurs and the investigator responds to the scene and does his
investigation.
2. Investigator returns and puts the info obtained into a database.
3. The database currently has an input screen with multiple tabs for
different info areas of the investigation.
4. The "mishap narrative" is a memo box that contains the sequence of events
in chronological order.
5. Then we fill in the causation in another tabbed memo field called
"Causation".
6. Again another called "Recommendations".
7. In order for the investigator to compile the formal report we have an MS
word template where we cut and paste the info in steps 4-6 into the template.
Step 7 above is what I want to avoid!
Is there a way to force a new document any time one of those three fields are
filled with data?
I'm at a big loss here folks.
Thanks for your time in this matter
Sincerely
Brook