Form showing Time and Date a Table was updated

[adamevans81]

Hi All,

I want to create a database which a number of users can access
simulataniously. On the main form I want to give an option to update
the contact tbl but I want it to show the last time and date the table
was modified.

Does anyone know how I can return the modified date and time of a table
to add into a form?

Adam

 

[Nick Coe \(UK\)]

Alternatively add a date/time column to the table called
LastUpdate and set it's value in your form using the Now()
function in the DefaultValue of a text control bound to that
column.

--
Nick Coe (UK)
http://www.alphacos.co.uk/
pAnimal - Pedigrees and Breeding - Download free 30 day
trial
AccHelp - Skeleton Help for Access Apps
http://www.pjandcoe.co.uk TShirts with Bark factor...


In
[email protected] typed: