Solved

Reports and Access 2000 MDE

Posted on 2004-10-15
13
223 Views
Last Modified: 2013-12-05
I have an Access 2000 Application with about 300 reports It runs on win 98, win 2000 and XP.  The problem I am having is that my users can have any printer there are over 5000 of them. In Access 97 I did not have a problem. Having moved to Access 2000 I am having problems with Win 2000 and XP. The problem comes in when some one prints a report based on a custom paper size it always prints on letter size paper. for example a single colum dot matrix mailing label prints on a ltter size sheet. I have tried setting the reports to the default printer and I have defined a printer called "MyPrinter" and it will work on the development system. When I go to another system and define the same printer with the same name it comes up letter. I need to know how to make it use the custome paper sizes. I have routines that use the CreateForm and SetForm API to create the form on the printer. The printer drivers are installed locally. Any advice or ideas would be greatly appreciated.

Art
0
Comment
Question by:Deadcats
  • 5
  • 4
  • 2
  • +1
13 Comments
 
LVL 39

Expert Comment

by:stevbe
ID: 12323833
Try turning off the "Name Auto Correct" option.
This is a know bug in A2K, I think it was fixed by a service pack so make sure you are up to date.

Steve
0
 

Author Comment

by:Deadcats
ID: 12324864
Steve,

thanks done that got the tshirt and I sent a postcard. I am up to date.

Thanks
Art
0
 
LVL 3

Expert Comment

by:StuartSanders
ID: 12327024
I don't know if this is of any use.  

http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM

What you might be able to do is store the reports page settings (reportname, usersize, length and width) in a table and then programmatically check them during report load and change them.  I haven't tried this, as I am using Access 2002 mostly now and it uses a different method of controlling the printer.

Stuart
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 39

Expert Comment

by:stevbe
ID: 12329346
I don't think you are going to be able to use Ken Getz's code because IIRC you would need to open the report in design mode which you can not do in an mde.

If it does not work correctly in the mdb also then I would suggest that you open with /decompile close. Create a new databse and pull everything in, not that I know his will fix your issue but it is worth a try.

Steve
0
 

Author Comment

by:Deadcats
ID: 12339657
Hello,

Thanks to everyone that has offed advice so far I have not had any luck with this issue. I would like to through in a couple of other things I have found to be happening.

With an MDB this MDB will become the MDE file Anyway I have the MDB on Computer A open the report in design set the paper size to my custom form size. I then copy it to Computer B and open the report in design mode and the paper size is now letter size. I have Autocorrect turned off and I have SP-3 installed. I'm lost does anyone have any ideas?

Thanks
Art
0
 
LVL 39

Expert Comment

by:stevbe
ID: 12342315
if you open it again on computer A is it still set to the custom paper. Is the printer you are using as default on computer B the same as A, if not, does it support the custom paper size anyway?

Steve
0
 

Author Comment

by:Deadcats
ID: 12342756
Steve,
If I open it on Computer A it the paper size stays as I set it. I have the printer set as the default printer and the printer does support custom paper sizes and the paper size is supported by the printer.


Art
0
 
LVL 3

Expert Comment

by:StuartSanders
ID: 12343633
Does the printer on computer B have the same default settings.  Unfortunately most printers when installed default to Letter size.

Stuart
0
 

Author Comment

by:Deadcats
ID: 12346244
Hi Stuart,

Yes both priners have the same default settings in fact the printer that I am using to just get this working is the same printer. The printer is connected to a third computer and I am accessing it over the network. I do have the drivers for the printer installed locally and accessing through a local port such as \\Pserver\epson.

Art
0
 
LVL 39

Expert Comment

by:stevbe
ID: 12348184
I just ran across an oddity in printing from mde in 2003, on first print it does portrait even though all settings say landscape and any subsequent prints do come out in ladscape, even in susequent sessions. I have not found a fix as this is not critical for me yet, if I find something I will be sure to let you know.

Does your issue go away on a "second" try of the same report ... open in preview, close and open in preview again?

Steev
0
 

Author Comment

by:Deadcats
ID: 12348596
Hi Steve

Unfortunatly mine does not go to the correct size on the second or any other print

thanks
Art
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12905346
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Send Meeting Request from Shared Mailbox 3 60
MkDir to create multiple folder and subfolder 2 41
Problem with vba code 4 44
Comparison query - 4 columns 9 26
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question