Access won't allow me to use Landscape view in Reports

G

Guest

I created the report in Landscape view and it still opens in Portrait view. I
checked the page setup, and it says that it is Landscape view, but the Print
Preview is Portrait and the pages print in Portrait. What can I do to fix it?
 
G

Guest

I would like to add some new information. First of all, I am using Access
2002. Second of all, this just started happening today. It worked fine
yesterday. I tried unchecking the "Track Name Autocorrect" option and it
still didn't work. Also, I am on a company computer so I'm working off a
server. I can't install any patches, the IT dept would have to do that. And
finally, other people's computers are working fine with the Landscape view.
It is just mine.

Thank you.
 
A

Allen Browne

This database is being shared on a network. Is it split, i.e. you each have
your own copy of the front end database, with the tables attached from a
shared location? If not, you will need exclusive access to fix it, and
probably should involve your IT people rather than do this yourself.

You unchecked the Name AutoCorrect nonsense, which probably did cause the
problem. Good. Now compact the database:
Tools | Database Utilities | Compact.

Next, decompile a copy of the database by entering something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
The compact it again.
After that, open a code window, and compile (Debug menu).

Test. If it is still not fixed, follow the 6 steps for the first symptom in:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 

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

Top