Hi,

Can anyone kindly help me how to possibly change/add a value in a specific table using VBA code in MS access. Let say row1,column1 of table1, I want to put a text value of "test" when the date become Jan 19, 2007.

In excel I know how to put value since we just have to refer to Sheet Name and cell location. How about in Ms access table using VBA code?

Thanks!