using macro to rename column values in Access

[coolbear91]

dear all,

I'm new in Access and trying to use macro to rename any NULL columns into some other values.
my questions are:

1. what kind of command should I use to do that?
2. is there any way in access to record any change with macro as we can find in Excel?

I'm totally blank regarding to this and kindly need your advice.


thank's.

[alcapps]

you can do many things to solve this issue..

one is to set the default to something

default property will make the value as you would like it to be.

="NA" or what ever you want it to be.

Audit control can be done many ways..

one is you can handle the records yourself and save a new record every change using
startdate and stopdate fields
current record would be the stopdate is null

or you can check only the fields your interested in by using the after update of each field you want to track
and update a table with the oldvalue property and current value with user id and date..
if the value changes.. update the table with the now date, field name, table it came from, old value and new value and user

so if you had column Field1

in the after field1.after update event
if me.field1.oldvalue <> me.field1 then
write record...
end if

setup an audit table
id
asofdate
table
field
oldvalue
newvalue
user

hope that helps