Date/Time Stamp when the tables are imported

[ragsgold]

Hi All,



I have a database which has linked tables and also uploaded tables. I have multiple queries which is controlled through a main form. In the main form I would like to add also an addition information of date/time as and when these linked tables or uploaded tables incurs a change.

for instance i upload new data to my text file which is linked to the access table or when i upload data to few other unlinked tables i want to see the date/time stamp in this main form.

Both linked file updation and upload files updation happen at the same time.

How can I do this Can i use the calender feature in toolbox/additional controls i am not able to get this ...plz help

[llkhoutx]

FieldLoadDate = Date()

[ragsgold]

how do i do this had this additional name as a filed and set the condition as DATE() ?

[ragsgold]

how do i use this

[llkhoutx]

Add the date field to your table(s).

After table is loaded, run an update query setting the date field to Date().