adding new record??

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

Afternoon all,

Im just getting into this VBA for access stuff and am a bit confused. If
the database is already open how do you add data to a table in the new
record position? I have read about AddNew...but this doesnt make it any
clearer.

If this was AutoCAD and I wanted to add a line....there is an object
ThisDrawing....so I can use Thisdawing.AddLine method....

Can someone show me some sample code please??

Scott


.

Relevant Pages

  • OpenDatabase/OpenConnection commands
    ... I am trying to rewrite a database from an older version of Access to Access ... VBA is still fairly new to me and there is a single line of code that ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • exposing methods and props in c# dll via COM
    ... language like VBA can use them? ... Scott ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Linked tables
    ... Is there a way to manage linked tables from VBA? ... another database with identical structure. ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: Indexs and seek need help
    ... > Here is the scenario. ... > Access XP using VBA. ... > This works with an Access 97 database not with an Access XP database. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Detecte ither instances of same .mde
    ... How do I detect an already opened - but minimized - instance of a database ... from VBA? ... Diane ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)