I have set up a project database and have given users the option to attach relevant documents to each project record. I have also included this in the report; so from the report I can open up the attached documentation.
My problem comes when I email the report. I have set up an automated button for users to email the report from the report itself. This works great and the report retains the same format as it has within access, however, my attachments are not working.
I guess I assumed it would work like an embedded document once the report was emailed, this seems to not be the case.