Code does not work after converting MDB to MDE

[Rohit Thomas]

Hello all,

I'm using the code described in KB article(see link below)
to print a report on legal paper in landscape mode,
however the code no longer works when I convert the
database the Access 97 database from MDB to MDE. Any
thoughts on how I get around this?

Thanks,
Rohit Thomas

http://support.microsoft.com/default.aspx?scid=kb;en-
us;302650&Product=acc97

 

[Nikos Yannacopoulos]

Rohit,

The code fails at the following statement:

DoCmd.OpenReport strName, acDesign

when run in an .mde, because by definition an .mde does not allow for
objects like forms and reports to be opened in design view, like this line
is trying to do.

Regrettably I have no solution to offer.

Nikos

 

[Albert D. Kallal]

Why do you need to use code?

Why not just design the report..and set the printer in landscape mode..and
then save the report?

Perhaps you don't realize that the landscape settings..and layout is saved
with the report.

While looking at the report in design mode...simply go

File->page setup..and make your settings. You then simply save the report.

I see no reason at all to use a bunch of code here...

 

[Rohit Thomas]

Albert,

I should have been more specific. I need to have the
report always print\preview on legal size paper. That's
why I used the code. I can't seem to get the "legal"
setting to stick without the code.

Rohit

 

[Albert D. Kallal]

Albert,

I should have been more specific. I need to have the
report always print\preview on legal size paper. That's
why I used the code. I can't seem to get the "legal"
setting to stick without the code.

Then likely..you are experiencing a bug in ms-access. This is a known and
common bug.

The temp fix is to turn off track-auto correct.

however, the *real* fix is to install office sr1 update. this assumes you
are running a2000......

You can read the following......

ACC2000: Lost Printer Settings When Name AutoCorrect Is Enabled

http://support.microsoft.com/default.aspx?scid=kb;en-us;240826