G
Guest
I queried the user groups and found beaucoup ways to open a single hyperlink,
something that I'm pretty sure I already knew. But to open a specific
hyperlink from a table of hyperlinks was not found. Here's the scenario.
I have a database that tracks compliance with contracts / agreements. The
database has over three hundred companies that hold over four hundred
agreements. Each company may have one or multiple agreements.
The companies are stored in the table "Companies" and the agreements in the
table "Agreements". (Now that's an original naming convention.) The two
tables are linked so that when the forms based on these tables is opened,
each company only opens those agreements for which an agreement exists. So if
Company A has four agreements, 1 thru 4, then the main form opens with
Company A and the agreements subform opens with Agreement 1. There are
navigation buttons to navigate to the subforms for the other three
agreements. (there's also a subform in the Agreements subform that tracks the
annual performance).
What I want to do is show on the Agreements subform a hyperlink to the URL
that has the PDF agreement. So on the Company A Agreement 1 subform the
hyperlink would be www.sampleserver.com/agreement1.pdf. On the Company A
Agreement 2 subform, the URL would be www.sampleserver.com/agreement2.pdf.
My first thought was to have a text box bound to a table with all of the
agreement's hyperlinks with a Cmd Button on the Agreements subform calling
the specific file. Would this be the cleanest method? Or would it be better
to just add the hyperlink to each subform and make it "live"?
Thank you.
something that I'm pretty sure I already knew. But to open a specific
hyperlink from a table of hyperlinks was not found. Here's the scenario.
I have a database that tracks compliance with contracts / agreements. The
database has over three hundred companies that hold over four hundred
agreements. Each company may have one or multiple agreements.
The companies are stored in the table "Companies" and the agreements in the
table "Agreements". (Now that's an original naming convention.) The two
tables are linked so that when the forms based on these tables is opened,
each company only opens those agreements for which an agreement exists. So if
Company A has four agreements, 1 thru 4, then the main form opens with
Company A and the agreements subform opens with Agreement 1. There are
navigation buttons to navigate to the subforms for the other three
agreements. (there's also a subform in the Agreements subform that tracks the
annual performance).
What I want to do is show on the Agreements subform a hyperlink to the URL
that has the PDF agreement. So on the Company A Agreement 1 subform the
hyperlink would be www.sampleserver.com/agreement1.pdf. On the Company A
Agreement 2 subform, the URL would be www.sampleserver.com/agreement2.pdf.
My first thought was to have a text box bound to a table with all of the
agreement's hyperlinks with a Cmd Button on the Agreements subform calling
the specific file. Would this be the cleanest method? Or would it be better
to just add the hyperlink to each subform and make it "live"?
Thank you.