M
Mike Mueller
System: Access 2007 on Vista Business
Background:
User created a well maintained db in Lotus Approach. He does not have the
ambition to learn how to redo in Access. This db is updated and maintained
properly, and monthly there are reports run on it using ~ 50 queries to
generate the ~75 reports. What has changed is that these reports must also
be converted to PDFs, and Approach is slower than pondwater creating them.
I have worked with him and now his macro that generates his reports also
creates a csv file. I have recreated the queries & reports in Access, and I
am using linked tables to his CSV files for the data. I have also been able
to reduce the amount of reports to match the queries. I am using the xls/pdf
addin from MS to save the reports to PDF, as it is quicker than printing to
Acrobat and takes less than 5 minutes. After the PDFs are generated, I need
to merge them into 1 big PDF.
What I would like to do is to get away from then opening in Acrobat and
inserting pages either manually or via there batch processing.
Is there a way to 'merge' all of the reports into 1 large one, and then send
it to pdf?
Background:
User created a well maintained db in Lotus Approach. He does not have the
ambition to learn how to redo in Access. This db is updated and maintained
properly, and monthly there are reports run on it using ~ 50 queries to
generate the ~75 reports. What has changed is that these reports must also
be converted to PDFs, and Approach is slower than pondwater creating them.
I have worked with him and now his macro that generates his reports also
creates a csv file. I have recreated the queries & reports in Access, and I
am using linked tables to his CSV files for the data. I have also been able
to reduce the amount of reports to match the queries. I am using the xls/pdf
addin from MS to save the reports to PDF, as it is quicker than printing to
Acrobat and takes less than 5 minutes. After the PDFs are generated, I need
to merge them into 1 big PDF.
What I would like to do is to get away from then opening in Acrobat and
inserting pages either manually or via there batch processing.
Is there a way to 'merge' all of the reports into 1 large one, and then send
it to pdf?