Changing Focus to Print Dialog
Quote:
>-----Original Message-----
>Hi, I have a program which prints various access 2000
reports, I use the
>accApp.DoCmd.RunCommand acCmdPrint
>method to print the report. The problem is that access is
not visible while
>it works on the reports, and the above command is
internal to accesss. When
Quote:
>it executes I have to tab across to access to see the
print dialog (which
>all works correctly). How can I automate this tabbing
across to the print
>dialog, I tried doing
>accApp.Visible = True
>accApp.DoCmd.RunCommand acCmdPrint
>accApp.Visible = False
>but this showed the whole access window, not just the
print dialog. I assume
Quote:
>it must be possible to achieve this because I can tab to
it and not see the
>whole application, but how do I do this from code?
>cheers,
>dave.
>.
You could create a Access form that opens and lets the
user choose from your list of reports. You would call
accApp.DoCmd.OpenForm "ReportListForm" 'etc.
from your application. Then your ReportListForm could use
a listbox, combobox, or checkboxes that allows the user to
select the reports to print.
