Re: Application.Hyperlink question
From: Kurt (anonymous_at_discussions.microsoft.com)
Date: 03/03/04
- Next message: Roger Carlson: "Re: Application.Hyperlink question"
- Previous message: lschaaf: "Pivot Table Form Wizard"
- In reply to: Roger Carlson: "Re: Application.Hyperlink question"
- Next in thread: Roger Carlson: "Re: Application.Hyperlink question"
- Reply: Roger Carlson: "Re: Application.Hyperlink question"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 3 Mar 2004 11:43:10 -0800
> What file did you store and what
> application is associated with the extension.
On your form, I entered a new doc called "Test." (All I
did was enter the word "Test.")
Then I clicked on Test, hoping to see the Windows File
Open/Save dialog appear, where I would have browsed to a
certain .doc (MS Word) file on my hard drive and selected
it, thereby establishing the link.
I sense that the double click event never had a chance to
execute, because the moment I click on the word "Test" it
begins the search for an http:// reference and opens the
browser. (Would changing the field type from hyperlink to
text resolve this?)
Kurt
>-----Original Message-----
>That's very strange. On my system it opens the document
in the associated
>application (Word, Excel, Notepad, etc). What file did
you store and what
>application is associated with the extension.
>--
>--Roger Carlson
> www.rogersaccesslibrary.com
> Reply to: Roger dot Carlson at Spectrum-Health dot Org
>
>
>"Kurt" <anonymous@discussions.microsoft.com> wrote in
message
>news:653801c4014d$b6b63300$a501280a@phx.gbl...
>> That's definitely the feature I'm looking for. However,
>> when I clicked on a new doc I entered in your form, it
>> treated it as a http:// link and opened up my browser.
>>
>> (The same thing happened when I imported all the modules
>> and code into my own database. And I do have a DAO
>> reference checked.)
>>
>> Any ideas? Thanks. Kurt
>>
>> >-----Original Message-----
>> >On my website is a small sample database
>> called "SetHyperlink" which
>> >illustrates how to do this.
>> >
>> >--
>> >--Roger Carlson
>> > www.rogersaccesslibrary.com
>> > Reply to: Roger dot Carlson at Spectrum-Health dot
Org
>> >
>> >"Kurt" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:37bf01c40135$303cc540$a601280a@phx.gbl...
>> >> I have a subform (in datasheet view) where users can
>> enter
>> >> a submission type (e.g., "application", "amendment")
>> for a
>> >> study. I would like to give them the option of
linking
>> the
>> >> word they just typed to a Word document (e.g., the
>> actual
>> >> application), so in the future they can just click on
>> the
>> >> word and the linked document will open.
>> >>
>> >> I presume that I should use
Application.FollowHyperlink,
>> >> but how I can set things up so the user can select
the
>> >> path to the stored document? An ideal interface would
>> be a
>> >> file tree that pops up and allows the user
to "browse"
>> to
>> >> the file and then select it.
>> >>
>> >> Here's some code I've come up with, but I'm not sure
if
>> >> I'm on the right track:
>> >>
>> >> Private Sub Submission_Click()
>> >> Dim strAppName As String
>> >> strAppName = 'the path
>> >> (e.g., "C:\StudyA\Application.doc" identified by the
>> user
>> >> would go here
>> >> Application.FollowHyperlink strAppName
>> >> End Sub
>> >>
>> >> Thanks. Kurt
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Roger Carlson: "Re: Application.Hyperlink question"
- Previous message: lschaaf: "Pivot Table Form Wizard"
- In reply to: Roger Carlson: "Re: Application.Hyperlink question"
- Next in thread: Roger Carlson: "Re: Application.Hyperlink question"
- Reply: Roger Carlson: "Re: Application.Hyperlink question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
