Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / September 2005

Tip: Looking for answers? Try searching our database.

Hyperlinks and Global Template

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
smmbduner - 12 Sep 2005 16:58 GMT
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 - 13 Sep 2005 15:09 GMT
G'day smmbduner <smmbduner@discussions.microsoft.com>,

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:

>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
[quoted text clipped - 11 lines]
>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.
smmbduner - 14 Sep 2005 13:28 GMT
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.

> G'day smmbduner <smmbduner@discussions.microsoft.com>,
>
[quoted text clipped - 22 lines]
> >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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.