Syntax error in FROM clause

[George Wilson]

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

 

[Ken Snell [MVP]]

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.

 

[George wilson]

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

 

[Ken Snell [MVP]]

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>

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>




.