access to websites/hyperlinks in reports?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
Click to expand...

*** 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
 
Open your form in design view, select view > properties,
now make your selection in default view, where you can
view single form, continuous form, or datasheet.
Hope this helps.
Fons
-----Original Message-----
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.
Click to expand...
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"
 
To make the form look more like a report, like a heading
and a listing of information, create a form with the non
detail specific information and than create a suberport
for the detail type information displayed in datasheet
format.
Basically open a form (new or old) in design view palce
the non-changing information on this form, like
organization etc. Now drag a subreport using the wizard
and follow the instructions, this will create a subreport
for you which you can modify just like a regular form or
report in design view.
Hope this helps.
Fons
 
Another approach to take would be to output your report
in HTML and post it to your company's intranet. This way
you can link to files, websites, etc. The plus side is
that you don't have to have Access installed to view the
report.

Food for thought.

John Cello
John Cello Consulting
Communications For Business
www.johncelloconsulting.com
-----Original Message-----
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.
Click to expand...
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"
 
Back
Top