Prev: Multiple Product Description and Quantities?
Next: Multi-Field Primary Key
From: Susan H. White on 2 Jan 2007 10:18
In a form, I have a listbox based on a table that contains Section,
Subsection, Page and Pathway. What I want to have happen is that selecting
one of the lines in the listbox automatically activates the Pathway so that
the specified document comes up in WORD.

I'm just unable to do this, despite hours of frustration with macros,
coding, etc. Can anyone help?

From: Rick Brandt on 2 Jan 2007 10:28
"Susan H. White" <SusanHWhite(a)discussions.microsoft.com> wrote in message
news:EC2E22E0-C804-45ED-9603-BC60B8E1D2A9(a)microsoft.com...
> In a form, I have a listbox based on a table that contains Section,
> Subsection, Page and Pathway. What I want to have happen is that selecting
> one of the lines in the listbox automatically activates the Pathway so that
> the specified document comes up in WORD.
>
> I'm just unable to do this, despite hours of frustration with macros,
> coding, etc. Can anyone help?

What code are you using now? I would expect something like...

Application.FollowHyperLink Me.ListBoxName.Column(3)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


From: Susan H. White on 2 Jan 2007 11:27
Exactly. I tried that code, built on a command button, just as you specified
earlier, but that didn't work. Then I tried building a macro. More failure.
Can't believe I'm this stupid. Susan

"Rick Brandt" wrote:

> "Susan H. White" <SusanHWhite(a)discussions.microsoft.com> wrote in message
> news:EC2E22E0-C804-45ED-9603-BC60B8E1D2A9(a)microsoft.com...
> > In a form, I have a listbox based on a table that contains Section,
> > Subsection, Page and Pathway. What I want to have happen is that selecting
> > one of the lines in the listbox automatically activates the Pathway so that
> > the specified document comes up in WORD.
> >
> > I'm just unable to do this, despite hours of frustration with macros,
> > coding, etc. Can anyone help?
>
> What code are you using now? I would expect something like...
>
> Application.FollowHyperLink Me.ListBoxName.Column(3)
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>
From: Rick Brandt on 2 Jan 2007 11:30
"Susan H. White" <SusanHWhite(a)discussions.microsoft.com> wrote in message
news:4F43A588-A108-4849-A388-BB35725577B7(a)microsoft.com...
> Exactly. I tried that code, built on a command button, just as you specified
> earlier, but that didn't work. Then I tried building a macro. More failure.
> Can't believe I'm this stupid. Susan

Forget Macros. They will only hold you back. What exactly "didn't work"? Did
you get an error?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


From: Susan H. White on 2 Jan 2007 12:52
I get Compile Error. Method or data member not found.

"Rick Brandt" wrote:

> "Susan H. White" <SusanHWhite(a)discussions.microsoft.com> wrote in message
> news:4F43A588-A108-4849-A388-BB35725577B7(a)microsoft.com...
> > Exactly. I tried that code, built on a command button, just as you specified
> > earlier, but that didn't work. Then I tried building a macro. More failure.
> > Can't believe I'm this stupid. Susan
>
> Forget Macros. They will only hold you back. What exactly "didn't work"? Did
> you get an error?
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>
 |  Next  |  Last
Pages: 1 2 3 4 5 6
Prev: Multiple Product Description and Quantities?
Next: Multi-Field Primary Key