Creating a Button

Question

Hello, 

I am currently working on a database which requires me to creat buttons to external hyperlinks. Each link should take the user to the individual partys information. The problem I am having is that the hyperlink says constent even when  a diffrent partys information has been serached . Is there any wasy to create a hyperlink that will change when each of the partys infromation is changed. 

Thanks!

Answer 1

Hi,

It would help if you could show us how you're creating the hyperlinks. Also, if it's a hyperlink, why use a button?

Answer 2

Hi,

This looks like a duplicate thread. Not sure if that is allowed.

Just my 2 cents...

Answer 3

The hyperlink address is an attribute of the party, so should be stored in a column in a Parties table.  It can then be referenced anywhere in the database.

I would advise the column be of Short Text data type, named PartyLink say.  The Hyperlink data type is more trouble than it is worth.  The FollowHyperlink method of the Application object can then be used to open the link.  Say, for example, you have a form base on the Parties table, or more likely a query which includes the table, a button in the form would open the currently selected party's link in the default browser with the following code:

    Application.FollowHyperlink Me.PartyLink

Whenever the value in the PartyLink column in a row in the Parties table is changed, the above code would open the new link.

---

Ken Sheridan, Stafford, England

Answer 4

Se my reply to your original thread.

---

Ken Sheridan, Stafford, England