Search results for query: *

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.

When I enter a photo into a form (using Access 2000) by right clicking on the photo object>insert object, I get a thumbnail photo that contains the photo's name. Why doesn't it take up the whole photo object? And why is the photo's name there too? I tried this on the Northwind Database and...

I appreciate everyone's help! I'm going to install my old Access 2000. I'm sure 2007 has its advantages, but to me it looks completely alien.

I feel very uncomfortable w/Access 2007. I have Office 2007 installed, but want to use Access 2000. Can I have Access 2000 run on the same computer that has Office 2007 running? Must I remove Access 2007 first? I appreciate any help. Steve

Greg, Any way to send me a copy of your database so I can see how it's structured? If not, don't worry. Thanks

Great advice. Thanks dhookom! I appreciate your input and that of les. Steve