Re: Syntax error in FROM clause

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 19:41:37 -0400

It appears that the maximum length of the SQL statement has been reached.
The statement that you've posted is not complete, and "ends" in the middle
of the FROM clause. So yes I would assume that that is the source of the
problem.

You'll need to create a query that selects the correct fields and records,
save and store it, and then use that query as the recordsource for the form. 

-- 
        Ken Snell
<MS ACCESS MVP>
"George wilson" <anonymous@discussions.microsoft.com> wrote in message
news:30a401c48ed8$e17d9380$a301280a@phx.gbl...
> I click on the ... box and get the error Syntax error in
> FROM clause. The listed information copied from the box
> is: SELECT [Contact Information].[Site Name], [Contact
> Information].[Location], [Contact Information].[Well ID or
> Name], [Contact Information].[Date], [Contact Information].
> [Point of Contact], [Contact Information].[Address],
> [Contact Information].[Fax], [Contact Information].
> [Telephone], [Contact Information].[Cell], [Contact
> Information].[Email Adress], [Contact Information].
> [Alternate Point of Contact], [Contact Information].
> [Alternate Address], [Contact Information].[Alternate
> Telephone], [Contact Information].[Alternate Cell],
> [Contact Information].[Alternate Email Address], [Contact
> Information].[Other Information], [Site Specific].[Storage
> Tank Available at Site], [Site Specific].[Electrical Power
> Voltage and Phase], [Site Specific].[Pump Operation],
> [Site Specific].[Disinfection Injection Point], [Site
> Specific].[Existing Disinfection Description], [Site
> Specific].[ExistingTreatment Description], [Site Specific].
> [Design Flow Rate], [Site Specific].[Maximum Flow Rate],
> [Site Specific].[Average Flow Rate], [Site Specific].
> [Average Daily Production], [Site Specific].[System Design
> Capicity], [Site Specific].[Water Source], [Site Specific].
> [Population Served], [Site Specific].[Type of Well], [Site
> Specific].[System Type], [Table1].[pH], [Table1].[Total
> As], [Table1].[As (lll)], [Table1].[Alkalinity as CaCO3],
> [Table1].[Hardness as CaCO3], [Table1].[Silica (SiO2)],
> [Table1].[Phosphate (Po4---)], [Table1].[Sulfate (So4--)],
> [Table1].[Iron (Fe)], [Table1].[Manganese (Mg)], [Table1].
> [Antimony (Sb)], [Table1].[Sulfides (S--)], [Table1].
> [Chromium (Cr)], [Table1].[Fluoride (F)], [Table1].[Lead
> (Pb)], [Table1].[Vanadium (V)], [Table1].[Molybdenum
> (Mo)], [Table1].[Selenium (Se)], [Table1].[Turbidity],
> [Table1].[Suspended Solids], [Table1].[TOC] FROM Table1
> INNER JOIN ([Site Specific] INNER JOIN
> Maybe this is just too much stuff?
> Thank you for your assistance...
> George
> >-----Original Message-----
> >While the form is open in design view, click on
> Properties window, (be sure
> >Form is the name in the upper left hand corner combo
> box), and click on Data
> >tab. Click into the box next to Record Source and copy
> all the text that is
> >there. Post it here so we can see it.
> >
> >-- 
> >
> >        Ken Snell
> ><MS ACCESS MVP>
> >
> >"George Wilson" <anonymous@discussions.microsoft.com>
> wrote in message
> >news:2e9001c48ecb$69f0cab0$a501280a@phx.gbl...
> >> I am assisting a customer using Access 2000 on a Windows
> >> 2000 system. She made a form with the form wizard and
> >> claims she only added some labels and moved items around
> >> on the form. Now when trying to view the form she gets
> >> a "Syntax error in FROM clause" and is unable to view
> the
> >> form except in design view. Can anyone think of what she
> >> may have done to cause this error?
> >> TIA
> >> George
> >
> >
> >.
> >

Relevant Pages

  • Re: INSERT command doesnt work in Access
    ... that OleDbException, that says "Syntax error in SQL statement". ... Lately I've tried simple OleDbCommand, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: rewrite QBE SQL statement
    ... I am now getting a syntax error that tells me that I am missing an operator ... Is there a way to rewrite this as nested subqueries in such a way ... I am trying to write a SQL statement based on a SQL statement from the ... I am trying to rewrite this into workable SQL that I can pass as string ...
    (microsoft.public.access.modulesdaovba)
  • Re: Syntax error in INSERT INTO statement.
    ... > I got syntax error in INSERT INTO statement. ... Run the page and look at the sql statement in the browser window. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Problem with INSERT INTO (SQL) statement in VBA
    ... "Ken Snell " wrote: ... <MS ACCESS MVP> ... error (3134 - syntax error in INSERT INTO statement). ... i do want to mention that 'loc' is a numeric field. ...
    (microsoft.public.access.modulesdaovba)
  • Re: between/and parameter help
    ... Try the following as criteria ... then post back with an explanation of what you mean by "doesn't work". ... You get the wrong results, you get a syntax error, you get some other error, etc. ... Access MVP 2002-2005, 2007-2009 ...
    (microsoft.public.access.queries)