Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
05-20-2010, 04:58 PM #1
- Join Date
- Sep 2009
- Thanked 0 Times in 0 Posts
VBA : MS Access : Adding to a table
I'm hoping someone who knows their VBA will be able to help me with this. I have a table called t_sampleTable, which has 2 columns ("recordID" and "testAdd").
I have a variable called variableAdd, which holds an integer value.
I also have a variable called recordVar, which holds the recordID.
I want to add the value of variableAdd to the table, on record recordVar.
I know this must be simple but I can't get it to work for me!
I have opened the recordset for editing, and I can add data to it no problem - I just don't know how to add the data to a specific column for a specific record.
This is for work, not homework (my homerwork would be Java )
I hope you call help -- p.s - If possible, I'd like to not use a SQL string to do this