Max Sherman
max at sherman.org.uk
Sat Jan 28 01:30:20 CST 2006
Ps. I have changed the subject. I had a similar problem yesterday. It was because the default network printer had been unplugged and the Access Report just bombed out after a few seconds. Fortunately, it was easy to spot as the user had been using the same report only a few minutes earlier with no problems and the only other change to the system was me unplugging the printer to move it to a new location. To avoid this, I now have a pop-up form which asks users to select a printer from those available. Regards Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jürgen Welz Sent: 26 January 2006 17:16 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Outlook automation - use a template for a message Dealing with the nITzis for a couple days now on something that might be of interest. I had a couple users who couldn't open a report and Access throws a '2501 The OpenReport action was canceled.' I have functions that change default sql parameters based on the user and their office and IT sets up rights to folders and I've got my own security running and some data if from various sources that require drivers. It turns out that these users can't even use File - Print Preview on a plain lookup table. Opening any preview from the database window results in a silent failure. Opening any report from the Immediate window with a docmd OpenReport produces the error message. IT tells me it is my problem because Access throws an error on my button click event. The problem is that, apparently unlike other MS Office applications, Access uses some kind of print driver information to generate a print preview. The problem is the same as when no printer is installed. In this case, it is a problem with a Canon printer driver. It took me nearly two hours to track down this problem a year ago when IT added a paper tray to one of the other office printers. It was a particularly complex and convoluted report that a user was trying to open so there were dozens of things to check and I finally got permission to log in the user to track down the problem. Lacking the basic ability to create a table with two entries and to select Print Preview from the file menu, IT asked me to send them a new MDB that demonstrated this problem outside of my application. Of course Outlook blocked the attachment so I was asked to rename the file extension. Their security prevents rename of file extension from Explorer (though it's easy enough in VBA and though I can no longer get a DOS window, I can shell a 'ren' command). We finally have zip capability and I think these email OK. Being bloody minded, I ask them how to rename the file extension and send an html link to the file instead. This is ongoing. In the mean time, I tell the users to select any other printer in the office as their default printer. Ciao Jürgen Welz Edmonton Alberta jwelz at hotmail.com _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com