i have a problem in VB6. i have a frmMain, DataEnvironment and Datareport. My form have thirty (30) textboxes to fill-in. at first it all works fine since i filled in only few txtboxes, but when i filled-in all textboxes with many data i could not save the data anymore... error. How can i solve this problem... please help

Recommended Answers

please post your code here for reference.

Jump to Post

All 3 Replies

please post your code here for reference.

This should work for DAO (and ADO, I believe)...

If you are doing SQL... Then I can't help you...

You have to use rst.Update to actually update the database record

You have to use rst.Edit to change fields in the record

Basically, once you open a RecordSet you have to .Edit to change things, then, when you're done changing things, you have to .Update to write the changes back into the database...

thanks for your help guys... i change some fields that contain only 50 texts, i made it 255 so that more text can be entered. it worked!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.