Recent content by Banderas23

Hi, I have a car park booking system. In this system, when taking a customers booking, are two fields. Departure_Date and Return_date. There is also a third Field which is number of days. What i need is, when you select The departure and return dates, i need the Number of days field to auto...

Minty... Worked it out. Built up the strBody and then I built up my email with form controls and it's working fine with no errors.. Cheers for everyone's input I've managed to get another section of my database completed. Thanks again everyone.

Sounds good, how do I do that? I actually got some code that was in other databases and then I use it in my own and work out what needs changing in order to get mine to do what I need. How do I build up strBody and what do I put in the code to do this?

What I have done now is get rid of some of the other form controls and I get the added text but it does not add in a carriage return.

Everything up to .body="dear " & me.customername works fine. I just want to continue with text on another line and the code just fails.

As much as I hoped this would work, I got a compile syntax error.

If I use .Body ="Dear " & Me.CustomerName This brings up the customer name. When I add the following to get a carriage return and continue formatting my message body the code above fails. It's like I'm missing something code wise. As soon as I add this & vbcrlf & "This is your email...

Name of the field. I've even changed the name of the field to customer_name.

It keeps failing when it tries to add form fields in the main body text. One of my fields is customername but as soon as it looks up me.customername it fails. I know this field exists as when I type in the code it's in the list me.customername

Does the vbcrlf add a carriage return. As I'm sure untried this and it failed. I then read up on other commands such as chr(13) which also failed.. Let me try this again il see how I get on. Thanks

I have some code that creates an outlook email and populates the message to field and aubject field as I need. When it comes to the body I cannot get it to format how I need. I've tried various command I have read online and it just doesn't seem to work. Can anyone help fill out the missing...

Had a read and found a much simpler way to do this. Cheers. I am a proper noob.

Hi, Step 1. I have a database with 2 forms and 2 tables and tables have 20 fields. One of the fields is a yes/no checkbox. When clicking save record button on form 1, I want it to save a copy of all the data into table 1, and into table 2 If the yes/no checkbox is set to yes. Table 1 and 2...

Cheers amigo, I'll take a look and see if. Can get it working..