Automatically record creation & modification dates-need help

[b][red]This message was edited by SuzyTall at 2002-10-2 10:58:13[/red][/b][hr]
[b][red]This message was edited by SuzyTall at 2002-10-2 10:57:47[/red][/b][hr]
Hello, I'm very new to Access. I just went through a tutorial and I have just gotten a parttime job where I need to keep up an Access database. I need to figure out how to have Access 2000 automatically record the creation date of a record and then to automatically record and keep track of subsequent modifications to records. I must not be asking the online help the right questions because I'm not getting anywhere. If anyone can help me with a step by step, I would be so grateful. Thank you very much in advance!

Suzy




Comments

  • A quick way to do this would be have the default value of your field that holds the creation date equal to Now()

    Using the same function: Now(), you can put in a snippet of code in the BeforeUpdate event of your form that would change the field that holds your last modified date to the current date: Now()
    Lee
    Moderator

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion