Home > Syntax Error > Runtime Error 3131 In Access

Runtime Error 3131 In Access


Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Square brackets are used in sql to handle spaces in field and table names. Just one more question please. I am pretty stuck with this now, I don't really understand what's going wrong! Source

Registration on or use of this site constitutes acceptance of our Privacy Policy. You may have to register before you can post: click the register link above to proceed. Secret salts; why do they slow down attacker more than they do me? after concluding that it'd be best put on a back burner and re-attempted post some future training the code was never removed.

Runtime Error 3131 In Access

To start viewing messages, select the forum that you want to visit from the selection below. I get a run-time error 3131 "syntax error in FROM clause". I don't know if this helps. On your toolbar see the little blue arrows and lines?

Locals Window? Throw an error. Where do you need this information? With code paused, goto Menu->View->Locals shows a window where you can view all variables values in the module in which code is running.

Step into, step over, step out? But I keep getting the run time error 3131. Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Modules Jul 2 '07 #7 reply P: 31 Flo100 I tried it too.

Is there an easier way to create a Search form? I mean now 2 columns(super dept & season)from both the table should be compared and than matching rows should be deleted from main table Sunday, November 07, 2010 1:07 AM Reply If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Reply With Quote 06-01-2005,06:53 PM #3 stubin View Profile View Forum Posts Registered User Join Date May 2005 Posts 4 Hi Phil Thanks for your reply.

Syntax Error In From Clause Access

I am using the following code: Code: Private Sub btnSearch_Click() ' Update the record source Me.frmsubToolData.Form.RecordSource = "SELECT * FROM qryTooldata2 " & BuildFilter ' Requery the subform Me.frmsubToolData.Requery End Sub This makes a world of difference to the question. Runtime Error 3131 In Access Schengen visa to Norway to visit my wife refused Rebus: Guess this movie Understanding the grammar: «illis Evangelii nuntiandi praebens mandatum» more hot questions question feed lang-sql about us tour help Want to evaluate an expression with code paused?

When I hovered the mouse over the SQL string variable, it shows this line of code: Code: strSQL = "Insert Into TblProgrammersHours (ProjectID,ProgrammerInitials, CurrProgHrs, PrevProgHrs, TotalProgHrs, Positions) Select * From (" this contact form My project was coming along really well until this point and my Database is pretty rubbish if I can't query the data using a search form, because I may want to Using the above tools you should be able to trace step-by-step each little thing your code does. Steve.

RE: Run time error '3131' Syntax error in FROM clause CajunCenturion (Programmer) 1 Dec 03 10:49 You might try removing the Form field references outside of the literal quotesstrSQL = "SELECT I amcalling this routine by creating a button in Excel and when i click that button first msgbox asking "whether you want to import all files or 1 file at a It's quick & easy. have a peek here I can't find it.

One more thing if i want to add one more column "season" with super department than what changes should i make to above code. Bugs were found (quite validly) but trying to understand what you're trying to achieve is not so easy. Code: Private Sub btnSearch_Click() ' Update the record source Me.frmsubToolData.Form.RecordSource = _ "SELECT * FROM qryTooldata2 WHERE True " & BuildFilter ' Requery the subform (this may occur automatically on r-source

Your SQL (after fixes) is a SELECT query, which means it will provide information.

I don't want to rename the tables. 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 The code works fine i just want to ulodad msgbox when they are aswered and unolad file diaolg box also and unload small access screen Edited by zaveri cc Tuesday, November You only have references to records.

Reply With Quote January 18th, 2008,11:06 AM #4 WoF View Profile View Forum Posts Elite Member Join Date Jul 2006 Location Germany Posts 3,725 Re: VB6 - Run-Time error 3131-Syntax error Thanks. manix View Public Profile Find More Posts by manix

02-06-2007, 06:21 AM #4 MarkK Super Moderator Join Date: Mar 2004 Location: Vancouver BC Posts: Check This Out By joining you are opting in to receive e-mail.

What are the differences between Access 2000, 2002 and 2003? can we unload msgbox when it is answered and how to uload this access screen? Does it have to do anything with the version of Access? Phil Weber http://www.philweber.com Please post questions to the forums, where others may benefit.