Hyperlinks and Global Template

[smmbduner]

I have created a global template, which looks at the document name, and if it
is a new document (i.e. name = Document1, Document2, etc.) it ask them if
they would like the document added to an Access application (as a hyperlink
in a table) they use. It will then also save it to a network location with
the date and time as the file name.

This part all works fine, but I have now received a request that if a saved
document (which is already in the Access table) is a quote they would like to
be able to save it again, as a new file and have it added to the table again.
So what I have done is as part of the global template is to put an elseif
statement to look if it is saved in the Quote folder, to ask them if they
would like to save as a new document. This also works fine if you open the
file directly, but if you click the hyperlink from the Access application it
doesn't work unless you already have Word open on your PC. Does any one have
any suggestions, or have a fix for this? Thanks for all your help in advance.

 

[Word Heretic]

G'day smmbduner <[email protected]>,

Does putting a \n switch in the hyperlink field help?


Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


smmbduner reckoned:

 

[smmbduner]

Adding a \n or a /n to the beginning or the end of the hyperlink only caused
the document to not open at all.

I may have found a workaround through Access for this though. It will
involve a lot of trial and error in VBA coding, but I will give it a shot. I
will keep everybody posted to if my new idea of copying the document will
work. Thanks.