Search results

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

Need this to be a one date search criteria. But I'll take a look at that later and see if that's best way to build.

Want to follow this as I think I may need to do this at some point.

Hi I have a data as that gets two sets of records. Ones that come in from a web page and ones we manually enter. The ones we manually enter currently do not send a customer confirmation via email although it's not every record entered I need a confirmation. What's best way to do this? And...

I have a database that holds information on departure dates. And on these dates I print off a designed report that I want to auto fill the rest of the information. What I need to do is when I open my report I want it to ask for departure date which I enter then it will. Ron up only the records...

Excellent, now I don't have to lock down individual elements. Simple save function and hey presto. Thanks for the info amigo.