By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,329 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Update Table from another Table using Visual Basic Code

P: 30
Hi!

I have two Table names:

tblupdate
tblDetails


What i want to do is to update the table tblupdate from tblDetails using the button in Visual basic Interface.

Here my code:

Str = " Update tblupdate " & _
" Set tblupdate.Text1 = (Select Text1 From tblDetails where tblDetails.Text1 = '" & Text1.Text & "') " & _
" Where tblupdate.EEID = tblDetails.EEID "
con.Execute Str

but the error says : "No value given for one or more required parameters."

Pls. help me. tnx.
Oct 24 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.