Attachments within a Report

mdg

Registered User.
Local time
Today, 03:26
Joined
Feb 17, 2011
Messages
68
I would like to be able to run a report and be able to click on an 'Attachment' button to see the attachments for a particular record within a report so that I can view the attachment and print if needed. Better yet, how could I get the report to list the attachment names (filename.pdf, filename.doc, etc..) in the report so I can simply click on the individual attachment, view and print if need be.
Thanks
 
Now I could be wrong on this, but i THINK you can have a button on a report that you can have in your details section. you should be able to program that button to open the attachment associated with that detail, but the problem is that it would look really ugly.
Does it NEED to be in a "Report" or would it be possible to create a form with a list box displaying all the attachments for a filtered record. From there perhaps you could view each item and.. have a button that generates a report of the attachment list if needed. Would that be an option? from a user aspect, i think it would yield much better results.
Also, how is your relationship set up between attachments and the record?
 
Access_guy49 - Thanks for the reply.
I was wanting to have it available within a report to make it easier for someone to scroll up and down the report results and pick and select the record in question, then be able to click on an attachment button to view any attachments that are attached to that particular record. Having a form would not really work the way I want (I don't think).
 
A continuous form would yield those results. That's what I would use only because i've always been a believer that the reports should be for printing, and the forms should be for user interaction.

If you created a continuous form and had a listbox which populated it's row source with attachments from the parent.. it would work perfectly, you could then create code on the double click event of the list box to open the selected attachment... that might work?
 
Thanks for the reply Access_guy49. That's what I will need to do. I can make the continuous form look just like the report and put a button on it as well for printing the report view.
 

Users who are viewing this thread

Back
Top Bottom