[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

How to find when record was entered

Posted on 2014-01-22
1
Medium Priority
?
303 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1400 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

656 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