DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

How can I refresh DataBase without closing Form

•

Join Date: Mar 2005

Posts: 2

Reputation: chan is an unknown quantity at this point

Solved Threads: 0

chan

Offline

Newbie Poster

How can I refresh DataBase without closing Form

Mar 28th, 2005

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.

•

Join Date: Dec 2004

Posts: 2,413

Reputation: Comatose is a jewel in the rough

Solved Threads: 211

Comatose

Offline

Taboo Programmer

Re: How can I refresh DataBase without closing Form

Mar 28th, 2005

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

•

Join Date: Jun 2005

Posts: 4

Reputation: DavidXu is an unknown quantity at this point

Solved Threads: 0

DavidXu

Offline

Newbie Poster

Re: How can I refresh DataBase without closing Form

Jun 22nd, 2005

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

•

Join Date: Dec 2004

Posts: 2,413

Reputation: Comatose is a jewel in the rough

Solved Threads: 211

Comatose

Offline

Taboo Programmer

Re: How can I refresh DataBase without closing Form

Jun 22nd, 2005

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