Displaying Last Update!!

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

Guest

I created a field in my table that is called Date Modified and it shows the
date and time the table was modified. Now I have a form and at the bottom of
the form I want to create a label or text box that shows the date modified
from my table. What should I do?
 
I created a field in my table that is called Date Modified and it shows the
date and time the table was modified. Now I have a form and at the bottom of
the form I want to create a label or text box that shows the date modified
from my table. What should I do?
Click to expand...

Bind the control to the Field you created and set Locked = Yes and Enabled = No
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
When i try to do that I get "#Name?" in the box, what can i do?
Click to expand...

Can you go to the Data tab of the Properties sheet for the TextBox and in
ControlSource line press the down arrow and find your field and select it?
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Nope

RuralGuy said:
Can you go to the Data tab of the Properties sheet for the TextBox and in
ControlSource line press the down arrow and find your field and select it?
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
Click to expand...
 
Nope
Click to expand...

It sounds like your form is not bound to the table you described. Are you
displaying any other fields from this table on your form? To bind your form to
this table you need to go to the data tab of the properties sheet of the Form
and use the down arrow on the RecordSource line to select the table.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
See my form that I am describing is really a menu that has a few options
(update list, view graphs, view chart) and when i click the update list, I
would like it to show at the bottom when the database was lasted modified.
Each button is linked to either a form or a macro.
 
See my form that I am describing is really a menu that has a few options
(update list, view graphs, view chart) and when i click the update list, I
would like it to show at the bottom when the database was lasted modified.
Each button is linked to either a form or a macro.
Click to expand...

Then you will probably have to use DLookUp() to get your field. Remember, event
though you have been calling it the LastModified date for the *Table*, I'm
pretty sure the method you are using will yield the LastModified date for a
*Record*.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 

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

After Update Event 3
Updating tables when you input new data 0
Navigation Pane Entries 2
Question about Table Date Time Stamps 2
Form showing Time and Date a Table was updated 1
Date change on a FIELD 1
Access Access - Is it possible to repeat fields in a form? 1
Access How to record date/time when specific field is modified in Access 2007 0

Back
Top