Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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
    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page