Results 1 to 3 of 3
  1. #1
    vCallNSPF is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    49

    Adding 'Last Edited' Date

    my databse has different kinds of equipment that all need to be displayed in one giant report, however each subreport for each piece of equipment needs to have a 'last edited' date in the report header.



    i know this would be done through a form, as pretty much whenever a form is used i want the date updated on the corresponding subreport

    thanks

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows XP Access 2003
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    well let me get this straight you have different reports which are most probably connected to different tables and each of this tables are most probably edited through forms. Now there are many ways to solve this problem. Insert a field called update_date in each of your tables. Now make sure you have the update_date field in your forms. Now if you are using a Command Button to save records which is the general practice as we all like to validate our data before it is saved. You can add this code on the OnClick event of your save Button.
    Me.update_date=Date()
    so when ever you save your data the current date is saved.

  3. #3
    vCallNSPF is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    49
    Quote Originally Posted by maximus View Post
    well let me get this straight you have different reports which are most probably connected to different tables and each of this tables are most probably edited through forms. Now there are many ways to solve this problem. Insert a field called update_date in each of your tables. Now make sure you have the update_date field in your forms. Now if you are using a Command Button to save records which is the general practice as we all like to validate our data before it is saved. You can add this code on the OnClick event of your save Button.
    Me.update_date=Date()
    so when ever you save your data the current date is saved.
    this ^^

    solved

Please reply to this thread with any new information or opinions.

Similar Threads

  1. form not letting records be edited
    By stuart rose in forum Forms
    Replies: 3
    Last Post: 09-02-2009, 04:22 PM
  2. Replies: 2
    Last Post: 07-31-2009, 06:56 AM
  3. Adding a Field Name
    By jackthedog in forum Reports
    Replies: 1
    Last Post: 07-04-2009, 08:18 AM
  4. Adding a Manual Date
    By JimmyT in forum Database Design
    Replies: 1
    Last Post: 04-21-2009, 06:12 AM
  5. Replies: 1
    Last Post: 12-09-2005, 10:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums