Search results

Any examples you could provide?

How can I create an expression in a query that brings back only after the last \? Also, if the field has no value then return a blank or null. \6002.pdf (should look like this) \\SERVER\Plus\Spec\Results\ABC\ABC\Results\6002.pdf Thanks.

Thanks for all the advice on this.

It did not erase the data, it makes it just text and not a hyperlink.

I have a query with a hyperlink field. I want to force lower case but when I do, it removes the hyperlink? What am I doing wrong? History Link: LCase([Mlink3])

Thanks!

Not equal, needs to be contains the word "Apple"

Using conditional formatting, how would the code look if I wanted to find any records in [field1] with the word "Apple" in it. Thanks.

Thank You!

That worked! Thanks!

I'm pulling one record only.

I have a report (onload) that has four fields which are all NOT visible. I would like to make each field visible if the condition is met. If IsNotNull([Mresults1]) And IsNull([Mresults2]) Then [Mresults1].Visible = True If IsNotNull([Mresults2]) And IsNull([Mresults3]) Then [Mresults2].Visible...

Correct.

Any way to make it a hyperlink too?

Works Great! One question though... The field [Link] is a hyperlink but when I use this code, it does not keep any hyperlink.

Can you show me how that code would look in the query?

I have a field called [Link] and the data looks like this... \customers\tomsmith\pdf\1234.pdf In a query, how can I create a field that removes everything up to the pdf? \customers\tomsmith\pdf Thanks

Perfect!!!

I recently renewed my SSL certificate on my NAS. My customers use it to map a network drive and access a database file on the mapped drive. Since the renew of the certificate, I'm getting this alert and can't seem to get rid of it in order to use macros. Any ideas what changed or how to remove...

I would rather use VBA instead.