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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Use ADO to populate a datasheet - Access 2002
- Thread starter dlgtwice
- Start date
Have a look here:
Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
- Thread starter
- #3
Thanks PH!! That got me moving in the right direction.
I was able to bind the recordset to the form using the info in the article. The section "Opening a Separate ADO Connection" was particularly useful since my database is split.
I'm still struggling with the datasheet view though. If I open the form in datasheet view I get the right number of records but they are all filled with the data from the first record. I tried the move commands but they just moved me to different records through the table but still displaying one record multiple times. Any thoughts on how to get the other records to display?
I was able to bind the recordset to the form using the info in the article. The section "Opening a Separate ADO Connection" was particularly useful since my database is split.
I'm still struggling with the datasheet view though. If I open the form in datasheet view I get the right number of records but they are all filled with the data from the first record. I tried the move commands but they just moved me to different records through the table but still displaying one record multiple times. Any thoughts on how to get the other records to display?
- Status
Similar threads
- Locked
- Question