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.
chan
0
Newbie Poster
Recommended Answers
Jump to PostDo you have any code written already.... if so post it.
All 3 Replies
Comatose
290
Taboo Programmer
Team Colleague
Do you have any code written already.... if so post it.
DavidXu
0
Newbie Poster
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
Comatose
290
Taboo Programmer
Team Colleague
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.