For all of you with Paper Size issues

From: cafr2000 (cafr2000_at_discussions.microsoft.com)
Date: 11/10/04


Date: Wed, 10 Nov 2004 10:09:08 -0800

I have had a paper size (Legal/Landscape) issue with a report in a .mde
application for some time. After several unsuccessful attempts to find a
solution in the Newsgroups I pestered Microsoft support until I got the
corrrect answer and again an unsuccessful/no solution. The issue involves
something called prtDevMode, this is supposedly some group of control
characters obtained from the print drivers of the default printer. It does
not matter how you have defined the report before converting to a .mde,
Microsoft claims they cannot change the paper size code in the .mde/runtime
application. This situation exists in ALL versions of ACCESS, there are no
service packs that fix it and it has not been fixed in OFFICE/ACCESS 2003 as
MS Support originally tried to tell me. I don't know all of the background
code of course but it does not make sense that you can design a report and
save the page orientation correctly and not the paper size. I was just
notified by MS Support that they cannot create a hot fix and there will
probably not be anything done to correct this. They offered another soultion,
they made reference to some code that will let you set the paper size
programmatically but the catch is it only works in a .mdb. Their solution to
protecting mine and your valuable proprietary source code is to distribute a
password protected .mdb. Now I don't know about any of you but I have gone to
the web and downloaded free password cracking software that is designed
specifically to decode ACCESS passwords and they work very well. Personally I
don't think this is an acceptable solution, I'm sure Microsoft would not
distribute any of their proprietary code this way. I suggest that everyone
that is having an issue with this contact Microsoft support and start a case
regarding this issue. it was my impression that they feel there is not enough
need or concern about this BUG to work on it.



Relevant Pages

  • Re: Stephen Lebans Report2PDF
    ... Please select a different Report to Export ... No matter what I throw (Report or existing Snapshot) at it I get this same ... the mde, and as an external library to one of my projects. ... > With reference to Stephen Lebans interesting report to PDF solution found ...
    (microsoft.public.access.reports)
  • Re: Design not working for reports
    ... Nowhere is this post does it say I'm trying to edit the report in the mde. ... its an mdb test file. ...
    (comp.databases.ms-access)
  • Re: Can one open a report in another mdb? (by RLi)
    ... Check out the TransferDatabase method or action. ... you name the report in the source location (the mdb) ... and the target location (your mde). ...
    (microsoft.public.access.formscoding)
  • Interactive Reporting
    ... I would like to ask your advice on approaching a problem before I ... report that is generated in Excel, ... We would need to produce this MDE from another application, ... or a 'builder' tool if you will. ...
    (comp.databases.ms-access)
  • Re: Interactive Reporting
    ... constraints on the IT environment - basically time constraints based ... flash based interactive report. ... The reason for the 'It must produce and MDE' is due to the userwho ...
    (comp.databases.ms-access)