Replies

Dear Francois,

Happy New Year and my best wishes to you.

I use sucessfully your suggestion to avoid the Null values in my code.It works excellent but it gives me an error if the user
inadverently sets the FirstName into commas.For example if the first name is Joe then it is OK but if it is “Joe”
then i get a message that i have a syntax error.
May i somehow tell the user to delete the commas ? These commas are a nuisance to me and it will be a good opportunity to make the user avoid them.

regards

Dear Francois,

Happy New Year and my best wishes to you.

I use sucessfully your suggestion to avoid the Null values in my code.It works excellent but it gives me an error if the user
inadverently sets the FirstName into commas.For example if the first name is Joe then it is OK but if it is “Joe”
then i get a message that i have a syntax error.
May i somehow tell the user to delete the commas ? These commas are a nuisance to me and it will be a good opportunity to make the user avoid them.

regards

I have a small additional question.The point is that the telephone numbers might not be
known and should not be considered as obligatory.In that case,it would be better
to execute the code, and ask for the number.I have tried the folloiwng:
If IsNull(f!phone) Then
On Error Resume Next
End If

but it didnt work, the row remains empty.
Is it possible at all ?If not i must remove the phone numbers

I have a small additional question.The point is that the telephone numbers might not be
known and should not be considered as obligatory.In that case,it would be better
to execute the code, and ask for the number.I have tried the folloiwng:
If IsNull(f!phone) Then
On Error Resume Next
End If

but it didnt work, the row remains empty.
Is it possible at all ?If not i must remove the phone numbers

Bulletproof.I have now a bulletproof application.Thank you to all of you, Hans and Francois.
I wish you a merry Christmas and happy New Year.

Bulletproof.I have now a bulletproof application.Thank you to all of you, Hans and Francois.
I wish you a merry Christmas and happy New Year.

Thank you very much for your reply.Your code works and i am very happy about that,and the new field in the table is populated,
however only in case that all the fields in the form are filled.So for example, if the
SecondName is missing, then the row is blank, and i have no new record.Is it possible to make
the code more flexible and to paste only those records that exist ?

Regards

Thank you very much for your reply.Your code works and i am very happy about that,and the new field in the table is populated,
however only in case that all the fields in the form are filled.So for example, if the
SecondName is missing, then the row is blank, and i have no new record.Is it possible to make
the code more flexible and to paste only those records that exist ?

Regards

Here is the stripped copy of the database i failed to send

Here is the stripped copy of the database i failed to send

I am sorry i cannot do it. Even though i copied your text. I feel ashamed,i really cannot do it.
I understand that you are not obliged to teach me, just to show a solution
to the forum, but i really am at the end of my powers and i cannot finish
what you have advised me.Please show me where i am wrong,i am sending an attachment

Thank you

I am sorry i cannot do it. Even though i copied your text. I feel ashamed,i really cannot do it.
I understand that you are not obliged to teach me, just to show a solution
to the forum, but i really am at the end of my powers and i cannot finish
what you have advised me.Please show me where i am wrong,i am sending an attachment

Thank you

Thank you . I will work on that and it is clear to me now

Thank you . I will work on that and it is clear to me now

thank you for your reply.I have a module called MdUpdate. This module contains 5 functions. The first function is called FncTown.The second is called
FncBenches. In each function i have to set one and the same variables. Instead of setting them for each function, is it possible to set the variables only once,
before the functions, so that instead of writing them 5 times, to write them only once

regards