Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Posts
    146
    Thanks
    0
    Thanked 0 Times in 0 Posts

    AddNew method (2000 SR-1)

    Is it possible to use the AddNew method of the RecordSet object to copy an existing record to another table? If so, is there a quick way to pull all the values from the existing record without inserting value lines for each field?

    Thanks,
    Bob

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: AddNew method (2000 SR-1)

    You might loop through the Fields collection of the recordset. Be careful not to copy an AutoNumber field, if present.

    But if you want to copy all fields, creating the SQL for an append query and executing it is probably easier.

Posting Permissions

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