Solved

Access 97 DoCmd Syntax Question

Posted on 2014-03-06
2
407 Views
Last Modified: 2014-03-06
I have a syntax error in these statements please help
If In1a > "" Then
                strSQL = "INSERT INTO BlendMix([FPC-ID NUMBER],[Blend Type],[BlendMix],[BlendPercent]) VALUE ('[Blend Type]','[Blend Type]','[Mixd1]','[Percent1]');"
                DoCmd.RunSQL strSQ
                End If
                          Thank you
                                  DWG.
0
Comment
Question by:Denthion
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 52

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39909418
Hi,

Shouldn't it be  VALUES

strSQL = "INSERT INTO BlendMix([FPC-ID NUMBER],[Blend Type],[BlendMix],[BlendPercent]) VALUES ('[Blend Type]','[Blend Type]','[Mixd1]','[Percent1]');"

EDIT
as Values you have twice Blend Type is that correct?

Regards
0
 

Author Closing Comment

by:Denthion
ID: 39909427
Good Catch Thank you
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question