Why do you want to use VBA?

Can't you just use an update query?

To update between dates you will have to add a WHERE clause to your SQL statement.