Re: Insert a New Record

ok i figured out how to insert a new record to a table through a text box by
using Me.txtCustomer.SetFocus, den typing in the relevant SQL statements. But
how can i insert multiple values from multiple textboxes into a new row of
record in a table? i've tried using the same method to set focus to all the
controls but the error message" You can't reference a control or property
without giving it focus" keeps occuring? anyone has any idea on how i can
solve this? some sample coding would help me greatly. thanx!


Van T. Dinh wrote:
>You can either use the Execute Method to execute an Append Query / SQL
>String
>
>or you can use the AddNew Method of the Recordset object.
>
>Check Access VB Help on Execute or AddNew.
>
>> HI all out there, can anyone give an example of VBA codings in Access to
>> for
>> me to insert a new record into a table with the source data from multiple
>> textboxes? thanks

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Idea of SQL integration
    ... this issues like compiler directive e.g. ASM. ... is no general solution for multiple DB vendors (sas for multiple ... It gets a SQL statement and another parameter: Open, Execute, ExecuteAndFree. ...
    (borland.public.delphi.non-technical)
  • Re: How do we execute a link server side?
    ... I want to execute a link witch is in JavaScript, ... DID overlap multiple groups, you would do better to use cross-posting ... This email account is my spam trap so I ...
    (microsoft.public.scripting.jscript)
  • Re: i am trying to Execute some command Bar Button but doesnt work [multiposted]
    ... may cause multiple people to respond to your ... > i am trying to Execute some command Bar Button i can change if there ... > COM add-in works i did that in word 2003 and the COM ADD-IN is for Outlook ...
    (microsoft.public.vb.controls)
  • Re: permission magically changed
    ... On 火, 2004-08-31 at 15:13 -0400, Michael E. Webster wrote: ... >> directory and stripping the execute bit. ... I changed it back multiple ...
    (Fedora)
Loading