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

How to update table in access vba

P: 1
Hi,

I am trying to update a new table which i have created. The purpose is if i change any input parameters and run the code, the table should automatically update itself. This is for 8760 hours in an year. I have created the table and the output results do get set in the specified table but I cant seem to update them....Please suggest what I need to do.

************Code***********

'Tabular form result output

rs3.AddNew
rs3!Hour = rs1!Hour
rs3!Cr = Cr(h)
rs3!Cd = Cd(h)
rs3!Cs = Cs(h)
rs3.Update

rs3.MoveFirst
h = -1
Do While Not rs3.EOF
h = h + 1
rs3.MoveNext
Loop

rs.MoveNext
rs1.MoveNext
rs2.MoveNext

Loop
Loop
Loop

Debug.Print Cs(0); Cs(8759)

End Sub
**************End of code************
How can I update this table if i make any new changes in recordset rs or rs1 or rs2?

Thanks
specialone
Aug 31 '10 #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.