What would you do?

I developed a large Access 97 application (over 400 forms and 300 reports) that is being used by over 200 happy companies. Access 97 is fantastic and my 6 employees are making a very good living from it! I've patiently waited for 2007 SP1 and the runtime but unfortunately there are still some major bugs. My one big complaint is the 2007 bug that prevents printer setup settings from being saved to a report. I must either devise a way of switching the default printer to the user's intended device and then switch it back again after printing, or else continue to wait (forever) for MS to fix the bug. What would you do?

Apr 25 '08 #1

Subscribe Post Reply

1132

puppydogbuddy

1,923

Expert 1GB

I developed a large Access 97 application (over 400 forms and 300 reports) that is being used by over 200 happy companies. Access 97 is fantastic and my 6 employees are making a very good living from it! I've patiently waited for 2007 SP1 and the runtime but unfortunately there are still some major bugs. My one big complaint is the 2007 bug that prevents printer setup settings from being saved to a report. I must either devise a way of switching the default printer to the user's intended device and then switch it back again after printing, or else continue to wait (forever) for MS to fix the bug. What would you do?

Try the following tip from www.aadconsulting.com

Tip and Code Sample: Switching Printers from within your MS Access Application

Fellow Access developer, Mark Plumpton, of customdata.co.nz, has kindly provided sample code for easily switching printers on the fly while printing Access reports, with code as simple as this...

Expand|Select|Wrap|Line Numbers

    SaveDefaultPrinter

     DefaultPrinter = "HP Laserjet (A3)"

     DoCmd.OpenReport "rptTest", acViewNormal

   RestoreDefaultPrinter

Download these demo Access97/2000 databases, which include a class module that performs the function of listing and switching default printers.

http://www.aadconsulting.com/printers.zip

The code is also an excellent example of how you can use classes in your MS Access applications.

Apr 26 '08 #2

missinglinq

3,532

Expert 2GB

"What would you do?"

See if I could find someone willing to swap your copy of v2007 for a copy of v2003 (SP2)!

;0)>

Apr 26 '08 #3

by: thecrow | last post by:

Alright, what the hell is going on here? In the following code, I expect the printed result to be: DEBUG: frank's last name is burns. Instead, what I get is: DEBUG: frank's last name is...

PHP

220

What's better about Ruby than Python?

by: Brandon J. Van Every | last post by:

What's better about Ruby than Python? I'm sure there's something. What is it? This is not a troll. I'm language shopping and I want people's answers. I don't know beans about Ruby or have...

Python

699

Python syntax in Lisp and Scheme

by: mike420 | last post by:

I think everyone who used Python will agree that its syntax is the best thing going for it. It is very readable and easy for everyone to learn. But, Python does not a have very good macro...

Python

rotor replacement

by: Reed L. O'Brien | last post by:

I see rotor was removed for 2.4 and the docs say use an AES module provided separately... Is there a standard module that works alike or an AES module that works alike but with better encryption?...

Python

137

What is different with Python ?

by: Philippe C. Martin | last post by:

I apologize in advance for launching this post but I might get enlightment somehow (PS: I am _very_ agnostic ;-). - 1) I do not consider my intelligence/education above average - 2) I am very...

Python

Troubles with exception::what()

by: Dario | last post by:

The following simple program behaves differently in Windows and Linux . #include <stdexcept> #include <iostream> #include <string> using namespace std; class LogicError : public logic_error {...

C / C++

125

What so special about PostgreSQL and other RDBMS?

by: Sarah Tanembaum | last post by:

Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from...

Microsoft SQL Server

Table Layout and What's Wrong With it

by: Neal | last post by:

Patrick Griffiths weighs in on the CSS vs table layout debate in his blog entry "Tables my ass" - http://www.htmldog.com/ptg/archives/000049.php . A quite good article.

HTML / CSS

121

What IDE are you using?

by: typingcat | last post by:

First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode...

PHP

What is .net

by: Midnight Java Junkie | last post by:

Dear Colleagues: I feel that the dumbest questions are those that are never asked. I have been given the opportunity to get into .NET. Our organization has a subscription with Microsoft that...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Similar topics