Hidden Forms

[Lou Civitella]

I have a hidden form that runs in the background of my Access 2003 database.
The form has a timer event that is triggered every two minutes. Sometimes
when I try to print a report that I already have displayed on the screen it
prints the hidden form instead. It seems that when I right click and choose
print the hidden form has the focus at that time and it prints the form
instead of the report.

Does this sound like a possibility? How can I prevent this from happening?
Is there some other way to have a process run in the background without this
scenario happening?

Thanks In Advance,
Lou

 

[John W. Vinson]

I have a hidden form that runs in the background of my Access 2003 database.
The form has a timer event that is triggered every two minutes. Sometimes
when I try to print a report that I already have displayed on the screen it
prints the hidden form instead. It seems that when I right click and choose
print the hidden form has the focus at that time and it prints the form
instead of the report.

I'd suggest NOT using rightclick and print - instead, program command buttons
to explicitly print exactly what you want printed (typically this will be a
Report). Otherwise you really have no way to control which form has the focus.

 

[Lou Civitella]

Hi John,

The reason for the hidden form is that it checks the system time and
displays a message to the user that they must back out or else it will
Access will close by itself. We do this for so the backend database will get
backed up. We do have on all our report forms the option to print to either
the screen or the printer but a lot of our users like to print to the screen
first then just right click and click print, but then this problem occurs.
Do you know of a better way to have a message displayed to the user to back
out of the application and/or close it all together?

Thanks Again,
Lou

 

[John W. Vinson]

Hi John,

The reason for the hidden form is that it checks the system time and
displays a message to the user that they must back out or else it will
Access will close by itself. We do this for so the backend database will get
backed up. We do have on all our report forms the option to print to either
the screen or the printer but a lot of our users like to print to the screen
first then just right click and click print, but then this problem occurs.
Do you know of a better way to have a message displayed to the user to back
out of the application and/or close it all together?

Other than trapping the form's Click event, I can't think of anything. There
isn't a Form "On Format" event as there is for reports.