Recent content by inademam

This is what I have, Dim strResp As String strResp = IIf(DCount("*", "Inactive_tbl_ImportMaster", "[Pernr]= " & Forms!frmswitchboard!subfrm!txtPernr.Value) > 0, "Message 1 here.", "Message 2 here.") MsgBox strResp and its still giving me a syntax error. I don't get it. Everything is right, I...

I have a form with one field on it. I want to be able to look up a value on this form and based on whether it is in the table or not give a message box saying yes it is there, or no it is not and then reset the form to look up another value. Can anyone help with that? Thanks,

I have what should be as easy query but for whatever reason it is making me crazy. I basically need to combine 3 different queries where the last column is one in the same with the different variables of the three queries. My 3 queries are: 62Billable: IIf([StaffFac]="62" And...