Welcome, Guest. Register Now!
   
Mark Forums Read Mark Forums Read Mark Forums Read


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 02-14-2008, 10:38 AM
Junior Member
 
Join Date: Nov 2007
Posts: 2
iTrader: (0)
srepartaxiad is on a distinguished road
Default Form setup

When you have a simple form setup where people can enter requests for the analyst to do. When someone enters their information is there a way to know when that data was entered. Any suggestions?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-16-2008, 06:07 AM
Member
 
Join Date: Oct 2007
Posts: 41
iTrader: (0)
TonyES is on a distinguished road
Default

You can add a field of DateCreated and (if you like) of DateModified to the table, both date/time type.
Place the default value of the field of DateCreated at = Now()
If you also add a field of DateModified, put the code in before the event of update of the form:

Private Secondary Form_BeforeUpdate(Cancel Like whole Number)
Me.DateModified = Now
Submarine Of End

You can put boxes of the texts related to DateCreated and DateModified on the form, but should place their property locked to you at yes, so that the user cannot modify them.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -6. The time now is 03:27 AM.