access to websites/hyperlinks in reports?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: RusCat (RusCat_at_discussions.microsoft.com)
Date: 09/15/04 

Date: Wed, 15 Sep 2004 06:55:05 -0700

Good evening,

I'm a novice Access user. Here is what I'm trying to do. I'd really
appreciate some input or suggestions for getting this to work.

> My company has a small library of reference materials.
> I have inventoried and entered them into a Table called LIBRARY
> One of the fields is the website, which I made a Hyperlink
> I have designed a Report and am able to pull up all the library information, so my colleages can scroll thru it, many records at a time . The hyperlink shows up as blue, but isn't "active"
> Thru my research on this site, I discovered that a report won't let me "activate" the hyperlink.
> I designed a form and the hyperlink works GREAT !! I'm very proud.

*** here's the problem.

1. The Report shows everything, by subject or category, and the user is
able to scroll thru the entire contents, but no access to the website for
said material. IE: 115 library items shows up on 11 pages of report. It's
a nice report, all grouped by category and subject, etc.
2. The Form allows access to the websites, but only allows the user to
scroll thru ONE record at a time, not see the results of a search by subject.

Does this make sense? I want to be able to have the library contents come
up and look like the report, but in a form so that the website/hyperlink can
be active.

Any suggestions or input will be GREATLY appreciated.
Thanks so much,
Lisa
  

Relevant Pages

  • Hyperlinks in forms for all records....
    ... > One of the fields is the website, which I made a Hyperlink ... 115 library items shows up on 11 pages of report. ... scroll thru ONE record at a time, not see the results of a search by subject. ...
    (microsoft.public.access.forms)
  • I think I know what to do.
    ... Make sure the 'Format' tab is selected in the Properties window. ... >> One of the fields is the website, ... The Report shows everything, by subject or category, and the user is ... > scroll thru ONE record at a time, not see the results of a search by subject. ...
    (microsoft.public.access.forms)
  • RE: access to websites/hyperlinks in reports?
    ... Perhaps you know of a way to "activate" the hyperlink in an actual report? ... so my colleages can scroll thru ...
    (microsoft.public.access.reports)
  • access to websites/hyperlinks in reports?
    ... Open your form in design view, select view> properties, ... >> One of the fields is the website, ... report won't let me "activate" the hyperlink. ...
    (microsoft.public.access.reports)
  • access to websites/hyperlinks in reports?
    ... Another approach to take would be to output your report ... so my colleages can scroll thru ... report won't let me "activate" the hyperlink. ... The Form allows access to the websites, ...
    (microsoft.public.access.reports)