PrintPreview messing with DetectIdleTime code ?

[Arno R]

Hi all,
I am using the DetectIdleTime code from MS to shut down an app when not in use for a certain time.
http://support.microsoft.com/?kbid=210297

I use a hidden form FrmDetectIdeTim e with a timer event running the code.
But with some reports after having a printpreview on screen the form gets focus?
When I use code from a menubar like
DoCmd.PrintOut , , , , 2, False
DoCmd.Close
the form gets printed (only a tiny label 'idletime') instead of the report... and the form is closed.

On close of the reports I am asking if the report is printed indeed and restore the screen.with simple code like:
Private Sub Report_Close()
If MsgBox("Is this report printed indeed ?", vbExclamation + vbYesNo, TITEL) = vbYes Then
some updating here ...
End If
DoCmd.Restore
End Sub
Sometimes I see the form FrmDetectIdeTim e having focus, sometime not...

I am thinking the timer-code is messy, buggy or whatever?
I did read some comments about this timercode together with printpreviews.

Now I am considering to use my FrmDetectIdleTi me *only* when working with forms.
So close the form when reports are opened, reopen the form when forms getfocus.

Any thoughts?

Arno R

[Tom van Stiphout]

On Mon, 6 Mar 2006 12:45:09 +0100, "Arno R" <ar***********@ tiscali.nl>
wrote:

MSFT's code is a bit sloppy because it does not use
Screen.ActiveRe port to check for reports. Just add that additional
logic.

-Tom.

Hi all,
I am using the DetectIdleTime code from MS to shut down an app when not in use for a certain time.
http://support.microsoft.com/?kbid=210297

I use a hidden form FrmDetectIdeTim e with a timer event running the code.
But with some reports after having a printpreview on screen the form gets focus?
When I use code from a menubar like
DoCmd.PrintO ut , , , , 2, False
DoCmd.Close
the form gets printed (only a tiny label 'idletime') instead of the report... and the form is closed.

On close of the reports I am asking if the report is printed indeed and restore the screen.with simple code like:
Private Sub Report_Close()
If MsgBox("Is this report printed indeed ?", vbExclamation + vbYesNo, TITEL) = vbYes Then
some updating here ...
End If
DoCmd.Restor e
End Sub
Sometimes I see the form FrmDetectIdeTim e having focus, sometime not...

I am thinking the timer-code is messy, buggy or whatever?
I did read some comments about this timercode together with printpreviews.

Now I am considering to use my FrmDetectIdleTi me *only* when working with forms.
So close the form when reports are opened, reopen the form when forms getfocus.

Any thoughts?

Arno R

[Arno R]

Thanks Tom,
Just added code to check for Screen.ActiveRe port but I am still having the very same problem.
Problem pops up in a lesser frequency but still ....

Now I am considering to use my FrmDetectIdleTi me *only* when working with forms.
So close the form when reports are opened, reopen the form when forms getfocus.

Still considering this.

Arno R
"Tom van Stiphout" <no************ *@cox.net> schreef in bericht news:o2******** *************** *********@4ax.c om... On Mon, 6 Mar 2006 12:45:09 +0100, "Arno R" <ar***********@ tiscali.nl>
wrote:

MSFT's code is a bit sloppy because it does not use
Screen.ActiveRe port to check for reports. Just add that additional
logic.

-Tom.

Hi all,
I am using the DetectIdleTime code from MS to shut down an app when not in use for a certain time.
http://support.microsoft.com/?kbid=210297

I use a hidden form FrmDetectIdeTim e with a timer event running the code.
But with some reports after having a printpreview on screen the form gets focus?
When I use code from a menubar like
DoCmd.PrintOu t , , , , 2, False
DoCmd.Close
the form gets printed (only a tiny label 'idletime') instead of the report... and the form is closed.

On close of the reports I am asking if the report is printed indeed and restore the screen.with simple code like:
Private Sub Report_Close()
If MsgBox("Is this report printed indeed ?", vbExclamation + vbYesNo, TITEL) = vbYes Then
some updating here ...
End If
DoCmd.Resto re
End Sub
Sometimes I see the form FrmDetectIdeTim e having focus, sometime not...

I am thinking the timer-code is messy, buggy or whatever?
I did read some comments about this timercode together with printpreviews.

Now I am considering to use my FrmDetectIdleTi me *only* when working with forms.
So close the form when reports are opened, reopen the form when forms getfocus.

Any thoughts?

Arno R

[david epsom dot com dot au]

The timer code silently forces the timer form to take focus
every time the timer event happens.

DoCmd.PrintOut is always gonna have trouble here, because it
prints the active object. As you have seen, if it prints
while the timer form is the active object, you get the timer
form instead of the report.

You need to stop the timer code before calling DoCmd.PrintOut.
You can start the timer again after calling docmd.printout.

And you should close the specific object, not just whatever
object happens to have focus:

DoCmd.Close acReport, Me.Name
(david)

"Arno R" <ar***********@ tiscali.nl> wrote in message
news:44******** **************@ text.nova.plane t.nl...
Hi all,
I am using the DetectIdleTime code from MS to shut down an app when not in
use for a certain time.
http://support.microsoft.com/?kbid=210297

I use a hidden form FrmDetectIdeTim e with a timer event running the code.
But with some reports after having a printpreview on screen the form gets
focus?
When I use code from a menubar like
DoCmd.PrintOut , , , , 2, False
DoCmd.Close
the form gets printed (only a tiny label 'idletime') instead of the
report... and the form is closed.

On close of the reports I am asking if the report is printed indeed and
restore the screen.with simple code like:
Private Sub Report_Close()
If MsgBox("Is this report printed indeed ?", vbExclamation + vbYesNo, TITEL)
= vbYes Then
some updating here ...
End If
DoCmd.Restore
End Sub
Sometimes I see the form FrmDetectIdeTim e having focus, sometime not...

I am thinking the timer-code is messy, buggy or whatever?
I did read some comments about this timercode together with printpreviews.

Now I am considering to use my FrmDetectIdleTi me *only* when working with
forms.
So close the form when reports are opened, reopen the form when forms
getfocus.

Any thoughts?

Arno R

[Arno R]

"david epsom dot com dot au" <david@epsomdot comdotau> schreef in bericht news:44******** *************** @lon-reader.news.tel stra.net...

The timer code silently forces the timer form to take focus
every time the timer event happens.

DoCmd.PrintOut is always gonna have trouble here, because it
prints the active object. As you have seen, if it prints
while the timer form is the active object, you get the timer
form instead of the report.
I need to print two copies of some reports.
Is there another way to do this besides DoCmd.Printout?
You need to stop the timer code before calling DoCmd.PrintOut.
You can start the timer again after calling docmd.printout.
Yeh, thanks for this idea, but would it still be possible that the form still has focus at that time?

Maybe I might be better off to just close the form FrmDetectIdleTi me before any report is opened.
-- I could reopen the form on any form's activate event.
-- code: If not IsLoaded ("FrmDetectIdle Time") then DoCmd.OpenForm "FrmDetectIdleT ime", , , , , acHidden
And you should close the specific object, not just whatever
object happens to have focus:

DoCmd.Close acReport, Me.Name

I am using the printout-code from a menubar (which is loaded with reports only)
So I was thinking that the code DoCmd.Close would close the report that is currently loaded.
I am not calling the code from the report, so there is no Me.Name (am I missing something?)

Arno R

[david epsom dot com dot au]

>I need to print two copies of some reports.

Is there another way to do this besides DoCmd.Printout?
Not that I know of (or, you could do OpenReport twice).

If you have code to do the printout, I would just add more
code there, rather than adding code to every form, but I'm
not prescriptive.

(david)


"Arno R" <ar***********@ tiscali.nl> wrote in message
news:44******** **************@ text.nova.plane t.nl...

"david epsom dot com dot au" <david@epsomdot comdotau> schreef in bericht
news:44******** *************** @lon-reader.news.tel stra.net... The timer code silently forces the timer form to take focus
every time the timer event happens.

DoCmd.PrintOut is always gonna have trouble here, because it
prints the active object. As you have seen, if it prints
while the timer form is the active object, you get the timer
form instead of the report.
I need to print two copies of some reports.
Is there another way to do this besides DoCmd.Printout?
You need to stop the timer code before calling DoCmd.PrintOut.
You can start the timer again after calling docmd.printout.
Yeh, thanks for this idea, but would it still be possible that the form
still has focus at that time?

Maybe I might be better off to just close the form FrmDetectIdleTi me before
any report is opened.
-- I could reopen the form on any form's activate event.
-- code: If not IsLoaded ("FrmDetectIdle Time") then DoCmd.OpenForm
"FrmDetectIdleT ime", , , , , acHidden
And you should close the specific object, not just whatever
object happens to have focus:

DoCmd.Close acReport, Me.Name

I am using the printout-code from a menubar (which is loaded with reports
only)
So I was thinking that the code DoCmd.Close would close the report that is
currently loaded.
I am not calling the code from the report, so there is no Me.Name (am I
missing something?)

Arno R