View Full Version : VBA : MS Access : Adding to a table

05-20-2010, 05:58 PM
Hi All,

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 :thumbsup:)

I hope you call help -- p.s - If possible, I'd like to not use a SQL string to do this

Thanks Everyone