Disable the messenger service? 1

[gwilton]

Does anyone know how to turn off the Windows 2000 Messenger Service when printing a report from Access 2000. Some of the reports are made up of seperate forms (graphs) and report pages, as many as 11. It can get quite annoying to keep clicking on the message box after each page. We don't want to turn off the messenger service completely but maybe there is someway I can disable it before printing and enable it after the job is complete.

Thanks,
Greg

 

[jfischer]

What do you mean by "Messenger Service"? What kinds of messages do you get when you print from Access 2000?

If your report generation process runs action queries that issue messages, those can be temporarily disabled in VBA with the statements

DoCmd.SetWarnings False

to turn them off, and

DoCmd.SetWarnings True

to set them back on again.

 

[gwilton]

Thanks for the reply.

We are using MS NT Server 4.0 for our network and it provides a printer message after every print job. This is a service called "Messenger" running under Windows 2000. The service can be terminated at the server side but that would terminate all network messages. I was wondering if anyone knows whether this can be turned off using VBA commands and then turned back on after the reports are printed.

 

[JoaoTL]

Hi, try this

http://www.mvps.org/access/api/api0037.htm

Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access

 

[jfischer]

Thanks for the additional information. If I understand you correctly, you have a Windows 2000 workstation attached to a Microsoft network hosted by an NT 4.0 server. The NT 4.0 server is handling the printer traffic and is issuing printer-related messages about print jobs submitted from the Win2K workstation back to the Win2K workstation.

These messages are called "administrative alerts" and are generated by the server system. There is no way from a workstation to influence the Alerter or Messenger services without some system-level coding on both the server and client sides.

When these alerts relate to printing, they are generally warnings about printer problems. NT 4.0 servers maintain a list of alert recipients based on user or computer name.

For alerts to be sent, the Alerter and Messenger services must be running on the computer originating the alert. For alerts to be received, the Messenger service must be running on the destination computer.

If you do not need to receive these Alerts, simply Stop the Messenger service on your Win2K workstation. Or, you may need to get with your network administrator to have your Win2K workstation removed from this list if you do not need to see these messages.

 

[gwilton]

Thanks for the reply. I was afraid of that. Turning off the messenger service at the workstation would result in no messages getting through to that user. I was hoping that there was someway to turn it off temporarily (by using code) and than turn it back on when the job was finished. I guess I can't have everything. Mayber we will have to designate one workstation to print the reports allowing us to manually turn off the messenger service and than turn it back on.