I need to set up a system that will keep track of my daily updates in
the DB. I would like the user to see a message after opening the
database, that would display that the last update was done on #date#.
Any suggestions will be greatly appreciated.

Malvina S


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You need a table to store the last update date. Then when an update occurs, you
either need to add a new record for the new update date or edit the update date
that is there. Presuming that your database opens to a specific form, put this
code in that form's OnOpen event:
MsgBox "The Database Was Last Updated On " _
& DMax("[UpdateDate]","TblUpdateDate")


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com



"malvina shagabayeva" <malvina.shagabayeva@hewitt.com> wrote in message
news:400c0138$0$70303$75868355@news.frii.net...[color=blue]
>
> I need to set up a system that will keep track of my daily updates in
> the DB. I would like the user to see a message after opening the
> database, that would display that the last update was done on #date#.
> Any suggestions will be greatly appreciated.
>
> Malvina S
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]