Search results

I have the same issue. What If it's a ZLS? Found this thread in the search, saves me starting a new topic. ;) So, how would you convert a zls to 0? Scenario: I have 2 IIf expressions. They both state that when true return "" when false return the value required. I have another expression to...

Have the user select/enter the value correct value and not be allowed to continue until the fields match. The Validation Text states that "When using Item 1, Item 2 must used as well."

Afternoon All, I've been having problems getting a field in a form to check the value in another field (in the same form) based my Validation Rule. Example: When the user enters "Item 1" into Field1 it checks to see if the value "Item 2" is entered into Field2, because if Field1 has "Item 1"...

Tried all the tricks. Well my backup is a couple days back... :( I guess it could be worse.:cool:

:) Of course this has never happened before... I've always been able to compact and back it up when it gets corrupted. So...um....What about those tricks :)

Got it to go! Thanks. But now it's corrupted. :eek: Won't let me compact and repair... Am I about to learn a hard lesson in the world of Access. :(

Hey there, I've been trying various types of syntax to get this to work to no avail. I need to check if a field is Null (used IsNull) and check if another field Null as well before having the IIf function return a true and false value. I've tried this...

RG, Thanks so much. Got it working. Much Appreciated.:)

But it searches all the records in the table, correct?

Thanks RG. Fixed the syntax, but now it doesn't return anything. Will this function only work on new form records? Or should change all the existing records?

Hi All, I would like have a control in a form return a value when 3 fields in the form match 3 different fields in a table. The value a want returned is the 4th field in the same record as the 3 matching criteria from the form. I've tried a long dlookup expression with no luck. It always...