Code does not work after converting MDB to MDE


R

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
 
Ad

Advertisements

N

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
 
A

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...
 
R

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
 
Ad

Advertisements

A

Albert D. Kallal

Rohit Thomas said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top