[AccessD] OT: Hyperlinks by automation

Thanks Michael:

The Microsoft link clinches it.  I can dirty the form in the event that 
opens Excel, but then the user is prompted to save.  I can code a save, but 
the user may need to cancel changes so that's no good.  In either event, 
some code is required.  The 'Back' button mentioned in the Microsoft article 
is not applicable to Word docs and unhiding a window is as bad or worse than 
right click and navigating the menus.  In any event, the Microsoft solution 
of unhiding a workbook doesn't work on our Terminal Server as the file is 
completely closed.  I could use the follow hyperlink method but as long as 
there is a need to add code, I'll just use shellExecute.

Thanks for the definitive answer.  I'll switch to storing the file path in a 
hidden column and skip the hyperlinks entirely.

Hen



>From: "Michael R Mattys" <michael.mattys at adelphia.net>
>Reply-To: accessd at databaseadvisors.com
>To: <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] OT:  Hyperlinks by automation
>Date: Tue, 8 Apr 2003 14:32:21 -0400
>
>Henry,
>
>I hope this may help
>
>Document Disappears After Clicking Hyperlink
>http://support.microsoft.com/default.aspx?scid=KB;en-us;q156264
>
>You might also look into the FollowHyperlink method:
>ActiveWorkbook.FollowHyperlink Address:= _
>"http://www.gohere.com",  NewWindow:=True
>
>Michael R. Mattys
>www.mattysconsulting.com
>
>----- Original Message -----
>From: "Henry Simpson" <hsimpson88 at hotmail.com>
>To: <accessd at databaseadvisors.com>
>Sent: Tuesday, April 08, 2003 10:42 AM
>Subject: [AccessD] OT: Hyperlinks by automation
>
>
> > I have an Access 97 procedure that creates a series of Word 97 Doc
>invoices
> > and adds a row in an Excel 97 sheet summarizing each invoice as it
>generates
> > each document.  Each document is saved into a specific project folder
> > determined by the application.  In the past, the code also did a .SaveAs
>to
> > an invoicing folder created for the year and month so that all the
>documents
> > could be retrieved from a single location.  This made it easy to just 
>drag
> > all the files from Explorer to a single email to accounting.  The
> > alternative had been to open each project record, open the linked folder
>and
> > drag one document at a time which was very tedious when there were many
> > invoices.  The monthly group folder was supposed to be temporary but
>because
> > of the convenience of being able to work with multiple invoices in a
>single
> > location, some users were inclined to make required revisions to 
>invoices
>in
> > this location rather than in the project folder.  The end result was 
>that
>we
> > wound up with document version issues.
> >
> > I've been implementing an alternate solution where the access 
>application
> > inserts a hyperlink to each invoice document in the Excel summary sheet.
> > The advantage is that when a user makes a revision, he is reminded by 
>the
> > presence of the Excel sheet to update the Excel entry and users have a
> > single place from which all invoices can be conveniently opened and the
> > document is the one in the actual project folder.  Mail traffic is also
> > reduced since we had anywhere from 80 to 200 documents of about 25k size
> > that were being attached.  Also, because I use a UNC link, the sheet 
>works
> > to open pertinent documents from anywhere on the WAN.
> >
> > Not having worked with hyperlinks before, I've run into an annoyance.
>When
> > a user merely clicks on a hyperlink, the Word doc opens but the Excel
> > workbook closes leaving the Excel application open.  In order to keep 
>the
> > Excel workbook open, it is necessary for users to right click the
>hyperlink
> > and select the hyperlink context sensitive menu item and then select 
>Open
>in
> > New Window from a fly out menu.  All this mousing and clicking is 
>annoying
> > and I would prefer that Excel remain open if the user simply (left) 
>clicks
> > the hyperlink.  Is there any way to implement this?
> >
> > Hen


_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail