Search results

Thank you Ridders and Doc Man for continuing to help me. I have done what I believe you suggested, but now when I click the Yes or No in the message box nothing happens. It just stays on my Add New Customer form. The code I used was: Private Sub Form_Unload(Cancel As Integer) On Error GoTo...

Dear Ridders The message comes up if you click yes or no. I will see if I can get the code to work with what you have said. Craig

Thank you for trying to help me. I have fixed the spelling mistake and used the before update event instead of the after update event. I think I can also use the code in the on unload event? What I have done is combine two different section of vba code to try and get the result I want. I...

My name is Craig. Please, could someone help me? I have a form and in the form an email text field. I want a message to pop up when the person tries to close the form and for there to be a Yes No option. If they choose Yes then I want the form to close if they choose No I want the form to...

Thank you minty that worked. :-) Craig

Thank you Minty. I will try your formula. :-) Craig

Thank you to those who are trying to help me.

Thank you for the reply. I want the formula to put in the name of the Customers company if there is no information in the FirstName field, the MiddleName field & the Surname field. At the moment the formula works if there is no information in the FirstName field & the Surname field. If there...

Thank you. Craig

Not sure where to ask my question? I am working on my database and have a formula that puts the company name in if there is no information in the FirstName & Surname field. My problem is that I also want it to take into account the middle name field. I messed around with the formula and tried...

My name is Craig. I build my own databases to run my small online business. I am not very advanced when it comes to coding yet, even though I have read a number of books etc.