Method (1 Viewer)

N1234

Member
Local time
Today, 09:51
Joined
Jun 22, 2020
Messages
64
I have two columns in my form that use keyword searches where the keyword search also includes parts of the hyperlink.

but when trying to use those expressions in the expressions builder, I only get errors that prevent my form from working. Does someone have experience with the expression and the expression builder?

Thanks again,

N
 
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Today, 06:51
Joined
Oct 29, 2018
Messages
21,357
Hi Nikki. I rarely use the expression builder, because I think VBA intellisense is more helpful, in my humble opinion. What does your expression look like?
 

bastanu

AWF VIP
Local time
Today, 06:51
Joined
Apr 13, 2010
Messages
1,401
Hi Nikki,

I think you can use InStr() in your expression builder:

InStr(HyperlinkPart([Survey],1),"Family")>0 and put True in the criteria row below.

Cheers,
Vlad
 

N1234

Member
Local time
Today, 09:51
Joined
Jun 22, 2020
Messages
64
Hi Nikki. I rarely use the expression builder, because I think VBA intellisense is more helpful, in my humble opinion. What does your expression look like?
Hi theDBguy!

I will look into the VBA intellisense.
 
Last edited:

N1234

Member
Local time
Today, 09:51
Joined
Jun 22, 2020
Messages
64
Hi Nikki,

I think you can use InStr() in your expression builder:

InStr(HyperlinkPart([Survey],1),"Family")>0 and put True in the criteria row below.

Cheers,
Vlad

pdf
 
Last edited:

bastanu

AWF VIP
Local time
Today, 06:51
Joined
Apr 13, 2010
Messages
1,401
Hi Nikki,
Yes, you can have many keywords, you would use it like this:
InStr(HyperlinkPart([Survey],1),[YourTextboxSearchControl])>0 =True meaning whatever you typed in the search box is present in the disply text of the hyperlink field.

Cheers,
 

N1234

Member
Local time
Today, 09:51
Joined
Jun 22, 2020
Messages
64
Hi Nikki,
Yes, you can have many keywords, you would use it like this:
InStr(HyperlinkPart([Survey],1),[YourTextboxSearchControl])>0 =True meaning whatever you typed in the search box is present in the disply text of the hyperlink field.

Cheers,

Hi Vlad,

Is this how it is supposed to look like in the expression builder?


I could be doing something wrong because I'm getting a runtime error "run time error 2447".

Thanks!
 
Last edited:

bastanu

AWF VIP
Local time
Today, 06:51
Joined
Apr 13, 2010
Messages
1,401
You need to replace [YourTextboxSearchControl] with your own search box name on your form. And you put True in the Criteria row in your query design after you exit the expression builder.
 

bastanu

AWF VIP
Local time
Today, 06:51
Joined
Apr 13, 2010
Messages
1,401
Like this
Hyper.PNG
 

N1234

Member
Local time
Today, 09:51
Joined
Jun 22, 2020
Messages
64
Now I'm getting this error message with the form:
 
Last edited:

bastanu

AWF VIP
Local time
Today, 06:51
Joined
Apr 13, 2010
Messages
1,401
Nikki,
It should probably look like this:
InStr(HyperlinkPart([Survey],1),Forms![Form SearchBox]![ScaleText])>0
Maybe you can try to upload a small sample with your form (and table, no sensitive data please) so we could see what you have.
Cheers,
Vlad
 

N1234

Member
Local time
Today, 09:51
Joined
Jun 22, 2020
Messages
64
Nikki,
It should probably look like this:
InStr(HyperlinkPart([Survey],1),Forms![Form SearchBox]![ScaleText])>0
Maybe you can try to upload a small sample with your form (and table, no sensitive data please) so we could see what you have.
Cheers,
Vlad


Thanks for your help.
 
Last edited:

bastanu

AWF VIP
Local time
Today, 06:51
Joined
Apr 13, 2010
Messages
1,401
Here you are Nikki, please have a look at the updated file. The original expression was intended to be used in the query that is the record source of the form, but I saw you had some code to set that dynamically so I edited that to incorporate the "hyperlink" option.

Cheers,
Vlad
 

Attachments

  • Sample1_Vlad.zip
    324.1 KB · Views: 232

theDBguy

I’m here to help
Staff member
Local time
Today, 06:51
Joined
Oct 29, 2018
Messages
21,357
Hi. Just posting what I tried, as another reference. Cheers!

Hope it helps too...
 

Attachments

  • Sample1.zip
    321.1 KB · Views: 245

N1234

Member
Local time
Today, 09:51
Joined
Jun 22, 2020
Messages
64
Here you are Nikki, please have a look at the updated file. The original expression was intended to be used in the query that is the record source of the form, but I saw you had some code to set that dynamically so I edited that to incorporate the "hyperlink" option.

Cheers,
Vlad
Hi. Just posting what I tried, as another reference. Cheers!

Hope it helps too...

This is great! Thanks so much for your help; both of you. I will try to recreate this on Monday!

Hooray!
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:51
Joined
Oct 29, 2018
Messages
21,357
This is great! Thanks so much for your help; both of you. I will try to recreate this on Monday!

Hooray!
You're welcome. We're happy to help. Have a nice weekend.
 

Users who are viewing this thread

Top Bottom