Search results

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.

How does that address the back color?

Sorry, onload of a report.

What is the best way to say this... I want the back color of a field if not null to be yellow, otherwise the back color will be white. The field name is [memo] Thanks!

Yes, it will be different.