Recent content by NikkiK1234

  1. N

    Solved Button to reset/refresh form

    This is excellent. Thanks again for your help theDBguy! Much appreciated!
  2. N

    Solved Button to reset/refresh form

    Was done by design. The main user is able to edit the data but the other users can return data but not edit.
  3. N

    Solved Button to reset/refresh form

    Through my searchboxes and dropdowns (use VBA), they work in tandem to filter through my data. Unless I was confused by Isaac's comments, I thought he was referring to a form property for the filter, but I do not recall altering any form properties for the filter.
  4. N

    Solved Button to reset/refresh form

    The data returned (recordset) is not editable.
  5. N

    Solved Button to reset/refresh form

    I don't recall using the filter property of the form.
  6. N

    Solved Button to reset/refresh form

    Hello again! I've made a button that is supposed to clear all the search filters and reset the output. I'm able to clear all the search filters but I'm unsure how to clear the output. This is the code I have so far for the button: Private Sub Command54_Click() Me.Field1.Value = ""...
  7. 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!
  8. 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...
  9. 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:
  10. 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!
  11. 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...
  12. 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.
  13. 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...
  14. 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"...
  15. 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...
Top Bottom