Recent content by ElSteveO

So it sounds like I didn't use the proper format but Access converted it for me. As long as it works I'm happy, but I will try and use the proper format in the future.

yes, I do.

Here's the current code in my database: Private Sub cmdSaveQ_Click() Dim strSQL As String strSQL = " insert into tblquotes" & _ "(tickname, tickprice, wfsize, bordername, borderht, borderprice, qdate, style, cust, tcost, fcost, qcost, kcost, qmu, notes)" & _ "values" & _...

PH, the way I wrote it works. It appends the table with the proper data. I'm not sure I understand how your suggestion is different. I'm not saying my way is better, just that it works. Regardless, I appreciate the feedback. steve

Thanks Andy. PHV - I didn't follow it. Perhaps I don't understand it. I believe you are saying the single quotes go around text, but not all my fields are text fields. Any input is appreciated. Thanks for your help. Steve

Andy, I replaced my code with your code but didn't notice anything different. Then I purposely put the comma back in the statement to induce the same error. I thought the debug.print statement would show my error in the immediate window, but, again, I didn't notice a difference. It printed my...

Andy, I appreciate your help! I will definitely try your method. All the best, Steve

I'm going to provide my own answer. I removed the comma after the first closing parenthesis and it worked. DoCmd.RunSQL " insert into tblquotes" & _ "(tickname, tickprice, wfsize, bordername, borderht, borderprice, qdate, style, cust, tcost, fcost, qcost, kcost, qmu)[highlight...

Hello, I have searched the forums and can't find an answer. I get a runtime error '3134' with the following insert statement: Private Sub cmdSaveQ_Click() DoCmd.RunSQL " insert into tblquotes" & _ "(tickname, tickprice, wfsize, bordername, borderht, borderprice, qdate, style...

That "pallete" code was in the Northwind DB. I just put a comment sign in front of that code and now I don't get that error.

Whoops, I spoke to soon. I have a line of code that says, "If Not IsNull(Me!Photo) Then Me.PaintPalette = Me!Photo.ObjectPalette" It works great for the photos that are in the Northwind DB, but when I add my photo I get a run-time error 2196 saying, "Microsoft Access can't retrieve the value...

MaxDD, I figured out what you said and it worked! Thanks again to everyone.

MaxDD, when I go to Hkey_classes_root\.bmp I see 5 different names. They are: Default Reg_sz oisbmpfile content type reg_sz image/bmp perceived type reg_sz image and two for Roxio How do I actually change the key, and which of these do I change? Thanks very much for the advice.

thanks dhookum! that makes sense. I'll try to figure out how to do so.

I'm using 2000 and am so happy. Thanks for the help.