Data collection and updating database automatically

  • Thread starter Thread starter Carmen
  • Start date Start date
C

Carmen

I have a database set up that catalogs document templates.
template owners would fill out a form that would be
requesting changes to a template and I want to track our
completion of the request with a completed check box and
date etc... How would my form information be updating
information in the main table to reflect last time
document was updated etc..

any ideas on how this could be automated??

Any help will be greatly appretiated.

Carmen
 
I would set it up using 2 tables. 1 to keep track of the template info
(name, creator, created date, etc.) then a second table to track change
requests. For the user to request a change, have them use a form that will
add to this second table without the completed field. Then for the person
making the change, have them use a separate form that has a check box for
the completed field. On the OnClick event of the check box have it set the
field for the completed date to the current time, Now(), if the box is
checked and to Null if the box is unchecked.

Kelvin
 
I'm not sure what you are asking? Do you mean the date that windows keeps
track of such as created, modified, and accessed? Is this something you are
interested in? You can find out the date and time it was created using the
DateCreated property, but I don't know of a way to change it. You can also
use the FileDateTime function to determine the last modified date and time.
again, I don't know of a way to change this through code. I assume the last
modified could be changed by opening the file, saving it, then closing it
again.

Kelvin
 
Back
Top