Peter Wayne has posted an article I wrote entitled �Automatic Printer Overrides in A5V5" on the Learnalpha.com site. While the article itself is nothing to get excited about, you may find the printer override system in sample database worthy of study.

The article and included sample database illustrate how a developer (or client administrator) can have almost complete control over network printers, without users having to do anything except click a print button.

In a network, for example, you can allow workstation 1 to automatically send print job X to printer 1 where it automatically uses tray 2, whereas the same print job on workstation 2 will automatically go to printer 2 and use tray 3 instead of tray 2. Similarly, on a workstation and print job specific basis you can set the default number of copies to print, set to collate or not, set the pages to scale to 90%, and so on, all without user any intervention, thus reducing user training and foul-ups and increasing productivity. You can also eliminate most if not all print problems you may have when the network has a mixture of operating systems on workstations (and thus very different printer drivers, e.g. Win98 and w2k/XP).

Ray Lyons