« Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Here si the code. If both, then you may have to have conditional construction of your SQL. –David-W-Fenton Jul 28 '11 at 21:34 add a comment| 2 Answers 2 active oldest votes up vote 1 What the hell does any of that stuff you were talking about mean in plain English.

Syntax Error In From Clause Union Query

Follow those instructions and let us know how you get on. Displays the result or an error or whatever. Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find Shows the result.

Phil Weber http://www.philweber.com Please post questions to the forums, where others may benefit. 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. Steve. Syntax Error In From Clause Access 2010 When I use ODBC - the same code works. –SledgehammerPL Jul 27 '11 at 12:18 What do you mean "Access Console"?

I am using following VBAsql in access module. Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search See what they do when execution is paused? why not find out more Join UsClose DevX Home Today's HeadlinesArticles ArchiveTip BankForums Register Help Remember Me?

There is an issue with my FROM clause. Syntax Error In From Clause Vb6 Bugs were found (quite validly) but trying to understand what you're trying to achieve is not so easy. To me the query statement looks fine but im sure its something really silly i have missed out. schroepView Member Profile Oct 6 2005, 01:13 PM Post#4UtterAccess VIPPosts: 5,202Joined: 21-July 05From: Denver, Colorado [USA]Frank has it right.

Syntax Error In From Clause Excel

My task is to write an event for a command button which creates a query and opens the result for the user in datasheet view. How to deal with a DM who controls us with powerful NPCs? Syntax Error In From Clause Union Query I changed the name of the table to ORDERS and from then everything worked beautifully. Syntax Error In From Clause Access 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

Also, if your BuildFilter() returns anything it will always leave the string " AND " at the end of your SQL. http://axisnice.com/syntax-error/a-syntax-error-is.php What are the diference between Access 200, 2002 and 2003? Reply With Quote January 18th, 2008,01: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 Reply With Quote Quick Navigation Visual Basic 6.0 Programming Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual C++ & C++ Programming Visual C++ Programming Syntax Error In From Clause Vba

And about your second question, I think you should start a new thread. Edited by: fkegley on Thu Oct 6 13:33:35 EDT 2005. Bugs were found (quite validly) but trying to understand what you're trying to achieve is not so easy. http://axisnice.com/syntax-error/access-2010-union-query-syntax-error-in-from-clause.php Registration on or use of this site constitutes acceptance of our Privacy Policy.

That a mere mortal like me could do? Syntax Error In From Clause In C# 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 zeee Reports 0 01-06-2005 06:52 AM Run Time Error after refreshing the form zeee Forms 0 01-06-2005 06:12 AM Run Time error - 3001 Timtropolis Modules & VBA 0 08-16-2004 04:55

Here's the code I'm using to kick this off:CODE Dim db As DatabaseDim importDate As StringDim varWhere As VariantDim QD As QueryDefDim LecoMsg As StringDim LecoTitle As StringOn Error Resume NextSet

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 Guess that means the other 1001 do. Thanks Reply With Quote 06-01-2005,05:55 PM #4 Phil Weber View Profile View Forum Posts Visit Homepage Senior Member Join Date Nov 2003 Location Portland, OR Posts 8,387 Set a breakpoint in Forgot your password?

DailyProgrammer 284: Wandering Fingers Liquids in carry on, why and how much? Expand|Select|Wrap|Line Numbers strSQL="SELECT*FROM[ProjectinfoTbl];" I tried with the square brackets: strSQL = "SELECT * FROM [Project info Tbl];" DoCmd.RunSQL strSQL DoCmd.Close acForm, Me.Name Set db = Nothing But, it gives me Reply With Quote January 18th, 2008,10:01 AM #3 dglienna View Profile View Forum Posts Visit Homepage ex MVP - Visual Basic Power Poster Join Date Jan 2006 Location Fox Lake, IL weblink Browse other questions tagged ms-access or ask your own question.

This should eliminate the WHERE clause entirely if varWhere is NULL (which it would not be if he had started with "" instead of NULL). One more thing if i want to add one more column "season" with super department than what changes should i make to above code. 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 It's quick & easy.

That's why I recommend single stepping, to see where the rest of text goes to... Where do you need this information?