Get the date of the last modification

[MrBaRRon]

Hi everybody,

I would like to get the date of the last modification in wrod and excell file. Besides, I wouldlike the same things for an access form, I mean, when the user modify datas dispplayed in an Access form, I would like to get the date.

Thank U .

 

[PHV]

For a file, take a look at the FileDateTime function.
For an access form:
CurrentProject.AllForms("your form name").DateModified

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MrBaRRon]

Aahhhh

Thank U very much PHV, It's exactly what I need.

I would like to know for the access form wether the function returns the date of the last modification of the structure of the form or of the datas displayed in the form because I need the date of the modification of datas.

Thank U again.

 

[RoyVidar]

For information on when the information was changed, I think you'll need to include a field in your recordsource to hold it, then whenever the information changes (I'd think use the before update event of the form, which will trigger whenever a change in a record is performed) dump the current timestamp into a control (not visible?) bound to that field:

[tt]me("txtModified").Value = Now()[/tt]

BTW - for Access questions, you might want to check out the "pure" Access fora, some of them available thru the Related Forums box at right.

Roy-Vidar

 

[MrBaRRon]

Thank U very much RoyVidar ,

I think it's an issue for my problem. I will try it !

Thanks.