Last Update Output!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database and I have a form with options and one option is to update
my tables and to do this you click a click a button and it goes through and
pulls list off my computer to update the table in my database. What I want
to do is everytime that button is click to update my database, I would like
to have something at the bottom of the form that shows the last time the
database was updated. How would I go about doing this?
 
Assuming that form is bound to some table (perhaps even a table with ONE
record).

Just put the folwling code at the end of the button code...


me.MyLastUdate = now()
 
Well the button that is clicked it really linked to a macro that goes through
and runs a lot of process (bring in tables, delete queries, append queries,
ect.). Will that code work if linked to a macro and i want to date to be
displayed at the botton of the Form menu like how a web page has a last
update at the bottom?
 
You must log in or register to reply here.

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

Record-Locking remains open after closing 0
What are the steps to fix damaged MDF files in SQL Server? 0
Last date of update saved on UpdatedOn when Save Button is click 5
Controlling another switchboard 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Build search function in to a form 5
cannot pull updated access database into mail merge 3
Save or Update command 2

Back
Top