Kumar-
The FileName property of an Attachment field will give you the original file
name, but that won't include the full path to the file, so it won't work as
a Hyperlink. After you have saved an external file in an Attachment field,
there is no connection to the original file other than the file name. You
would have to write code to export the attachment separately and store the
path where you exported it.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of access_kri
Sent: Friday, May 17, 2013 10:08 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Exporting report with Attachment
Dear All,
I have a continuous form that has attachments for some records. I
use a command button to export the records to excel. But the attachment
field is not getting exported. When I open the report in Access, the
attachment field is diplayed and I can open the attached files. Is it
possible that the attachments are displayed as hyperlink to open the
attachment when exporting to excel.
Thanks and Regards,
Kumar
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar