By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Hyperlinking within a Database

P: n/a
Hello,

I have a listing report that lists all the different report numbers
for a given person. Is it possible to have each of the report numbers
as a hyperlink that would point to actual report itself? If it is not
possible to do it inside the listing report itself, is it possible to
do that in the query (datasheet view)?

Thank you for your help.

--Jason Coleman

Feb 22 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Feb 22, 11:18 am, "colemanj4" <colema...@gmail.comwrote:
Hello,

I have a listing report that lists all the different report numbers
for a given person. Is it possible to have each of the report numbers
as a hyperlink that would point to actual report itself? If it is not
possible to do it inside the listing report itself, is it possible to
do that in the query (datasheet view)?

Thank you for your help.

--Jason Coleman

I don't recall if post 97 versions allow this (I don't have one handy
to try it on) but what's interesting is that the Hyperlink property is
available for some controls on a report (namely labels) and the report
display the hyperlink, but does not allow you to select it. The mouse
cursor is stuck in magnification mode.

Setting a hyperlink to an internal is object is simple - set the
HyperlinkSubAddress property to the target name preceeded by it's
object type. Example Report rptTestMe.

Feb 22 '07 #2

P: n/a
On Feb 22, 11:18 am, "colemanj4" <colema...@gmail.comwrote:
Hello,

I have a listing report that lists all the different report numbers
for a given person. Is it possible to have each of the report numbers
as a hyperlink that would point to actual report itself? If it is not
possible to do it inside the listing report itself, is it possible to
do that in the query (datasheet view)?

Thank you for your help.

--Jason Coleman

I forgot to include...
If your intent is to display a list of reoprts that can be opened,
then use a form (continuous perhaps) instead. The hyperlink does work
there.

Feb 22 '07 #3

P: n/a
On Feb 22, 1:40 pm, "storrboy" <storr...@sympatico.cawrote:
On Feb 22, 11:18 am, "colemanj4" <colema...@gmail.comwrote:
Hello,
I have a listing report that lists all the different report numbers
for a given person. Is it possible to have each of the report numbers
as a hyperlink that would point to actual report itself? If it is not
possible to do it inside the listing report itself, is it possible to
do that in the query (datasheet view)?
Thank you for your help.
--Jason Coleman

I forgot to include...
If your intent is to display a list of reoprts that can be opened,
then use a form (continuous perhaps) instead. The hyperlink does work
there.
Storrboy, what you are describing is what I would like... but all I
can find in the properties of the text box of the information I am
displaying (in a continuous form now) is a Yes/No called Is Hyperlink
and I can't seem to find where I can enter where it should point.

Feb 22 '07 #4

P: n/a
On Feb 22, 3:16 pm, "colemanj4" <colema...@gmail.comwrote:
On Feb 22, 1:40 pm, "storrboy" <storr...@sympatico.cawrote:
On Feb 22, 11:18 am, "colemanj4" <colema...@gmail.comwrote:
Hello,
I have a listing report that lists all the different report numbers
for a given person. Is it possible to have each of the report numbers
as a hyperlink that would point to actual report itself? If it is not
possible to do it inside the listing report itself, is it possible to
do that in the query (datasheet view)?
Thank you for your help.
--Jason Coleman
I forgot to include...
If your intent is to display a list of reoprts that can be opened,
then use a form (continuous perhaps) instead. The hyperlink does work
there.

Storrboy, what you are describing is what I would like... but all I
can find in the properties of the text box of the information I am
displaying (in a continuous form now) is a Yes/No called Is Hyperlink
and I can't seem to find where I can enter where it should point.

I don't think textboxes have this property. I think labels,
commandbuttons and image boxes do.
So what I would do is either display the link (if not editable) in a
label or add a label/button to the row to act as a Go or Open button.

Feb 22 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.