Member Avatar for chan

i am working with VB6. i used ADODC recordset. in my Form there is some text box and command bottom. it is about Student Data for example. it can view and add new record. i want a view after adding new record.so how can i refresh DataBase record from Access with closing a Form.

  • 3 Contributors
  • 3 Replies
  • 78 Views
  • 2 Months Discussion Span
  • Latest Post Latest Post by Comatose
Member Avatar for Comatose

Do you have any code written already.... if so post it.

Member Avatar for DavidXu

Hello!

You can invoke "update" method to refresh database.

eg.
datGrid.Recordset.Edit

'To save the value converted of Barcode Value Column
datGrid.Recordset.Fields(3) = strOutput & "-00-00-09-00-F"

'To refresh database
datGrid.Recordset.Update


Greetings,
David Xu

Member Avatar for Comatose

I've found that most people have trouble with the update method. usually it seems to require some kind of disconnect and reconnect to the database to show changes, and when it does actually work, it's sporadic, and unpredicatable....

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.