At present we use an Access 2003 report to print a drivers Load Sheet, when the "Print Load Sheet" button is clicked on a form a macro runs which prints the Load Sheet report, then runs a few queries to flag it as printed (puts a tick in a field named "Printed" on a local access table) and then mails the Load Sheet details to the courier.
Ideally we need to replicate this behaviour but using a crystal report instead of access report. The back-end database has changed and re-writing the access report has proved to be impractical.
We are using Access 2003 and Crystal 2008 (for SAP Business One).
Would really appreciate any help on this, I have managed to get a crystal report version of the Load Sheet report to open from access by using the FollowHyperLink method but obviously this only opens the report.
If I could somehow open the report and automatically print and then save it then this would be ideal but I understand that this may not be possible. any help appreciated