Search results

Arnel, It works perfectly! Thank so much for your help and patience. You my friend are a Star!!!

Arnel, Thanks you so much! I think we are nearly there! or rather you are. The only problem I have now is the Serial number is contained within two textbox's.OWNER and NWQIS. OWNER is TEXT and NWQIS is NUMERICAL. Only NWQIS is showing in the new Textbox MeterSerial). How do I get the first...

Hi Guys, Thought I would attach a sample copy of my database to see if you can tell where I going wrong. Hope this helps. Thanks for your patience. Russell

Jon, I think I need more info on this, I fact I know I do. Maybe someone could talk me through it. Or just amend my code so I could just cut and paste. This is driving me crazy. I have amended the code many times and still getting nothing in the textbox.

Hi Mark, I get this error.

Hi Mark, I get this error. As per attachment.

arnelgp, Where do I add the message box?

arnelgp, This is the code now and still nothing appears:- Private Sub END_USER_NAME_AfterUpdate() Me.EMAIL_ADDRESS_ONE = END_USER_NAME.Column(1) Me.EMAIL_ADDRESS_TWO = END_USER_NAME.Column(2) Me.USER_PHONE_NUMBER = END_USER_NAME.Column(3) Dim meterSerial As String Dim dt As Variant dt =...

arnelgp, Thanks for your patience. Still cant get this to work. Don't know what I am doing wrong. I have a textbox Named Serial with a Control Source of meterSerial and nothing appears in it when I enter an END USER NAME to start a new record. Here is the code now:- Me.EMAIL_ADDRESS_ONE =...

I have a main form with a command button that opens another form for emailing via outlook. The email form has a command button "send". I need a checkbox on the main form to indicate that the email has been sent so that users don't send the same email multiple times. Please Help!

Arnelgp thanks for your reply, I have tried your code in the afterupdate event of the "END USER NAME", it compiled ok but does not appear to work. I have added a textbox named serial to the main form" calibration sheet". I also already have code in the after update. This is what I have now:-...

I have tried a query and manage to get the relevant data, but how do I get the data out of the query so that I can populate the email with the previous serial number automatically.

I have a database with a calibration form for water quality meters. Every 8 weeks a new meter is calibrated and sent to the end user. An email is auto generated to inform the end user that a new meter is on its way. The email contains the Serial No of the new meter and asks the end user to...