0

Hi,

I want to update records in the access table which is connected to vb.

Can somebody give code for that please.
(ie)when i click add button the entered fields should get updated in the tables and the form should be refreshed again to enter datas.

Edited by Krs13: n/a

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

Hi,

I want to update records in the access table which is connected to vb.

Can somebody give code for that please.
(ie)when i click add button the entered fields should get updated in the tables and the form should be refreshed again to enter datas.

It's nothing.
I cannot write the codes for you here,cause it's pretty lengthy. So, you may write to me to my email address> mansoor_aslam@hotmail.it <
Let me know the names of the Fields that you have in your Database.

Also, I recommnend you not to use the Autonumbers on the Table to save the records in the MS Access, cause you'll have problems if you happened to delete any saved record.

0

So, you may write to me to my email address> mansoor_aslam@hotmail.it <

don't use private email. its not fair. by the way, when enter data by code and you write code for enter its automatically update data. like:
With rs
.CursorLocation = adUseClient
.Open "SELECT * FROM table1", cn, adOpenStatic, adLockOptimistic ' cn is connection

.AddNew

!name = text1.Text
.Update ' update data
End With

so try it with your code what you use.

0

Kris,
The help that I have posted before on other thread can add, update, delete and refresh data on forms. Refer thread 'Retrieve username on all forms' started by you.
Thanks

Edited by kinwang2009: n/a

This question has already been answered. Start a new discussion instead.
Take the time to help us to help you. Please be thoughtful and detailed and be sure to adhere to our posting rules.