Search results

Well, I was getting an error but I just got it to work. I had the column missing and now I'm going to try and get the body to auto populate. thank you.

what I tried was this initially was this Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Set olApp = Outlook.Application Set objMail = olApp.CreateItem(olMailItem) With objMail .Subject = .To = Me.Combo10 .Body = .Display...

Hello everyone, I have a button on my form that will open up outlook and get an email ready to send, but I want it to auto the information that was selected on the form. Essentially it is used as a notification. Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Set olApp...

I have uploaded my db.

Thank you. I get it now. it's because it's a string made of strings. So I took this information and added it to another form for completion but it clears the date assigned. I know databases only do what we tell them to do so I changed the code a little bit. strSQL = "Update...

Okay, your right, it is double quotes sorry, I got excited that it worked but now I want to know why. I see that you have highlighted different sets of double quotes can you break down the syntax for me? I just want to understand.

First off thank you. That fixed it; but why did you concatenate the date and put it inside quotes? I saw that the pound sign had to be there for the date format but I don't know why the other two had to be inside there.

Well, that is why I am here to learn from you guys. I understood it as linking the lines of code. I am now searching google for MS Access line concatenation.

So I was reading one of the guides that you guys lead me to, the ampersand links the lines of code together so that in access it reads it as one line. the following code is what I have come up with. And I have attached my table in design view. strSQL = "Update Fleet_Advisory_Messages" & _...

So this is a zipped screenshot of my form.

So I found out that if the value is text in my table, then I need to have it in a pair of quotes or double quotes and the date needs to go inside a pair of #. What does the & do though?

I noticed that. I don't have the bandwidth right now. sorry.

I have attached a screen shot of my form. it's pretty simple. 2 Combo Boxes, The first one has the text boxes auto fill with the information about the message, the next combo box is where you select the person I'm going to assign it to and the last text box is for the current date. Then the...

it was the beginning & that was highlighted.

ok. standby. The other thing that just happened was I realized I still had the Now () in there and changed it to Date() and and the following error popped up. "Compile Error: Expected Line number or Label or Statement or end of statement" and it has the & highlighted in the beginning of the...

Still giving me the compile syntax error. I'm reading through those guides that you guys gave me.

& " [Date Assigned] = #" & Now() & "#" " Compile Error: Syntax Error. Any more ideas?

Thank you. Is there a guide or anything on using SQL in VBA?

So I got this to work actually but then I messed around with the code a little bit to try and update the date. From a couple examples, All I had to do was throw the next column and value in under the & " Set Status = 'Assigned'" _ So here is what I have currently strSQL = "Update...

So to get it to work I took out the line Currentdb.Execute strSQL, dbFailOnError I inserted it back in and I got the error "Syntax Error (missing operator) in Query Expression [Message Number] = Me.Combo14"