Howdy, Stranger!

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

Categories

Automatically record creation & modification dates-need help

SuzyTallSuzyTall Member Posts: 9
[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

  • llunnllunn Member Posts: 63
    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

  • Chris BrownChris Brown USAMember Posts: 4,624 ✭✭

    _______ / http://forcoder.org / free video tutorials and ebooks about ( C, Scratch, Swift, Visual Basic, JavaScript, Ruby, Delphi, PHP, Visual Basic .NET, C#, C++, Perl, Assembly, MATLAB, Python, Go, PL/SQL, Objective-C, Java, R COBOL, Scheme, Transact-SQL, ABAP, Awk, Clojure, Crystal, LabVIEW, FoxPro, Julia, Erlang, Alice, Kotlin, Rust, Prolog, Lisp, SAS, Ada, F#, Apex, D, VBScript, Dart, Scala, Hack, Fortran, Lua, Logo, ML, Bash ) __________

Sign In or Register to comment.