How to Send a Report (.pdf) to the Attachment field of a record?

[ijo68]

Hello All,



I am using the following code to send a report to the "FSGs" folder on the C drive. I will like to instead send to the attachment field of the record using command5 button, can anyone point me in the right direction please.. Thanks in advance.

Private Sub Command5_Click()
On Error Resume Next
Dim fileName As String
Dim filepath As String


fileName = "Activity Report"
filepath = "c:\FSGs" & fileName & ".pdf"
DoCmd.OutputTo acOutputReport, "DailyActRpt", acFormatPDF, filepath


End Sub

[Welshgasman]

A). It is not recommended as it just bloats the DB
B). If you insist on doing it, save to pdf. then find the file and add to the attachment field.?

[Micron]

I agree. No attachments in tables, only file paths as text.

[ijo68]

I agree. No attachments in tables, only file paths as text.

Can I use VBA to send hyperlink to a field?

[Welshgasman]

Yes, Use a hyperlink to the flie location or a function that opens up whatever the file is, with the native app on the computer.

[Micron]

It's enough to just store the file path in the table field without formatting it a hyperlink and use code/macro to follow it - unless you're working with open tables, which you should not be doing.

[ijo68]

Yes, Use a hyperlink to the flie location or a function that opens up whatever the file is, with the native app on the computer.

I changed the attachment field to a hyperlink field , the added " HypFld = filepath " to my code.... that inserted the file path ( C\FSGs\Activity Report.pdf ) as a hyperlink into the field(HypFld), but when I click on it , doesn't do anything.. It is a valid path since it works when I place it in the file explorer window.. any idea why it won't work from the field?

[Micron]

I believe hyperlink syntax for Windows files is file:/// then the path. You're basically dealing with something that was meant for a browser, so file URL's start with what I posted.

[Welshgasman]

You do not have the : for the drive letter either?

[Micron]

Probably just a typo. It is in the code of post #1.

[Welshgasman]

Probably just a typo. It is in the code of post #1.

That code does not have a closing \ for the folder either?

Why don't people copy and paste what they ACTUALLY use?

[ijo68]

Needed to add this to the onClick event of the hyperlink field... Application.FollowHyperlink Me.HypL.Value

Than you