Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / January 2006

Tip: Looking for answers? Try searching our database.

Trying to add second row data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BobbyS - 10 Jan 2006 23:29 GMT
I have the following code...the first record is added in the table but not
the second..
What is wrong?

       With rsNewData
       .AddNew
           ![Comparison] = "User"
           ![ReturnVal] = strResponse
           ![Description] = "No"
           .Update
       .AddNew
           ![Comparison] = "PermPath"
       End With
Thanks
Ofer - 10 Jan 2006 23:39 GMT
You don't have .update in the end, after the add new

With rsNewData
       .AddNew
           ![Comparison] = "User"
           ![ReturnVal] = strResponse
           ![Description] = "No"
           .Update
       .AddNew
           ![Comparison] = "PermPath"
           .update
       End With

Signature

\\// Live Long and Prosper \\//

> I have the following code...the first record is added in the table but not
> the second..
[quoted text clipped - 10 lines]
>         End With
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.