updation

[Soundarya]

hi,

i have some string controls on the front panel where i need to enter some values and those values have to go to the database table(ms-access).

so i have inserted using insert statment. but i also need to modify the old values to new values. so for modifying the old values to new values, i need to write the update statement.

so how can i write the update statement with all the values given to those string controls on the front panel.

can u elaborate about this?

Inadvance Thanks

Regards

Soundarya

[MikeS81]

Hi Soundarya,

please stay in one thread for this topic.

Can you show what you have done so far? Maybe you can also show a part of your database and the values you want to update.

Please see also this link, it shows how you can build an "UPDATE" query which you can send with the "DB Tools Execute Query" function.

Mike