Thread: Changing Printer Settings
01-23-04, 08:18 #1Registered User
- Join Date
- Dec 2003
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
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.
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
01-23-04, 08:39 #2Registered User
- Join Date
- Sep 2002
- South Wales
but in vain.?
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