Search results

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

Hi Vlad, I have a sample of the form attached. If you select "General" from the first dropdown in the form, you should see some rows. And if you type in pdf in the survey keyword searchbox, Survey1 appears because it is attached to a pdf hyperlink. The same issue applies to the Scalename...

I tried it with the ScaleName box and it doesn't seem to work. Now I'm getting this error message with the form:

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!

Hi Vlad, Would something like InStr(HyperlinkPart([Survey],1)>0 work? The thing is, there's going to a bunch of different keywords other than "Family" in the survey field and I want my keyword search to only take in the displaytext in the survey field and parse out all the hyperlink portion...

Hi theDBguy! I will look into the VBA intellisense. As for the expressions, they look like HyperlinkPart([Survey],1) and HyperlinkPart([ScaleName],1) in my expression builder.

I have two columns in my form that use keyword searches where the keyword search also includes parts of the hyperlink. For example a single row with a text called "Family" that is hyperlinked to a pdf (i.e. Documents/FamilyDoc55.pdf) on the computer. When I type in "pdf" or any part of the...

Sorry to bring up this thread again but I mistook another issue with this one and I still can't get the HyperlinkPart Method to work. Ex: If you select "CH" from the Theme Dropdown and then type in "article" under the Survey Keyword, the hyperlink of the survey called "General Social Survey -V"...

Hello again! I'm currently trying to hyperlink to specific excel worksheet names that have spaces in them. I can get it the hyperlink working without the spaces i.e: C:\Users\Desktop\Excel.xlsx#Sheet1!A1. But if there's a space between Sheet and 1, i.e: Sheet 1, I can not longer get the...

Hooray! I'm going to try to recreate it myself tomorrow. Thanks so much again for your help, it is much appreciated! N

Sure. If you select "CH" from the first dropdown in form you will see two hyperlinked columns. I'm able to export those columns in an excel file but the hyperlinks remain; which I want to remove. I erased the expression in the screenshot I made above because it was causing me problems. Thank you.

I typed it in myself. I also tried this expression in a query: SELECT tblTheme.Survey, HyperlinkPart([Survey],1) AS Expr1 FROM tblTheme; It works but I need to find a way to incorporate it into my form. Thanks again.

I added the expression in the control source of the form but I get an error "#NAME" message in the text box of the form that I inserted the expression in. Am I using the expression builder correctly?

So where do I add that code? Is it another function by itself? I tried adding it to my search private sub but I got a debugging error. Thanks

Sure. The keyword searches bring up the records that have the hyperlinks. Please use the first dropdown and select "CH" to see some examples. Thank you.

Private Sub ScaleText_Change() Dim myScale As String myScale = Nz(ScaleText.Text, "") Call myFilter("[ScaleName]", "ScaleText", myScale) currentrsrc = Me.tblTheme_Query_subform.Form.RecordSource End Sub Private Sub surveyText_Change() Dim mySurvey As String mySurvey =...

My search is performing on the right columns (with hyperlinks), but the keyword search is taking in the hyperlink address also but I don't want it to.

Hello again! Unfortunately, I have more hyperlink issues with my form... I have two records that use keyword searches to lookup certain names. However, I recently realized that the keyword search also includes parts of the hyperlink. For example: A single field with a text called "Family"...

This is wonderful. Thank you so much.

tblTheme2 is the table without any hyperlinks. If you use the main search form "Form Search box" and search either "PH" or "CH" theme, you will see the hyperlinks for "Scale" and "Survey". If you export those files via the "Export" button on the form. The output should have the path or...