By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

System update message Board

P: n/a

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!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
re******@pcdatasheet.com
www.pcdatasheet.com

"malvina shagabayeva" <ma*****************@hewitt.com> wrote in message
news:40***********************@news.frii.net...

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!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.