Opdatere dato ved ændring i posten

You need an extra field in your table \"ajourført-datoen\"

Then if you alter a record directly in table view you can alter the field manually. If you alter the record on a from then you can add the new field to the form and set the fields default value to = Now()
If youupdate in SQL then add it to your UPDATE statement

Den skal skrive ajourført datoen automatisk. Jeg opretter et felt med navn AjourførtDato og sætter den til =now(), MEN! Den skal ÆNDRE sig HVER gang jeg laver en ny ændring i recorden.

Du er nødt til at have et nyt felt, der viser datoen for en rettelse af posten.

I det eller de felter du retter, indsætter du en kode i AfterUpdate:

Ajourført = Date

eller now()

Mvh / Mugs

Hvad specifikt skal jeg skrive i AFTERUPDATE

Lige nu har jeg prøvet med =[AjourførtDato] i AfterUpdate, hvor AjourførtDato feltet er sat med en default =now() - men det virker ikke når jeg går ind på recorden igen og ændrer til noget andet.

fastwrite you CANT do it automatically without doing something yourself!
When you create a record your oprettelsesdato gets set to the defalt value (now()) but this is ONLY when you create a record and DO NOT enter a value yourself, this DOES NOT happen on update of the record, so what I said in my answer goes... If you alter the record directly in your table then you CAN NOT update the AjourførtDato field automatically. If you do it in a form then you can do it as I mentioned or as mugs says. Make your choice or answer the question yourself!!!

Den skal jo skrive datoen ét sted, nemlig på feltet AjourførtDato, og ikke på alle felterne. Men lige meget hvilket felt man retter, skal den vise den nye dato.

Terry> Det BØR kunne lade sig gøre, at den gør det automatisk. Hvis den kan skrive datoen for oprettelsen, kan den også se når man har ændret dato, og dermed skriver en ny dato.

In the forms BEFORE Update event add

me.ajourført = Now()

where ajourført is the name of the field

fastwriter> believe me, it cant, this is a DEFALUT value ONLY when you create a record and DO NOT enter the date yourself!

it wont accept the me. - it thinks that it is a macro called me. ?!

Terry - btw - how can you read danish, but not write danish?! Are u a multiple guy? :o)

If you put the code in the FORMS update event then you dont need to worry aboutwhich field you update! It cant be on the FORMS after update event, because its too late....

drop the me, although I cant see why it should be necessary!

I am English, but have been in Denmark a few year and it takes far too long for me to write Danish, I would never get a word in...

hmm. If i use the Afterupdate in the FORM -

the Access says : \"Microsoft Access can\'t find the macro \'AjourførtDato=now()\'

--- what do u want me to do now?

send the dB to dkTeBrSa@Europe.lego.com

I FOUND OUT!!!!!
YEESSSS....

U have to go to the Code builder and then it works!!! thank you so much, Terry...

You work for LEGO?!!!??! GREAT!!!! Nice to earn money to be a boy :o)

I gave you the \'money\' for it!! thanx again.

thank you!