Hyperlink on subforms. (1 Viewer)

D

Danden

Registered User.

Local time

Yesterday, 19:15

Joined

Jun 10, 2013

Messages

26

• Jun 26, 2013

• #1

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

Super Moderator

Local time

Today, 03:15

Joined

Nov 30, 2011

Messages

8,494

• Jun 26, 2013

• #2

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

 

vba_php

Forum Troll

Local time

Yesterday, 21:15

Joined

Oct 6, 2019

Messages

2,880

• Dec 31, 2019

• #3

Danden said:

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

Click to expand...

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’m here to help

Staff member

Local time

Yesterday, 19:15

Joined

Oct 29, 2018

Messages

21,467

• Dec 31, 2019

• #4

Danden said:

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?

Click to expand...

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

Super Moderator

Staff member

Local time

Yesterday, 22:15

Joined

Jan 23, 2006

Messages

15,378

• Dec 31, 2019

• #5

6 year old post guys!

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 19:15

Joined

Oct 29, 2018

Messages

21,467

• Dec 31, 2019

• #6

jdraw said:

6 year old post guys!

Click to expand...

Darn. I fell for it again.

 

Gasman

Enthusiastic Amateur

Local time

Today, 03:15

Joined

Sep 21, 2011

Messages

14,265

• Dec 31, 2019

• #7

theDBguy said:

Darn. I fell for it again.

Click to expand...

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

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 19:15

Joined

Oct 29, 2018

Messages

21,467

• Dec 31, 2019

• #8

Gasman said:

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

Click to expand...

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

 

Gasman

Enthusiastic Amateur

Local time

Today, 03:15

Joined

Sep 21, 2011

Messages

14,265

• Dec 31, 2019

• #9

theDBguy said:

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

Click to expand...

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