If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do i show the date a report or query was last run?
I am using Access 2007.
I have several reports and queries which are run on a fairly regular basis. What I would like to be able to do is show the date the report was last run. Is there any way I can show this on a form which would show the name of the report or query and the date it was last run. Thank you for any help you can give me. Sean Bishop |
#2
|
|||
|
|||
How do i show the date a report or query was last run?
The easiest way I know is to have whatever triggers your report to also
append a record to a table and to use DLokup on form to display Max dated record. -- Build a little, test a little. "Sean Bishop" wrote: I am using Access 2007. I have several reports and queries which are run on a fairly regular basis. What I would like to be able to do is show the date the report was last run. Is there any way I can show this on a form which would show the name of the report or query and the date it was last run. Thank you for any help you can give me. Sean Bishop |
#3
|
|||
|
|||
How do i show the date a report or query was last run?
If you are starting your report from a form (like you should be doing), add
a datefield to the underlying data table and a line in your code will save the run date to that field overwriting the previous entry. Something as simple as: Me.txtDateField = Date should work, assuming txtDateField is the name of the textbox, with that data. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Sean Bishop" wrote in message ... I am using Access 2007. I have several reports and queries which are run on a fairly regular basis. What I would like to be able to do is show the date the report was last run. Is there any way I can show this on a form which would show the name of the report or query and the date it was last run. Thank you for any help you can give me. Sean Bishop |
Thread Tools | |
Display Modes | |
|
|