printer settings

i have inherited an access program.
in this access .exe if i click on file, print, the program prints
automatically to the default printer.
it does not give me a chance to change printers.

for example, if i am in notepad, and click file, then print, a dialog
box pops up & i can change printers, then click print.

anyone know the code to do this in Access 97.

thx so much! :0)

re: printer settings

"purdy" wrote
[color=blue]
> i have inherited an access program.
> in this access .exe if i click on file,
> print, the program prints
> automatically to the default printer.
> it does not give me a chance to change printers.[/color]

msaccess.exe is the Access database software itself, not a program generated
by Access. It may include command line parameters that specify a database to
open. The Access that is executed may be full Access or the Access runtime
support for a developed application.

It might be a good idea to clarify some details, e.g., just what it is that
you are trying to print. On the (main) database window, Print is greyed out
so you can't click it, unless something is selected. An Access database is
not like a Word or Excel document that you'd print.

Larry Linson
Microsoft Access MVP

re: printer settings

It sounds like this print button is part of a customised menu or
toolbar. In access when you create a customised menu/toolbar using the
wizard, the print button option generated always prints directly to the
printer without opening the print dialog box.

There is a way to solve this which I have used successfully -
1. Click customise on the command bars
2. Remove the faulty print option from the custom toolbar.
3. Then drag the print option from the main menu bar (under file) into
the custom tool bar, to the spot where you need it.
4. Once this is done you can click re-set to restore the main menu bar.