Re: Add record programmatically

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

anonymous_at_discussions.microsoft.com
Date: 03/21/04 

Date: Sun, 21 Mar 2004 09:22:48 -0800

>-----Original Message-----
>"Eugene" <ekim@tengizchevroil.com> wrote in message
>news:B3243127-4396-4AFC-831D-
0E90D6AC9C7F@microsoft.com...
>> Hello, everybody!
>>
>> I tried to write a code for adding a new record to my
table. A simple
>[tablefield]=[value] assignment did not work.
>> Can someone say, what was my mistake and what is the
best way of adding
>records using VBA?
>>
>> Thanks in advance,
>> Eugene.
>
>CurrentDB.Execute "INSERT INTO TableName (Field1,
Field2, ...) VALUES (Value1,
>Value2, ...)",dbFailOnError
>
>In the VALUES list non numeric entries would need to be
properly delimited (')
>for text, (#) for dates. The list could also use form
references to pull the
>values from controls on open forms or the VALUES list
can be entirely replaced
>with a SELECT statement to grab rows from another table.
>
>--
>I don't check the Email account attached
>to this message. Send instead to...
>RBrandt at Hunter dot com
>
>
>.
>

Relevant Pages

  • Re: compiling problem
    ... infragistics stuff from the toolbox and problem is solved. ... Its the latest version of their controls. ... removed including references, liscence dll added to the project, and some ... The section enables configuration ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: UserControls Vanished
    ... >>Search is not working for me for this newsgroup. ... After editing one of the controls, ... >>rebuilt the project all of the usercontrols on every form ... >>code still references all of them. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Terminate Event is not triggered on application close
    ... i'm using a global collection object which is used ... I can use these controls in standalone as ... If there's a circular reference (object A references object B and object B ...
    (microsoft.public.vb.general.discussion)
  • RE: Search form for multiple fields
    ... Create an unbound dialogue form with three unbound controls and a command ... parameter and, to make the selections optional, test for Nulls, so the query ... In the above frmSearch is the name of the dialogue form, ... table of technical references in a database. ...
    (microsoft.public.access.gettingstarted)
  • Re: VB Form Description Structure
    ... Object is an ActiveX object you are using on the form. ... references tells what global references you project has, ... In the sample you included we can see, you are using 3 ActiveX controls: ... > what does the CLASSID means in the "BeginProperty" section? ...
    (microsoft.public.vb.syntax)