Database Reports - display and access

Bob Waggoner · External Since: Jan 08, 2009 Posts: 5

We have used hyperlinks up until the switch from Access 97 to Access 2003 to
access our documents/reports from inside the database. Access 2003 doesn't
seem to want that to happen. When we edit hyperlinks, we cannot browse inside
the database as we once could to link to the report. IF we can do that, will
someone explain how...please.

If not, I need to know how to display a form with selected reports that can
be accessed by clicking on the report name. Beyond that, how can I create a
second form (side by side) that allows users to set criteria for that report
such as start/end date, only open records or closed records, etc?

If someone has a way to help me, it would be very much appreciated. Thank you.
Bob

NG · External Since: Aug 07, 2009 Posts: 5

Hi Bob,

if you create a command button on the form, you still can set the hyperlink
property to a database object.
--
Kind regards
Noëlla

"Bob Waggoner" wrote:

> We have used hyperlinks up until the switch from Access 97 to Access 2003 to
> access our documents/reports from inside the database. Access 2003 doesn't
> seem to want that to happen. When we edit hyperlinks, we cannot browse inside
> the database as we once could to link to the report. IF we can do that, will
> someone explain how...please.
>
> If not, I need to know how to display a form with selected reports that can
> be accessed by clicking on the report name. Beyond that, how can I create a
> second form (side by side) that allows users to set criteria for that report
> such as start/end date, only open records or closed records, etc?
>
> If someone has a way to help me, it would be very much appreciated. Thank you.
> Bob

Bob Waggoner · External Since: Jan 08, 2009 Posts: 5

Noella - right now, we have a table that records the quality information
about the document - date created, title, number, etc. There is a field for a
hyperlink to the document. In this way, I don't have to create 150 command
buttons to the reports in the database. I can use the hyperlink to open them
- and we can link the table to another Access database that allows users
access to those documents as well.

I need to know how to create a form that accesses reports - or how to get
the hyperlink dialogue box to link to internal reports.

Bob

"NG" wrote:

> Hi Bob,
>
> if you create a command button on the form, you still can set the hyperlink
> property to a database object.
> --
> Kind regards
> Noëlla
>
>
> "Bob Waggoner" wrote:
>
> > We have used hyperlinks up until the switch from Access 97 to Access 2003 to
> > access our documents/reports from inside the database. Access 2003 doesn't
> > seem to want that to happen. When we edit hyperlinks, we cannot browse inside
> > the database as we once could to link to the report. IF we can do that, will
> > someone explain how...please.
> >
> > If not, I need to know how to display a form with selected reports that can
> > be accessed by clicking on the report name. Beyond that, how can I create a
> > second form (side by side) that allows users to set criteria for that report
> > such as start/end date, only open records or closed records, etc?
> >
> > If someone has a way to help me, it would be very much appreciated. Thank you.
> > Bob

NG · External Since: Aug 07, 2009 Posts: 5

Hi Bob,

in the form, show the hyperlink in a text box. To edit the link,, right
click on the hyperlink field and choose the Menu Hyperlink -> Edit Hyperlink
--
Kind regards
Noëlla

"Bob Waggoner" wrote:

> Noella - right now, we have a table that records the quality information
> about the document - date created, title, number, etc. There is a field for a
> hyperlink to the document. In this way, I don't have to create 150 command
> buttons to the reports in the database. I can use the hyperlink to open them
> - and we can link the table to another Access database that allows users
> access to those documents as well.
>
> I need to know how to create a form that accesses reports - or how to get
> the hyperlink dialogue box to link to internal reports.
>
> Bob
>
> "NG" wrote:
>
> > Hi Bob,
> >
> > if you create a command button on the form, you still can set the hyperlink
> > property to a database object.
> > --
> > Kind regards
> > Noëlla
> >
> >
> > "Bob Waggoner" wrote:
> >
> > > We have used hyperlinks up until the switch from Access 97 to Access 2003 to
> > > access our documents/reports from inside the database. Access 2003 doesn't
> > > seem to want that to happen. When we edit hyperlinks, we cannot browse inside
> > > the database as we once could to link to the report. IF we can do that, will
> > > someone explain how...please.
> > >
> > > If not, I need to know how to display a form with selected reports that can
> > > be accessed by clicking on the report name. Beyond that, how can I create a
> > > second form (side by side) that allows users to set criteria for that report
> > > such as start/end date, only open records or closed records, etc?
> > >
> > > If someone has a way to help me, it would be very much appreciated. Thank you.
> > > Bob

Bob Waggoner · External Since: Jan 08, 2009 Posts: 5

The popup dialogue box doesn't show browsing inside the database. It only has
the following: Left side: Existing file or web page; Create New Page; and
E-mail Address. Inside that, below LOOK IN it has: Current Folder; Browsed
Pages; and Recent Files. At the top it has: Text to Display and Screen tip.
The look in combo lets you browse outside of the database. The current folder
- if you select the database, only hyperlinks to the database, but not to a
form or report inside the database. That's the part that is no longer
available. Do I need to re-install Access 2003 with a particular wizard or is
it just Access 2003?

"NG" wrote:

> Hi Bob,
>
> in the form, show the hyperlink in a text box. To edit the link,, right
> click on the hyperlink field and choose the Menu Hyperlink -> Edit Hyperlink
> --
> Kind regards
> Noëlla
>
>
> "Bob Waggoner" wrote:
>
> > Noella - right now, we have a table that records the quality information
> > about the document - date created, title, number, etc. There is a field for a
> > hyperlink to the document. In this way, I don't have to create 150 command
> > buttons to the reports in the database. I can use the hyperlink to open them
> > - and we can link the table to another Access database that allows users
> > access to those documents as well.
> >
> > I need to know how to create a form that accesses reports - or how to get
> > the hyperlink dialogue box to link to internal reports.
> >
> > Bob
> >
> > "NG" wrote:
> >
> > > Hi Bob,
> > >
> > > if you create a command button on the form, you still can set the hyperlink
> > > property to a database object.
> > > --
> > > Kind regards
> > > Noëlla
> > >
> > >
> > > "Bob Waggoner" wrote:
> > >
> > > > We have used hyperlinks up until the switch from Access 97 to Access 2003 to
> > > > access our documents/reports from inside the database. Access 2003 doesn't
> > > > seem to want that to happen. When we edit hyperlinks, we cannot browse inside
> > > > the database as we once could to link to the report. IF we can do that, will
> > > > someone explain how...please.
> > > >
> > > > If not, I need to know how to display a form with selected reports that can
> > > > be accessed by clicking on the report name. Beyond that, how can I create a
> > > > second form (side by side) that allows users to set criteria for that report
> > > > such as start/end date, only open records or closed records, etc?
> > > >
> > > > If someone has a way to help me, it would be very much appreciated. Thank you.
> > > > Bob