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

Adding dates to comments

P: 4
I have a database that tracks office projects and everytime someone updates the project I need the system to track the date the porject comment was entered.

Everytime I try to do this it freezes my database.

Any suggestions.

Filed = Comments (Notes)
Date= CommentDate (Date/Time)

Thank you.
Oct 23 '06 #1
Share this Question
Share on Google+
3 Replies

P: 143
What is the code you are using and what event have you used?
Oct 23 '06 #2

Expert 100+
P: 1,892
Why don't you add another column to the table and set the default date to Now() then when someone enters a new project it will automatically add the date for you.
Oct 23 '06 #3

Expert Mod 10K+
P: 14,534
You could put an after update event on the comments control on data entry form.

Expand|Select|Wrap|Line Numbers
  1. Private Sub Comments_AfterUpdate()
  2.    Me.CommentDate=Format(Now(),#mm/dd/yyyy#)
  3. End Sub
It all depends on how the comments field is being updated. If I remember correctly a Notes data type is the equivalent of a memo field in Access and it can cause problems.
Oct 23 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.