How to: Use a hyperlink to open a Report?

[dog]

Does anyone know how to use a hyperlink in MS Access (I'm using 97) to
open a report or form within the same database?

I have a form in my database, I have put a label on it, some text, and
when the user clicks on it I want it to open one of the reports.

It's easy enough to use the 'On Click' Event procedure to open another
object, however when the user puts the mouse pointer over the label I
would like the 'hand' to appear, as it does when you click on links on
web pages.

Any help would be deeply appreciated!

[Lyle Fairfield]

Re: How to: Use a hyperlink to open a Report?

dogman_2000@hot mail.com (dog) wrote in news:d15cbf16.0 311200141.675eb ae8
@posting.google .com:
[color=blue]
> Does anyone know how to use a hyperlink in MS Access (I'm using 97) to
> open a report or form within the same database?
>
> I have a form in my database, I have put a label on it, some text, and
> when the user clicks on it I want it to open one of the reports.
>
> It's easy enough to use the 'On Click' Event procedure to open another
> object, however when the user puts the mouse pointer over the label I
> would like the 'hand' to appear, as it does when you click on links on
> web pages.
>
> Any help would be deeply appreciated![/color]

Opening internal objects with hyperlinks is a pretty good idea. Wish I had
thought of it! One can have some of the niceties associated with HTML
buttons this way.
In ACXP the wizard for Hyperlinks allows one to choose "Objects in This
Database" and to select a report in this way. I don't know if this is
enabled in AC97. If it's not perhpas one can just enter:
Report Report1
in the HyperLink SubAddress box of the Properties Dialog?

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Keith Wilby]

Re: How to: Use a hyperlink to open a Report?

Lyle Fairfield <MissingAddress @Invalid.Com> wrote:
[color=blue]
> If it's not perhpas one can just enter:
> Report Report1
> in the HyperLink SubAddress box of the Properties Dialog?[/color]

Tried that, it didn't work.

Keith.

[Rick Brandt]

Re: How to: Use a hyperlink to open a Report?

"Keith Wilby" <keith.wilby@Aw ayWithYerCrap.c om> wrote in message
news:Xns94397AC CC93CCkeithwilb y@10.15.188.42. ..[color=blue]
> Lyle Fairfield <MissingAddress @Invalid.Com> wrote:
>[color=green]
> > If it's not perhpas one can just enter:
> > Report Report1
> > in the HyperLink SubAddress box of the Properties Dialog?[/color]
>
> Tried that, it didn't work.[/color]

I have literally hundreds of these and I have never seen one "not work".
Do you get an error? Does anything happen at all? Do you see the name of
the report in the status bar when you hover over the link? Does it even
act like a link (blue, underlined, and making the mouse pointer change)?


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Arno R]

Re: How to: Use a hyperlink to open a Report?

Just tried this also,
It works with me (A97).
'Should' work with you also no?
I just use the 'builder' ( ... ) for the hyperlinksubadd ress property

--
Hope this helps
Arno R



"Keith Wilby" <keith.wilby@Aw ayWithYerCrap.c om> schreef in bericht
news:Xns94397AC CC93CCkeithwilb y@10.15.188.42. ..[color=blue]
> Lyle Fairfield <MissingAddress @Invalid.Com> wrote:
>[color=green]
> > If it's not perhpas one can just enter:
> > Report Report1
> > in the HyperLink SubAddress box of the Properties Dialog?[/color]
>
> Tried that, it didn't work.
>
> Keith.[/color]

[Keith Wilby]

Re: How to: Use a hyperlink to open a Report?

"Rick Brandt" <rickbrandt2@ho tmail.com> wrote:
[color=blue][color=green]
>> Tried that, it didn't work.[/color]
>
> I have literally hundreds of these and I have never seen one "not
> work". Do you get an error? Does anything happen at all? Do you see
> the name of the report in the status bar when you hover over the link?
> Does it even act like a link (blue, underlined, and making the mouse
> pointer change)?
>[/color]

I really should read posts properly before I respond! Sorry folks, I tried
it in the Hyperlink Address property. I'm off back under my stone now ;-)

[dog]

Re: How to: Use a hyperlink to open a Report?

Thanks everyone - tried it and it worked.
I should of used my brain and tried the hyperlink sub-address.


Keith Wilby <keith.wilby@Aw ayWithYerCrap.c om> wrote in message news:<Xns943987 9827283keithwil by@10.15.188.42 >...[color=blue]
> "Rick Brandt" <rickbrandt2@ho tmail.com> wrote:
>[color=green][color=darkred]
> >> Tried that, it didn't work.[/color]
> >
> > I have literally hundreds of these and I have never seen one "not
> > work". Do you get an error? Does anything happen at all? Do you see
> > the name of the report in the status bar when you hover over the link?
> > Does it even act like a link (blue, underlined, and making the mouse
> > pointer change)?
> >[/color]
>
> I really should read posts properly before I respond! Sorry folks, I tried
> it in the Hyperlink Address property. I'm off back under my stone now ;-)[/color]