Solved

How to find when record was entered

Posted on 2014-01-22
1
287 Views
Last Modified: 2014-01-23
Can you find somehow, in Access, when the records in fields are entered or updated?  I am trying to retrieve records from Crystal Reports that were only updated or entered within a week.  In other words, I don't want to select records that were not updated not entered within a week.  If Access keeps the data entry dates, I may be able to use it in Crystal.  Does anybody have any ideas?  Thank you in advance.
0
Comment
Question by:kg6lfz
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 350 total points
ID: 39800606
Access doesn't track this sort of information.

If you're using Access 2010, you can create Data Macros that can fire when data is inserted or updated into your tables.

If you're using anything else, then you would have to do this at the form level, using something like an "audit trail". Essentially, you create audit tables, and then write to those tables anytime a record is added, updated or deleted through your forms. This works as long as data is ALWAYS managed through forms. If you allow users to interact directly with tables or queries, then you can't use these methods.

The most rudimentary of this approach would be to add a field named Last_Updated to your tables, with a Datatype of Date. Then, in your forms, you could run code in the Form's AfterUpdate field to "stamp" the record with the current date/time.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question