Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Update date

Discussion in 'Information Technology' started by Ron, Jul 28, 2006.

Tags:
  1. Ron

    Ron
    Expand Collapse
    Guest

    I have an Access 2002 db that is tied to data from MS Project. Several times
    a week I update the Access tables by saving the MS Project as an Access db
    and overwrite the main data table. I make a number of reports available to
    all departments that they access through a form. In this form is a list box
    that gives the date and time that the data was updated. Is there a way to
    have the list box automatically return the date and time that the data
    tables are updated from the MS Project data? When the main data table is
    overwritten from MS Project could that trigger an update of the time and
    date in the list box and how could this be accomplished? Any help would be
    appreciated.
    Ron
     
  2. Loading...


  3. Kirk P.

    Kirk P.
    Expand Collapse
    Guest

    I would add an UpdateDate field to your main table. Create 2 queries to
    automate the process of updating the table. One query will be a delete query
    that simply removes all the records from the main table. The other query is
    an append query that will paste the new records into the main table. In your
    append query, create an UpdateDate field as such: UpdateDate: Now()

    Create a macro that runs the delete query first, then runs the append query
    and assign the macro to a command button (cmdImport). When you click the
    Import button, the macro will clear the records from your table, paste in the
    new records, and assign the exact date and time you imported the records in
    the UpdateDate field.


    "Ron" wrote:

    > I have an Access 2002 db that is tied to data from MS Project. Several times
    > a week I update the Access tables by saving the MS Project as an Access db
    > and overwrite the main data table. I make a number of reports available to
    > all departments that they access through a form. In this form is a list box
    > that gives the date and time that the data was updated. Is there a way to
    > have the list box automatically return the date and time that the data
    > tables are updated from the MS Project data? When the main data table is
    > overwritten from MS Project could that trigger an update of the time and
    > date in the list box and how could this be accomplished? Any help would be
    > appreciated.
    > Ron
    >
    >
    >
     

Share This Page