Report Run Time

[Guest]

Is there a function that would show the time that a report was run? Here's
what I mean....

I currently use the built-in "Date and Time" in the page footer. This is
fine except it updates when the report is printed. I want to show & print
the exact moment the report is run.

Thanks
LeAnn

 

[Duane Hookom]

Can you explain the difference between "when the report is printed" and
"exact moment the report is run"?

 

[Guest]

The user may display the report on the screen for some minutes before
printing. I have some time calculations for the detail records and total by
group. If the last record of a group doesn't have a "closure" time, the
calcuation uses the now function (done in the query). The page footer
date/time is used to validate the calculation for these records; however if
the user doesn't print it right away, there can be a big difference between
the last detail record (and subTotal) calculation and the page footer
date/time.

In mid explanation, I just figured out my problem but I still need a
solution.........

My detail record calculation is updating when printing but my subTotal
calculation is not. The detail calc is a calculated field from the query.
The subTotal is an unbound control that uses a custom function. The function
receives the value of a different bound, hidden calculated field from the
detail section. This hidden control is updating but my unbound control isn't
updating on print. I've tried setting running total property, passing the
value by ref rather than val and adding a separate unbound control to sum up
the hidden values and pass that to the function. Nothing is working. Any
suggestions? Hopefully I am making sense.
Here is the orginal subTotal calculation:
=DaysHrs(Sum([TDur])) (TDur is total seconds)

 

[Duane Hookom]

I'm not sure what your calcs are but I believe the Open event will occur
when the user switches from preview to print. Perhaps you can use that
information.
--
Duane Hookom
MS Access MVP

The user may display the report on the screen for some minutes before
printing. I have some time calculations for the detail records and total
by
group. If the last record of a group doesn't have a "closure" time, the
calcuation uses the now function (done in the query). The page footer
date/time is used to validate the calculation for these records; however
if
the user doesn't print it right away, there can be a big difference
between
the last detail record (and subTotal) calculation and the page footer
date/time.

In mid explanation, I just figured out my problem but I still need a
solution.........

My detail record calculation is updating when printing but my subTotal
calculation is not. The detail calc is a calculated field from the query.
The subTotal is an unbound control that uses a custom function. The
function
receives the value of a different bound, hidden calculated field from the
detail section. This hidden control is updating but my unbound control
isn't
updating on print. I've tried setting running total property, passing the
value by ref rather than val and adding a separate unbound control to sum
up
the hidden values and pass that to the function. Nothing is working.
Any
suggestions? Hopefully I am making sense.
Here is the orginal subTotal calculation:
=DaysHrs(Sum([TDur])) (TDur is total seconds)

Can you explain the difference between "when the report is printed" and
"exact moment the report is run"?

 

[Guest]

I think I need to use Requery but I'm not sure on what or where. I've tried
several different things but no success.

The calc that isn't updating is not very complicated. It just takes the
totals seconds passed to it and transforms it into dd:hh:mm:ss format. I
simply need it to update (refresh) on print.

=DaysHrs(Sum([TDur])) (TDur is total seconds)

Now TDur is the hidden calc from the query and is more complicated but it
is updating on print. But the unbound text control with the calc above isn't.

I'm not sure what your calcs are but I believe the Open event will occur
when the user switches from preview to print. Perhaps you can use that
information.
--
Duane Hookom
MS Access MVP

The user may display the report on the screen for some minutes before
printing. I have some time calculations for the detail records and total
by
group. If the last record of a group doesn't have a "closure" time, the
calcuation uses the now function (done in the query). The page footer
date/time is used to validate the calculation for these records; however
if
the user doesn't print it right away, there can be a big difference
between
the last detail record (and subTotal) calculation and the page footer
date/time.

In mid explanation, I just figured out my problem but I still need a
solution.........

My detail record calculation is updating when printing but my subTotal
calculation is not. The detail calc is a calculated field from the query.
The subTotal is an unbound control that uses a custom function. The
function
receives the value of a different bound, hidden calculated field from the
detail section. This hidden control is updating but my unbound control
isn't
updating on print. I've tried setting running total property, passing the
value by ref rather than val and adding a separate unbound control to sum
up
the hidden values and pass that to the function. Nothing is working.
Any
suggestions? Hopefully I am making sense.
Here is the orginal subTotal calculation:
=DaysHrs(Sum([TDur])) (TDur is total seconds)

Can you explain the difference between "when the report is printed" and
"exact moment the report is run"?
--
Duane Hookom
MS Access MVP

Is there a function that would show the time that a report was run?
Here's
what I mean....

I currently use the built-in "Date and Time" in the page footer. This
is
fine except it updates when the report is printed. I want to show &
print
the exact moment the report is run.

Thanks
LeAnn

 

[Duane Hookom]

Can you move the more complicated hidden calc from the query to the report?
--
Duane Hookom
MS Access MVP

I think I need to use Requery but I'm not sure on what or where. I've
tried
several different things but no success.

The calc that isn't updating is not very complicated. It just takes the
totals seconds passed to it and transforms it into dd:hh:mm:ss format.
I
simply need it to update (refresh) on print.

=DaysHrs(Sum([TDur])) (TDur is total seconds)

Now TDur is the hidden calc from the query and is more complicated but it
is updating on print. But the unbound text control with the calc above
isn't.

I'm not sure what your calcs are but I believe the Open event will occur
when the user switches from preview to print. Perhaps you can use that
information.
--
Duane Hookom
MS Access MVP

The user may display the report on the screen for some minutes before
printing. I have some time calculations for the detail records and
total
by
group. If the last record of a group doesn't have a "closure" time,
the
calcuation uses the now function (done in the query). The page footer
date/time is used to validate the calculation for these records;
however
if
the user doesn't print it right away, there can be a big difference
between
the last detail record (and subTotal) calculation and the page footer
date/time.

In mid explanation, I just figured out my problem but I still need a
solution.........

My detail record calculation is updating when printing but my subTotal
calculation is not. The detail calc is a calculated field from the
query.
The subTotal is an unbound control that uses a custom function. The
function
receives the value of a different bound, hidden calculated field from
the
detail section. This hidden control is updating but my unbound control
isn't
updating on print. I've tried setting running total property, passing
the
value by ref rather than val and adding a separate unbound control to
sum
up
the hidden values and pass that to the function. Nothing is working.
Any
suggestions? Hopefully I am making sense.
Here is the orginal subTotal calculation:
=DaysHrs(Sum([TDur])) (TDur is total seconds)



:

Can you explain the difference between "when the report is printed"
and
"exact moment the report is run"?
--
Duane Hookom
MS Access MVP

Is there a function that would show the time that a report was run?
Here's
what I mean....

I currently use the built-in "Date and Time" in the page footer.
This
is
fine except it updates when the report is printed. I want to show &
print
the exact moment the report is run.

Thanks
LeAnn

 

[Guest]

No, not without a lot of red tape and re-validations. I played with it but
couldn't get the calculations to work when I moved them to the report. My
solution: print the report without the user viewing it. Problem solved!

Thanks for your input.

Can you move the more complicated hidden calc from the query to the report?
--
Duane Hookom
MS Access MVP

I think I need to use Requery but I'm not sure on what or where. I've
tried
several different things but no success.

The calc that isn't updating is not very complicated. It just takes the
totals seconds passed to it and transforms it into dd:hh:mm:ss format.
I
simply need it to update (refresh) on print.

=DaysHrs(Sum([TDur])) (TDur is total seconds)

Now TDur is the hidden calc from the query and is more complicated but it
is updating on print. But the unbound text control with the calc above
isn't.

I'm not sure what your calcs are but I believe the Open event will occur
when the user switches from preview to print. Perhaps you can use that
information.
--
Duane Hookom
MS Access MVP

The user may display the report on the screen for some minutes before
printing. I have some time calculations for the detail records and
total
by
group. If the last record of a group doesn't have a "closure" time,
the
calcuation uses the now function (done in the query). The page footer
date/time is used to validate the calculation for these records;
however
if
the user doesn't print it right away, there can be a big difference
between
the last detail record (and subTotal) calculation and the page footer
date/time.

In mid explanation, I just figured out my problem but I still need a
solution.........

My detail record calculation is updating when printing but my subTotal
calculation is not. The detail calc is a calculated field from the
query.
The subTotal is an unbound control that uses a custom function. The
function
receives the value of a different bound, hidden calculated field from
the
detail section. This hidden control is updating but my unbound control
isn't
updating on print. I've tried setting running total property, passing
the
value by ref rather than val and adding a separate unbound control to
sum
up
the hidden values and pass that to the function. Nothing is working.
Any
suggestions? Hopefully I am making sense.
Here is the orginal subTotal calculation:
=DaysHrs(Sum([TDur])) (TDur is total seconds)



:

Can you explain the difference between "when the report is printed"
and
"exact moment the report is run"?
--
Duane Hookom
MS Access MVP

Is there a function that would show the time that a report was run?
Here's
what I mean....

I currently use the built-in "Date and Time" in the page footer.
This
is
fine except it updates when the report is printed. I want to show &
print
the exact moment the report is run.

Thanks
LeAnn