Member Avatar for rexgb_34

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
  • 130 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by rexgb_34
Member Avatar for debasisdas

please post your code here for reference.

Member Avatar for SpiritualMadMan

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

Member Avatar for rexgb_34

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.