RE: How do I use the INSERT INTO Statement in VBA?
- From: "Unique Name" <UniqueName@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 28 Jul 2005 15:11:03 -0700
I modified the insert statement to reflect your posting but I am still
getting an error:
DoCmd.RunSQL "INSERT INTO tblBatch (Batch #,Entry Date) VALUES
(Forms![frmLabourTransaction]![txtBatchUnbound],Forms![frmLabourTransaction]![TxtDateUnbound])"
The error reads:
Syntax error in INSERT INTO Statement.
Thanks
"Ofer" wrote:
> Can you please post the all insert statement and the error you getting.
>
> The syntax should be
> docmd.runsql "insert into target (Field1,Field2,Field3) values
> (Forms![FormName]![Field1Name],Forms![FormName]![Field2Name],Forms![FormName]![Field3Name])"
>
> "Unique Name" wrote:
>
> > I am trying to enter data into a table from a form using the INSERT INTO
> > Statement in VBA forAccess 2003. I type it as shown in the assistance(below)
> > but keep getting errors. Is there something I am missing?
> >
> > INSERT INTO target [(field1[, field2[, ...]])]
> > VALUES (value1[, value2[, ...])
> >
> > Thanks
.
- Follow-Ups:
- References:
- How do I use the INSERT INTO Statement in VBA?
- From: Unique Name
- RE: How do I use the INSERT INTO Statement in VBA?
- From: Ofer
- How do I use the INSERT INTO Statement in VBA?
- Prev by Date: Re: Difference Between Null, Empty and ""
- Next by Date: RE: How do I use the INSERT INTO Statement in VBA?
- Previous by thread: RE: How do I use the INSERT INTO Statement in VBA?
- Next by thread: RE: How do I use the INSERT INTO Statement in VBA?
- Index(es):
Relevant Pages
|
