Thanks for the suggestion AccessMSSQL. I guess as the current version of the report is working fine in the other instances, it's worth making a copy of my existing Report as well just for the e-mail routine?
Also just for clarity would it matter if the 'querydef' is included in the VB Module...
Hi all, hope you can help with this as I am a bit of a newbie when it comes to Access and VBA...
I am developing a database system at work that is used to record audits of work quality, and we want to be able to e-mail an Access report to workers where quality issues have been identified -...
Hi all,
I have recently taken over a project at work to develop a database from a colleague and have hit a stumbling block on the following module that was originally written to send an Access report as an e-mail attachment.
I have used it to add in a routine which saves a copy of the report...