Question Open .doc template on network and auto save path on form?

[Jman883]

The following would be done in a form.
I am trying to open a template.doc on the network and when completed the user would click save as, then specify location and file name. I would like this location and file name to be visible like a hyperlink.

Is there an easy way of accomplishing this?

Thank for you help.

 

[HiTechCoach]

The following would be done in a form.
I am trying to open a template.doc on the network and when completed the user would click save as, then specify location and file name. I would like this location and file name to be visible like a hyperlink.

Is there an easy way of accomplishing this?

Thank for you help.

In Access:

I would first ask for the name and location of where to store the file. Store the path in a field that you can later display as a hyperlink (I would NOT use a hyperlink data type field in a table.)

Using Word Automation, create a new document based on the template.

Have you got any code started yet?

What do you mean by easy? This is about as easy as I know:

Super Easy Word Merge
***** You will need to scroll down the page to find it. ****

 

[Jman883]

First and foremost thank you for responding, and please disregard the "easy".

Ok, here is what I have.

Private Sub Command19_Click()
On Error GoTo Err_Command19_Click

    Dim oApp As Object

    Set oApp = CreateObject("Word.Application")
    oApp.Visible = True

Exit_Command19_Click:
    Exit Sub

Err_Command19_Click:
    MsgBox Err.Description
    Resume Exit_Command19_Click
    
End Sub

Then on the format tab\hyperlink address is the network path

Q:\HRPROC\SAFETY\Safety Stop Light Postings\2009 safety stoplight postings\Safety 8 D's\8D Master Blank.doc

I've created a text box to hold the new file path.
This is as far as I've got.

Thanks

 

[Jman883]

Ok, for now I can do it this way unless someone has a better suggestion

The data table has a field selected as hyperlink, the default value to the template.doc. The user will have to manually rename the hyperlink from the user form by selecting edit hyperlink.