Search results

  1. N

    Solved FollowHyperlink method + Control Source within keyword searchbox

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

    Solved FollowHyperlink method + Control Source within keyword searchbox

    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...
  3. N

    Solved FollowHyperlink method + Control Source within keyword searchbox

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

    Solved FollowHyperlink method + Control Source within keyword searchbox

    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!
  5. N

    Solved FollowHyperlink method + Control Source within keyword searchbox

    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...
  6. N

    Solved FollowHyperlink method + Control Source within keyword searchbox

    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.
  7. N

    Solved FollowHyperlink method + Control Source within keyword searchbox

    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...
  8. N

    Keyword search is taking in the hyperlink

    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"...
  9. N

    Solved Hyperlink to excel worksheet names with spaces

    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...
  10. N

    Keyword search is taking in the hyperlink

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

    Keyword search is taking in the hyperlink

    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.
  12. N

    Keyword search is taking in the hyperlink

    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.
  13. N

    Keyword search is taking in the hyperlink

    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?
  14. N

    Keyword search is taking in the hyperlink

    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
  15. N

    Keyword search is taking in the hyperlink

    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.
  16. N

    Keyword search is taking in the hyperlink

    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 =...
  17. N

    Keyword search is taking in the hyperlink

    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.
  18. N

    Keyword search is taking in the hyperlink

    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"...
  19. N

    Solved Hyperlink remains in exported excel file from a form; wish to remove.

    This is wonderful. Thank you so much.
  20. N

    Solved Hyperlink remains in exported excel file from a form; wish to remove.

    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...
Top Bottom