Hello all,
I develop in MS Access and Filemaker (nono don't get upset).
In Filemaker it's easy to find out who created a record and who modifies it, these are standard fields you can create.
Unfortunately it doesn't seem to be this easy in Access. Or maybe I missed something...
The solution I found for now is the following (per table):
New record date: - date field -Default Value: Date()
New record user: - text field - Default Value: CurrentUser() is not accepted in table design mode so I added a default value to the field CurrentUser() on the form
Modified record date: - date field - filled in with Date() at an "On Dirty" event of the form
Modified record user: - text field - filled in with CurrentUser() at an "On Dirty" event of the form.
It's working fine (even though I hope somebody comes up with a better solution) but the "On Dirty" event to fill in my fields when changes occur to the record always make the user wait for just a few seconds so it looks as if the system is slow.
What is the solution?
Thankyou for reading and eventually answering to this message.
I develop in MS Access and Filemaker (nono don't get upset).
In Filemaker it's easy to find out who created a record and who modifies it, these are standard fields you can create.
Unfortunately it doesn't seem to be this easy in Access. Or maybe I missed something...
The solution I found for now is the following (per table):
New record date: - date field -Default Value: Date()
New record user: - text field - Default Value: CurrentUser() is not accepted in table design mode so I added a default value to the field CurrentUser() on the form
Modified record date: - date field - filled in with Date() at an "On Dirty" event of the form
Modified record user: - text field - filled in with CurrentUser() at an "On Dirty" event of the form.
It's working fine (even though I hope somebody comes up with a better solution) but the "On Dirty" event to fill in my fields when changes occur to the record always make the user wait for just a few seconds so it looks as if the system is slow.
What is the solution?
Thankyou for reading and eventually answering to this message.
