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
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.
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
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
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.