PC Review


Reply
Thread Tools Rate Thread

date field that registers when a register has been modified

 
 
=?Utf-8?B?T0dV?=
Guest
Posts: n/a
 
      20th Mar 2006
how can I create a field to register date and time of any register at the
moment it is modified
 
Reply With Quote
 
 
 
 
Douglas J Steele
Guest
Posts: n/a
 
      20th Mar 2006
You can only do this if you're doing all of your updates through Forms. Put
logic in the form's BeforeUpdate event to set the LastUpdateDTM field to
Now().


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"OGU" <(E-Mail Removed)> wrote in message
news:7EF707FD-3B4B-4B46-9200-(E-Mail Removed)...
> how can I create a field to register date and time of any register at the
> moment it is modified



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
modified date field ljg08 Microsoft Access Database Table Design 2 20th Jun 2008 12:20 PM
Date last modified for a field jhicsupt Microsoft Access Forms 3 3rd Mar 2008 02:07 PM
Modified Date Field Jason Microsoft Access Forms 3 3rd May 2005 03:14 PM
'Date Modified' field Wayne G. Dengel Microsoft Access Getting Started 6 30th Sep 2003 11:26 PM
Name of Field that registers date and time of last change? Kristian Microsoft Outlook Form Programming 4 10th Jul 2003 02:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:18 AM.