UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Not In List Event    
 
   
mike60smart
post May 16 2008, 03:16 AM
Post #1

UtterAccess VIP
Posts: 8,443
From: Dunbar,Scotland
Hi Everyone

For some reason a ComboBox that has the event Not In List is returning this error:-

Runtime error 3134
Syntax Error in INSERT INTO statement

the code breaks at this point:-

CurrentDb.Execute strSQL

Has anyone come across this before?

Mike
Go to the top of the page
 
+
Larry Larsen
post May 16 2008, 03:24 AM
Post #2

UA Editor + Utterly Certified
Posts: 22,722
From: Melton Mowbray,Leicestershire (U.K)
Hi Mike
No..
We may need to see more of the code behind the combo event..!!
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
mike60smart
post May 16 2008, 04:34 AM
Post #3

UtterAccess VIP
Posts: 8,443
From: Dunbar,Scotland
Hi Larry

I have managed after a bit of digging to find a piece of code provided by Alan in the link below:-

Link

It has all boiled down to a space in the name of the table and is now resolved

Thansk for your trouble

Mike
Go to the top of the page
 
+
Larry Larsen
post May 16 2008, 05:07 AM
Post #4

UA Editor + Utterly Certified
Posts: 22,722
From: Melton Mowbray,Leicestershire (U.K)
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 10:22 PM