If you know this stuff, then ignore. I do not offer free assistance by e-mail. Jun 29 '07 #1 Post Reply Share this Question 14 Replies 100+ P: 113 LacrosseB0ss Your table name can't have spaces. Good Luck--------------As a circle of light increases so does the circumference of darkness around it. - Albert Einstein RE: Run time error '3131' Syntax error in FROM clause vbajock (Programmer) 1 his comment is here
Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? Follow those instructions and let us know how you get on. And about your second question, I think you should start a new thread. Cheers // David Reply With Quote 06-11-03,07:07 #6 sains97 View Profile View Forum Posts Registered User Join Date Jun 2003 Location Southampton Posts 1 This may have come too late but
Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! You should set a breakpoint at the above line and then single step through the strSQL = strSQL & "..." statements and survey the contents of strSQL. We apologise for any inconvenience. Advanced Search Forum DevX Developer Forums Database Run-time error '3131': Syntax error in FROM clause If this is your first visit, be sure to check out the FAQ by clicking the
Browse other questions tagged sql sql-server ms-access or ask your own question. Reply With Quote January 18th, 2008,02:57 PM #5 Giftx View Profile View Forum Posts Member Join Date Jul 2007 Posts 51 Re: VB6 - Run-Time error 3131-Syntax error in FROM clause How secure is a fingerprint sensor versus a standard password? Reply With Quote 06-06-2005,06:20 PM #7 stubin View Profile View Forum Posts Registered User Join Date May 2005 Posts 4 Hi Phil I tried what you suggested and it seems to
Thanx again for your time. Execution should pause on that same line with a yellow highlight. Run-time error '3131': Syntax error in FROM clause The Debug button takes me to the code below. I don't know if this helps.
RE: Run time error '3131' Syntax error in FROM clause CajunCenturion (Programmer) 1 Dec 03 11:25 The question uscitizen, is what is the TableName, or Query, that you want to perform Lemme know if this helps Cheers, MarkK View Public Profile Find More Posts by MarkK
Reply With Quote Quick Navigation Database Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums DevX Developer Forums .NET ASP.NET VB Classic Java C++ XML Web http://mmonoplayer.com/syntax-error/syntax-error-in-insert-into-statement-access.html Where do you need this information? But I keep getting the run time error 3131. I tried the brackets, not working =/ This is my SQL statement: SELECT * FROM order WHERE order.orderno=" & Val(Text1.Text) Best wishes // David Reply With Quote 03-12-02,10:06 #4 PracticalProgram View
Thanks Reply With Quote 06-02-2005,06:23 PM #6 Phil Weber View Profile View Forum Posts Visit Homepage Senior Member Join Date Nov 2003 Location Portland, OR Posts 8,387 Table names containing spaces Click Here to join Tek-Tips and talk with other members! You only have references to records. weblink Code: Re: VB6 - Create mew table using input from two other tables Dim Db As Database Dim DbPath As String Dim DbName As String Dim strSQL As String Dim rsOutfile
What the hell does any of that stuff you were talking about mean in plain English. I am not sure how to execute the SQL interactively, sorry for being dim. There are two things you can do to acheive your results 1) Create and save a query that uses your SQL Expand|Select|Wrap|Line Numbers DoCmd.OpenQuery("qryMyQuery") DoCmd.CloseacForm,Me.Name 2) Create and save a
Does it have to do anything with the version of Access? Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 24 Why does Davy Jones not want his heart around him? Giftx.
mickey_lin_uk Modules & VBA 14 01-07-2005 12:27 AM Run Time Error 2001 - What am I doing wrong? But it is giving me the following error: "Run time error 3265 item not found in this collection". RE: Run time error '3131' Syntax error in FROM clause CajunCenturion (Programmer) 1 Dec 03 11:37 [Forms]![Protocol Medications] is not the declaration of an object, it is a reference to an check over here after concluding that it'd be best put on a back burner and re-attempted post some future training the code was never removed.
There is an issue with my FROM clause. If I'm not mistaken you've already done it. And about your second question, I think you should start a new thread. You can execute code one line at a time and watch what changes.
Correction: the database is in Access 2000 file format Jul 2 '07 #8 reply Expert 100+ P: 1,206 JKing Did you replace qryMyQuery with the name of your query? Just a small question to throw in then (LOL) Check out this link (Converting Access versions) Jul 3 '07 #13 reply P: 31 Flo100 Just a small question to throw in Close Box Join Tek-Tips Today! WTF!?!?!?
If you comment out the part where the "Select * From" keyword is put to your query, you produce another syntax error.