Search results

this seems to keep the format. In a query. How can I convert that to vba for a command button? Expr: Replace([Mlink1],"normal","custom")

Sorry... yes, I was simply replacing "normal" with "custom" \\server\testing\normal\12345.pdf file:///\\server\testing\custom\.pdf (after replace)

I'm working with a hyperlink field. I know they can be tricky. I'm trying to do a find and replace but it changes the format? In the past, I had to export to excel but wondering if a better way exists. \\server\testing\custom\12345.pdf file:///\\server\testing\custom\.pdf (after replace)

Thanks

I think I got it... How can I change it to 1 or 2, instead of Yes or No? Select Case MsgBox("Sample ID", vbYesNo, "testing") Case Is = vbYes [Field1] = [sampleid] & ".RPT" Case Is = vbNo [Field1] = [sampleid1] & ".RPT" End Select

Dim MyAnswer As String MyAnswer = InputBox("Enter Sample ID") Me.field1.Value = MyAnswer & ".RPT" This works. But instead of the user having to input the value, is it possible to have them choose the value from [field3] or [field4]?

If IsNull([sampleid2]) Then [field1] = [sampleid1] & ".RPT" Else [field1] = [sampleid1] & ".RPT" or [sampleid2] & ".RPT" I have a command button that checks for the this. How can I have "the Else" prompt the user to select either [sampleid1] or [sampleid2]

I'm using (below) So, I only have one record at a time. So, really nothing to group. strWhere = "[Mrecordid]=" & Me!Mrecordid DoCmd.OpenReport strDocName, acViewReport, , strWhere

What would I put in the recordsource or filter?

I have a report that normally has two pages to it. Is there any way to not have the second page based on if [results] = "fail" Rather than having to creating a separate report. Thanks

Thanks

How do I add these two together in on line? If ([standard] <> "apple") And ([frequency] = "annual") Then strDocName = "report1" msgbox "all good"

Perfect

Thanks. I really appreciate all your help.

Perfect, that worked. I was missing a quote. If I wanted to use an "or" how would that look? =IIf([Mdid]="1234" or "abc","\\Reportbackgrounds\1report.png" I tried this but does not work...

This works just fine but how do handle the default image if it does not meet one of those. I know it's where Null is. The default would be "\\Reportbackgrounds\3report.png" I must be missing something. Can you show me how that would look? =IIf([Mdid] =...

got it.

custom function?

Will try them all. Much appreciated!!

So, using your example, I can't combine them into one statement? =IIf([Mdid] = "ABC123", "\\Reportbackgrounds\ABCreport1.png", Null) =IIf([Mdid] = "DEF123", "\\Reportbackgrounds\ABCreport2.png", Null) =IIf([Mdid] = "GHI123", "\\Reportbackgrounds\ABCreport3.png", Null)