VBA, VBA - RunSQL Command

VBA - RunSQL Command

Author	Message
Jay Bukstei #1 / 3	VBA - RunSQL Command I have code that does a DoCMD.RunSQL( insert....) My problem is that the table records never get inserted in, but the auto ID field increments by the number of records I'm trying to insert. I've also tried dim dbs as database set dbs = currentdb dbs.execute ( insert.....) Any ideas?
Mon, 10 Jan 2005 05:05:56 GMT

<SteveT> #2 / 3	VBA - RunSQL Command Make sure and add the optional dbFailOnError or you will not get any failure notification. dbs.execute "insert.....", dbFailOnError Probably need to paste the sql into the query grid to see your error... Dim strSql As String strSql = "insert....." Debug.Print strSql Stop 'now copy and paste the code from the immediate window into a new query (View/Sql) Steve Quote: > I have code that does a DoCMD.RunSQL( insert....) My > problem is that the table records never get inserted in, > but the auto ID field increments by the number of records > I'm trying to insert. I've also tried > dim dbs as database > set dbs = currentdb > dbs.execute ( insert.....) > Any ideas?
Mon, 10 Jan 2005 05:20:01 GMT

Graham Manden #3 / 3	VBA - RunSQL Command Hi Jay Try: dbs.Execute "Insert .... ", dbFailOnError This will give you a trappable error signifying the reason for the failure. -- Good Luck! Graham Mandeno [Access MVP] Auckland, New Zealand Return mail address is invalid in a vain attempt to reduce spam. Please post new questions or followups to newsgroup. Quote: > I have code that does a DoCMD.RunSQL( insert....) My > problem is that the table records never get inserted in, > but the auto ID field increments by the number of records > I'm trying to insert. I've also tried > dim dbs as database > set dbs = currentdb > dbs.execute ( insert.....) > Any ideas?
Mon, 10 Jan 2005 05:20:07 GMT

Page 1 of 1

[ 3 post ]