AddNew method

Results 1 to 2 of 2

Thread: AddNew method

  1. #1
    Join Date
    Dec 1969

    Default AddNew method

    I&#039;m having a bit of trouble with AddNew. The following is based on something I found on MSDN, but it doesn&#039;t work:<BR> With objRS<BR> .AddNew<BR> !Filepath = strPath<BR> !Contents = strContents<BR> .Update<BR> .MoveNext<BR> End With<BR><BR>I&#039;m not sure what the ! stuff is all about, but that&#039;s where it falls over. Effectively, I&#039;m just looking for a way to add the values to to columns in a row at the same time before moving on, but the documentation does not make it clear how to do this!

  2. #2
    Join Date
    Dec 1969

    Default RE: AddNew method

    Try this:<BR><BR>With objRS<BR>.AddNew<BR>.Fields("Filepath") = strPath<BR>.Fields("Contents") = strContents<BR>.Update<BR>.MoveNext<BR>End With<BR>

Posting Permissions

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