I am new in VB 6. I am have created text boxes and trying to add new data to the MS access. Whenever i add new data it replace the already exixting data in my table. I want new data to be entered without disturbing any existing data in my table. I am using recordset.addnew to add data. no sql commands. Could you please tell me why my new data always replace the top existing data in my table and its solution.
kamaamin
0
Newbie Poster
Recommended Answers
Jump to PostShow me the code where you add the actual data. Include the entire sub, i.e., if it is under a command button click event, show all the code under the event. It sounds like the add new is actually editing.
Jump to PostPleasure:)
That is why it is ALWAYS better to go adodb way. There is really only about 4 important sql statements to learn that will do most of what you require in an application.
Please mark this thread as solved, re-open a new post with your question about …
All 8 Replies
AndreRet
526
Senior Poster
kamaamin
0
Newbie Poster
kamaamin
0
Newbie Poster
AndreRet
526
Senior Poster
kamaamin
0
Newbie Poster
kamaamin
0
Newbie Poster
AndreRet
526
Senior Poster
peter_budo
2,532
Code tags enforcer
Team Colleague
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.