Form showing Time and Date a Table was updated

  • Thread starter Thread starter adamevans81
  • Start date Start date
A

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
 
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
(e-mail address removed) typed:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating tables when you input new data 0
Query only showing last 10 entries 6
Calendar Option with Date and Time 3
Question about Table Date Time Stamps 2
Displaying Last Update!! 7
update data in table through form 3
Show date last updated on form 7
After Update Event 3

Back
Top