Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
access database
- Thread starter jjinx
- Start date
The Adodc is designed to read only one record at a time. To see the other records you will need to move through the recordset using
Adodc1.Recordset.MoveNext
Adodc1.Recordset.MovePrevious
To add a new record set the EOFAction property to 2 - adDoAddNew and use the following code.
Adodc1.Recordset.AddNew
All of the above code can be placed in button click events. You should also be able to move through the recordset by clicking the arrow buttons on the Adodc itself. Thanks and Good Luck!
zemp
Adodc1.Recordset.MoveNext
Adodc1.Recordset.MovePrevious
To add a new record set the EOFAction property to 2 - adDoAddNew and use the following code.
Adodc1.Recordset.AddNew
All of the above code can be placed in button click events. You should also be able to move through the recordset by clicking the arrow buttons on the Adodc itself. Thanks and Good Luck!
zemp
- Status
