RE: How do I use the INSERT INTO Statement in VBA?
- From: "Ofer" <Ofer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 28 Jul 2005 14:34:02 -0700
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:
- RE: How do I use the INSERT INTO Statement in VBA?
- From: Unique Name
- RE: How do I use the INSERT INTO Statement in VBA?
- References:
- How do I use the INSERT INTO Statement in VBA?
- From: Unique Name
- How do I use the INSERT INTO Statement in VBA?
- Prev by Date: i cant open the window to microsoft office word viewer help
- Next by Date: Re: Difference Between Null, Empty and ""
- Previous by thread: 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
|
