I have been given the daunting (which is polite for crappy) task of maintaining a Job System in Access 2002. It tracks our work requests and work progress for a small (20 or so people) Software Development Dept.
Currently, I have a directory which stores all of our "Linked Documents". These can be anything from Text files (which came from the original Job System, which was COBOL based), to word docs, to pdf scans of Agency Requirements, to Excel Spreadsheets showing statistics - just about anything. They all begin with the 9 character job number, which is 2004-xxxx. My forms all handle this well, with a listbox using a looped Dir() function to populate it.
I also have a report called the Work Spec, which is a detail of each object that is meant to be changed, and it includes information for the QA group for what was tested and how to test, etc.
Here's my dilemma. I need to be able to print each of those documents in the Path that begin with the job number at the end of the report. I don't really even know how to begin. Should I put something into the Report_Close Event, or ReportFooter_Format? Do I insert each file as an object into the document, or print them separately after the Access Report has printed? And how would I go about doing that?
Can someone please provide some direction?
Thank you so much!
Mike.
Currently, I have a directory which stores all of our "Linked Documents". These can be anything from Text files (which came from the original Job System, which was COBOL based), to word docs, to pdf scans of Agency Requirements, to Excel Spreadsheets showing statistics - just about anything. They all begin with the 9 character job number, which is 2004-xxxx. My forms all handle this well, with a listbox using a looped Dir() function to populate it.
I also have a report called the Work Spec, which is a detail of each object that is meant to be changed, and it includes information for the QA group for what was tested and how to test, etc.
Here's my dilemma. I need to be able to print each of those documents in the Path that begin with the job number at the end of the report. I don't really even know how to begin. Should I put something into the Report_Close Event, or ReportFooter_Format? Do I insert each file as an object into the document, or print them separately after the Access Report has printed? And how would I go about doing that?
Can someone please provide some direction?
Thank you so much!
Mike.