How to open an External PDF/Word file from a FORM

[sud2017]

Hi Guys,



Need help on my form:

Q1: I have created a FORM that allows me to perform cost estimation for different opportunities my company quote for. I want a command button in my form that would open up an external WORD document from our network directory. How can I do this?

Q2: Is it possible to include OUTPUT from my cost estimation FORM to the external document that opens up from Q1. For example, I want to include a few cost elements in a page of Quotation file that is preformatted and will open up from Q1.


Thanks in advance for any possible help.

[aytee111]

Q1: Get the file name - open the Browse window if you don't have it stored. Use the Application.FollowHyperlink command to open the file.
Q2: You will need to open the file, make modifications to it, save it, then open it.

[sud2017]

Thanks for the directions. I got this code on a command button which isn't opening up the file. Further guidance will be much appreciated.

Private Sub CmdOpenAttach_Click()
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
OpenFirstAttachmentAsTempFile rs, "P:\14-01-16 Project Planning Board.xlsx"
End Sub

Q1: Get the file name - open the Browse window if you don't have it stored. Use the Application.FollowHyperlink command to open the file.
Q2: You will need to open the file, make modifications to it, save it, then open it.

[aytee111]

I don't know what you are trying to do here. This code is using the recordset from the form. To open a file: Application.FollowHyperlink "P:\14-01-16 Project Planning Board.xlsx"

[sud2017]

Thanks Got it. Sorry for the confusion, I had got a wrong code from somewhere. Thanks again.

I don't know what you are trying to do here. This code is using the recordset from the form. To open a file: Application.FollowHyperlink "P:\14-01-16 Project Planning Board.xlsx"