Adding Date to table field

[Guest]

Yet another question from a stuck amateur user, I have a function that
imports data from an external db, on completion of this I would like to write
to the destination table the date that it was last updated anyone with any
ideas in how to do this?

TIA

 

[Joseph Meehan]

Yet another question from a stuck amateur user, I have a function that
imports data from an external db, on completion of this I would like
to write to the destination table the date that it was last updated
anyone with any ideas in how to do this?

TIA

Do you want to record the last update to the table or the last update to
a specific field and/or to a specific record?

How does that import "function" operate?

 

[Guest]

Hi,

The import function works from a VBA module that first deletes a linked
table then refreshes the link then using a delete query it looks for
unmateched in source and destination and deletes those, then runs an update
query, followed by an append query, now I'm not to worried which way round
the date is record but I guess what I'm after is the date the destination
table was last updated.

TIA

 

[Joseph Meehan]

Hi,

The import function works from a VBA module that first deletes a
linked table then refreshes the link then using a delete query it
looks for unmateched in source and destination and deletes those,
then runs an update query, followed by an append query, now I'm not
to worried which way round the date is record but I guess what I'm
after is the date the destination table was last updated.

Why not have add an event to set the field and record of your choice to
DATE() You could use a separate table and you could add a record each time
you ran the event to keep a history of each time it was run.