Method

[N1234]

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

 

[theDBguy]

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]

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]

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.

 

[N1234]

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

 

[bastanu]

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]

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!

 

[bastanu]

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]

Like this

 

[N1234]

Now I'm getting this error message with the form:

 

[bastanu]

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]

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.

 

[bastanu]

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

 

[theDBguy]

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

Hope it helps too...

 

[N1234]

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]

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.