Search results

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!

pdf

Hi theDBguy! I will look into the VBA intellisense.

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

keyword search to omit the hyperlink part in the search.

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

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:

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?

Thanks

Sure. The keyword searches bring up the records.

[

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! Is there a way to parse out the hyperlink for my two keyword searches? I want the hyperlink to work but I only want "Family" to appear only if the keyword(s) of "Family" is typed and not if any part of the hyperlink associated with the "Family" field is entered. Thanks again

Thank you.

Thank you.

The ones without

I never called the tables directly, they were put in a union query and I called that union query in a form. I can use a query for the same fields but how do I add a hyperlink to a query? There's nothing in the design form that allows me to adjust the data type. I just called the new query with...