Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Question Unanswered: Changing Printer Settings

    hello, am developing a access application.

    Components of the application

    1) An access form as a front end.
    2) Linked SQL Server tables.
    3) SQL stored procedures which performs the processing.
    4) Access Reports

    Basic Idea

    Using the access front end we invoke the SQL stored procedure which fetches and process data and saves it in a SQL server table. then the data from that table are fetched and are used to generate reports in Access.The reports are generated and converted to PDF format using Acrobat Distiller.

    The Issue:

    there are around 11 reports which have predefined printer settings.The problem I face is once the processing part is over in SQL server.some of the reports's printer settings are getting changed resulting in bad output.How can I handle this.I have also tried changing the settings in run time but in vain.please help.this is a critical issue

  2. #2
    Join Date
    Sep 2002
    South Wales

    Lightbulb but in vain.?

    Please expand.

    Changing reports at runtime requires that they are first opened in design view - Im sure you knew that anyway.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts