to know time of last action....

  • Thread starter Thread starter Shivalee Gupta via AccessMonster.com
  • Start date Start date
S

Shivalee Gupta via AccessMonster.com

i am a newbie.please answer me step-by-step.
I have a form on which i have a command button.this command button imports a particular file from excel to access regularly and oftenly, as i keep updating the excel file and then i have to import again. (i have 25 import buttons as i have 25 tables & 25 excel files).
i need to write a code which will tell me when was the last time i imported that file into access-so whether the excel file was changed or not and accordingly whether i want to import again or not.
thanks a lot...
shivalee
 
Ok, if you are importing a file from code, then in your code once the
file is imported then add a line to insert the current date and time.
Create a field in your table to hold this date and time. Data Type for
this field should be Date/Time and Format your field as General Date.
 
Back
Top