Results 1 to 2 of 2

Thread: Add new record

  1. #1
    Join Date
    Jun 2004
    Posts
    14

    Question Unanswered: Add new record

    sorry bout the simple question...couldn't find an answer in search.

    How do I add a new record with a VBA module?

    I have a string.

    I have a table that only has one text field.

    I want to add my string as a new record in my table.

    Thanks!

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Try using the....


    DoCmd.RunSQL "INSERT INTO myTableName (blah blah blah)



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •