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 Quotation file that is preformatted and will open up from Q1.


Thanks in advance for any possible help.

 

[Minty]

Manipulating word documents from Access is possible but pretty complicated for a beginner. Unless the word document is either very long or very cunningly formatted can a Access report not do the job?
They can be exported / saved to PDF which is then able to be emailed/stored in a specific folder.

 

[sud2017]

Thanks for the directions. I tried this code on a command button to open up the excel file but its not 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

Manipulating word documents from Access is possible but pretty complicated for a beginner. Unless the word document is either very long or very cunningly formatted can a Access report not do the job?
They can be exported / saved to PDF which is then able to be emailed/stored in a specific folder.

 

[sud2017]

Got it. Sorry for the confusion on above code which is wrong. I'm simply using insert hyperlink tool from Access now.