Hyperlink on subforms.

[Danden]

I have a tab form that contains two sub forms, that shows the result of two different queries. How can I display some attributes on subform (eg. certificat) as a hyperlink, when I click on the tab?

 

[pr2-eugin]

What is the "attribute" Data Type..? If it is not Hyperlink, change it as such..

 

[vba_php]

How can I display some attributes on subform (eg. certificat) as a hyperlink, when I click on the tab?

there are workarounds using a mixture of coloring, formatting, and vba code to do this if your query field is not a hyperlink data type in the actual table it is coming from, but that's *not* the way you should do it. what you *should* do is change the field's data type to *hyperlink* in the table that your querie(s) pull from. that way, you have to do no extra work after your query field(s) are displayed on your tabs.

 

[theDBguy]

I have a tab form that contains two sub forms, that shows the result of two different queries. How can I display some attributes on subform (eg. certificat) as a hyperlink, when I click on the tab?

Hi. If you're not using a Hyperlink field and considering on changing it, take a look at this article for some of my thoughts on that topic. Cheers!

 

[jdraw]

6 year old post guys!

 

[theDBguy]

6 year old post guys!

Darn. I fell for it again.

 

[Gasman]

Darn. I fell for it again.

Not really theDBguy, just that user is posting one liners into various old messages, presumably to increase post count.?

 

[theDBguy]

Not really theDBguy, just that user is posting one liners into various old messages, presumably to increase post count.?

Is that allowed, or should it be a cause for concern?

 

[Gasman]

Is that allowed, or should it be a cause for concern?

Well they did ask one valid question?, so not sure.