0

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

3
Contributors
3
Replies
5
Views
6 Years
Discussion Span
Last Post by rexgb_34
0

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...

0

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!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.