 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Cannot append to table
I have: INSERT INTO Temp_Tbl Br, ONo, SCode, TR SELECT Or.Br, Or.ONo, Or.SCode, Or.TR From OL WHERE OL.Br = """ & Br & """ AND OL.ONo = " & ONo The only other way which is much slower is: set rstfrom = recordset set rstto = recordset while not eof wend Thanks, J Jason Not sure I have enough information. What happens when you try these? Do you get error messages? If so, what do they say? More specific descriptions may lead to more specific suggestions. Regards Jeff Boyce Microsoft Office/Access MVP >I have: INSERT INTO Temp_Tbl Br, ONo, SCode, TR SELECT Or.Br, Or.ONo, > Or.SCode, Or.TR From OL WHERE OL.Br = """ & Br & """ AND OL.ONo = " & ONo [quoted text clipped - 7 lines] > Thanks, > J I haven't tried the rst - all the others I have used work - doing an append this way would be slower? It's the currentdb.execute command (sorry left that bit out and the error): Run-time error '3134': Syntax error in INSERT INTO statement. > Jason > [quoted text clipped - 21 lines] > > Thanks, > > J Turns out I deleted all the () - Access adds them unneccassarily - but in this instance the brackets are required around the target field names. > Jason > [quoted text clipped - 21 lines] > > Thanks, > > J |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.