Search results

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)

No, these are master customers using the same ID numbers several times. So, it will only be a few with unique backgrounds.

No, we have many customers, only 8 or so have a unique background image on their report. Otherwise, it will use our standard background image.

Got it. No, Mdid is not part of the image name. Mdid is an ID of customers that would have a unique image. Probably about 8 different possibilies otherwise the default image. So, if you could show me an example using three different Mdid values. Thanks.

Yes, that worked. How can I add multiple IF's? If "DEF123" = another image path, etc... Also, if it does not meet any of them, then some default path. Thanks!!!