Recent content by edge70

Works also,thanks PH ! Syl

Works fine ! Many thanks!! Syl

This is my problem, I try to count the 'yes' values of a boolean field named J1_PetitDejeuner in my table named Table_Inscriptions. When there is at least one 'yes' value I don't have any problem the count works fine and returns my the good values but as soon as no record are found I end up with...

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...

Problem solved. The problem was in the test field of my table :-( Thanks again for your help, it's greatly appreciated. Regards Syl

I tried Orna's tip but for some reason I ended with an invalid operator error so I tried PH's one and this part works just fine now. I still have a little glitch: the email address I retreive has changed, it now displays "syl@hotmail.com#mailto:syl@hotmail" instead of the regular email adress...

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...

Thanks PHV, works just fine now. Thanks again ! :)

Thanks Aceman, I tried it but I end up with the same results as with my code; if I enter something in the textbox then delete it and try to go on the next textbox using Tab, it works perfectly but if I don't enter nothing and go over the textbox using Tab then it doesn't work, the focus is going...

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...

[thumbsup2] Good, that's what I was looking for, I'm working on it. Many thanks !

The textbox that I tell you is the last of the five fields of this record and actually I use a combobox with the 'New' and 'Modification' values to set the value on my 'ShapeType' field in my 'ShapeList' table. I wish I could do this without using my combobox because the valus to assign is...

Your right, I wasn't using the right terms. Before I add a new record, in my textbox where I enter my data I made a 'before update'event for which a msgbox appears and for yes I want to put the value of my 'modif' variable which is always 'Modification' and for no I want to return to the textbox...

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...