Search results for query: *

I try to count the quantity of participants that have 'Yes' values for a field but no participants have 'Yes' so I try to return 0 (zero) instrad of a null value. I tried to use the following Nz as described in some other posts but it doesn't seem to work for me Here's my query: SELECT...

Hi all, I have a button in a form that should send an email IF there's an email adress in the related table OR display a message box if not. I find the email adress in an other table using DLookup but I always get an invalid null use error message, can someone help me with this please ? Here is...

Hi everyone, I have a little problem when I try to set focus back to the textbox after displaying a message when you try to the next textbox without writing something in the first one. Here's my code: Private Sub ZT_Prenom_LostFocus() If Nz(ZT_Prenom.Value) = vbNullString Then...

Hi, I have a form for which I can duplicate some values and when it happens I have a messagebox that ask the user if he really wants to have a second entry with the same value and if he clicks yes I want to add the value of my 'modif' variable in a specific cell of that entry and if he clicks no...

I cannot find how to write a validation rule in my form to pop a message when the user tries to create a duplicate entry, my field is indexed with NO duplicates so at this moment access pops an error message for the duplicate entry only when I have finished to fill ALL fields of my form. Can...