02-08-2007, 07:49 AM #8 stallyon Registered User Join Date: Feb 2007 Posts: 37 Thanks: 0 Thanked Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jun 10th, 2011,12:14 PM #5 revans Board Regular Join Date Apr 2010 Location California Posts 576 Re: Runtime Error
> Runtime Error
> Runtime Error 3131 In Access
Runtime Error 3131 In Access
LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode SQL looks at the statement this way: FROM - get ready for a table Project - ok, this is the table I want **standby for additional functions or where clause** Info Set a breakpoint? SQL in VBA for Access P: 31 Flo100 Hi All, I have a simple query that I want to execute in VBA in Access. navigate here
See my entire module below: Thanks. Browse more Microsoft Access / VBA Questions on Bytes Question stats viewed: 3152 replies: 14 date asked: Jun 29 '07 Follow this discussion BYTES.COM © 2016 Formerly "TheScripts.com" from 2005-2008 About In Both Database1.mdb and Database2.mdb ... . All contents Copyright 1998-2016 by MrExcel Consulting. http://www.dbforums.com/showthread.php?269235-run-time-error-3131-quot-syntax-error-in-FROM-clause-quot
Runtime Error 3131 In Access
I don't want to rename the tables. scratching my head (as any newbie would) i'd like a clue as to what's happened and hopefully the needed fix. 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 uscitizen (TechnicalUser) (OP)
I got the same problem. Thanx again for your time. which i just did and things seem to returned to 'normal'.but to all who contributed to this thread, thanks guys -- you're great! All times are GMT -5.
Get someone to read it - does it make sense or does it sound like gibberish? Syntax Error In From Clause Access Yes but a pencil must be lead or try Yes but a missile must be guided stallyon View Public Profile Find More Posts by stallyon
02-09-2007, I changed the name of the table to ORDERS and from then everything worked beautifully.
Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc.
Results 1 to 7 of 7 Thread: run-time error 3131 "syntax error in FROM clause" Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Giftx. Expand|Select|Wrap|Line Numbers strSQL="SELECT*FROM[ProjectinfoTbl];" Jun 29 '07 #3 reply P: 31 Flo100 I changed the name of the table and used it in the following 2 ways: First: strSQL = "SELECT In your code or on the screen for the operator?
Syntax Error In From Clause Access
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 Please ... ? Runtime Error 3131 In Access Can somebody help me on this. I am using Access 2002 and the databse is Access 200 file format.
Guess that means the other 1001 do. check over here What are the differences between Access 2000, 2002 and 2003? value in super department field starts with letter andnumbers for exampleSD123-COTTON. Silly me.
If I'm not mistaken you've already done it. Code: Run-time error: 3131 Syntax error in FROM clause . Andrey V Artemyev | Saint-Petersburg, Russia Edited by VanderghastModerator Tuesday, November 09, 2010 1:12 PM A double quote was apparently missing Marked as answer by Bruce Song Friday, November 12, 2010 http://arabopensource.net/runtime-error/runtime-error-2004-out-of-memory-access.html Run your code.
Then, I stepped through the whole module one line at a time, the select statements were being concatenated inside "strSQL". What are the diference between Access 200, 2002 and 2003? Edited by: fkegley on Thu Oct 6 13:33:35 EDT 2005.
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
RE: Run time error '3131' Syntax error in FROM clause uscitizen (TechnicalUser) (OP) 1 Dec 03 11:51 giveth me a question i can answer and that i shall.cajuncenturion, y'all asked:"what is I Ain't Writing These All Codes In Access ... ! Just tried it and I got. "Run-time error: 3131" "Syntax error in FROM clause" I'm using the "Microsoft DAO 3.6 Object Library" in VB6 and I'm trying to fetch data from I find this technique helps tremendously when creating sql strings in code.
The time now is 09:23 PM. Yeah, I'm Using Visual Basic 6 ... I have no idea why, but ... weblink My code was strJobPopTemp = strJobPop & " ORDER BY JobSheetID" Me.RecordSource = strJobPopTemp where strJobPop was from another module, a SELECT * FROM qryJob I had to change strJobPop to
Code: ' Check for Project Number If Me.TextProject > 0 Then varWhere = varWhere & " AND [Related to Project Number] = " & Me.TextProject & " " End If But I took a little from each of your suggestions and it is now working.Thanks again. I Copied Your Code, And Pasted It ... . Reply With Quote Jun 7th, 2011,05:09 PM #3 jasmith4 Board Regular Join Date May 2008 Posts 336 Re: Runtime Error 3131 : syntax error in FROM clause Right -- is there
Consider... what is the value of "Me.TextProject" at your breakpoint? manix View Public Profile Find More Posts by manix
Close this window and log in. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not hth, Rich Share Share this post on Digg Del.icio.us Technorati Twitter Imagine a funny saying here. Jul 3 '07 #10 reply P: 31 Flo100 There are a lot of right answers in here (I loved LB's explanation - sweet), but I'm afraid the question is unclear.
Jun 29 '07 #6 reply P: 31 Flo100 RunSQL and Execute I believe can only be used with action queries. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jun 10th, 2011,10:36 AM #4 dominofly New Member Join Date May 2010 Posts 31 Re: Runtime Error 3131 : Close Box Join Tek-Tips Today! Just one more question please.
Using the above tools you should be able to trace step-by-step each little thing your code does. Reply With Quote Aug 22nd, 2011,09:39 AM #2 Ecniv View Profile View Forum Posts Visit Homepage Don't Panic! I need the answer(result of my query) on the screen. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|--