Not sure how you set up the table, but it would be in a subreport. Since each vendor can have many attachments. If you added it to the query then you would end up with a "duplicate" vendor record for each attachment. Are you using the hyperlink field? If so you will probably have to do some string manipulation in a query to return just the file name from the long url path. Can you describe what fields you have in your table, and if possible post an example of what is in the hyperlink field. Maybe the easiest answer would be when you add the hyperlink you change the display text to just the file name manually. The hyperlink has 4 parts displaytext#address#subaddress#screentip. If your displaytext is just the filename then you should be able to pull that out. I will have to test.
On Fri, May 30, 2014 at 3:18 PM, ka0t1c_ang3l <no_reply@yahoogroups.com> wrote:
Thanks for your help!! I now have a subform with the attachments, and the users are able to open the documents!!
I want to list the attachments on my compliance report, how would I do that? Is it as simple as adding the attachmentname to the compliance query? Each vendor has a compliance report, so the report would have to list the attachments associated with that vendor.
Thanks!
__._,_.___
Posted by: Peter Poppe <plpoppe@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (25) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar