Access Reports

Printable View

Dec 20th, 2005, 11:27 AM
vbgladiator

Access Reports

Hey,

I have a report in Access 2003. Everytime I change the page orientation to landscape and save the report it changes back to portrait next time I open the report. Does anyone else experienced this?

Thanks,
Dec 20th, 2005, 11:38 AM
Hack

Re: Access Reports

Quote:

Originally Posted by vbgladiator

Hey,

I have a report in Access 2003. Everytime I change the page orientation to landscape and save the report it changes back to portrait next time I open the report. Does anyone else experienced this?

Thanks,

Ohhhhh yes I have, only I experienced it in Access 2000, and I see it still hasn't been fixed :rolleyes:

The one and only way I ever resolved this problem was to delete the report, and recreate it as Landscape. It appears that the report will default back to the way you created it, and there never was anything that I found that fixed it.
Dec 20th, 2005, 11:39 AM
vbgladiator

Re: Access Reports

Also,
Access 2003 puts this annoying prompt asking user if they want to enable macros if your file contains code.
Is there any way to prevent that message box from appearing?

Thanks,
Dec 20th, 2005, 11:40 AM
Static

Re: Access Reports

yes... now.. trying to remember how to fix it is another story.

can u set it in code? (On report open?)

but I think u have to open rpt in design view.. switch to landscape.. view report.. then save it?? it was something odd...
Dec 20th, 2005, 11:43 AM
Static

Re: Access Reports

prompt.. hmm.. I know in Excel there is a security setting.. look for it and select allow macros... maybe?
Dec 20th, 2005, 11:45 AM
Protocol

Re: Access Reports

The Macro messagebox is a way of warning users that there could be harmful code within the database... so I doubt it would be possible to put extra code within the database to hide the detection of code in the database...
Dec 20th, 2005, 11:50 AM
vbgladiator

Re: Access Reports

well, if you're writing an application for a client, you don't want them to be looking at it every single time they open it.
I was hoping there is some setting to disable it.
Dec 20th, 2005, 11:54 AM
vbgladiator

Re: Access Reports

never mind, it's under tools-macros-security.

thanks,
Dec 20th, 2005, 11:57 AM
Protocol

Re: Access Reports

@ VbGladiator...

That solution only disables Macros on YOUR pc... it wouldn't affect the clients'. They would still see the messagebox...
Dec 20th, 2005, 01:33 PM
RobDog888

Re: Access Reports

Quote:

Originally Posted by Static

yes... now.. trying to remember how to fix it is another story.

can u set it in code? (On report open?)

but I think u have to open rpt in design view.. switch to landscape.. view report.. then save it?? it was something odd...

Yes, this is the way. When the report is in design view and you set the orientation of the print and save the report it will remain as part of the report and not a temporary printer setting.
Dec 20th, 2005, 01:48 PM
vbgladiator

Re: Access Reports

Protocol, that's fine. I just wanted to know if there's a way. I can tell them to disable it.
Dec 20th, 2005, 01:53 PM
vbgladiator

Re: Access Reports

Quote:

Yes, this is the way. When the report is in design view and you set the orientation of the print and save the report it will remain as part of the report and not a temporary printer setting.

I tried doing that and it's the same problem. as soon as I close the report and re-open it, it's set back to portrait. Damn....
Dec 20th, 2005, 02:33 PM
Hack

Re: Access Reports

Quote:

Originally Posted by vbgladiator

I tried doing that and it's the same problem. as soon as I close the report and re-open it, it's set back to portrait. Damn....

Did you try recreating it and setting it a landscape at that point?
Dec 20th, 2005, 02:35 PM
vbgladiator

Re: Access Reports

no, I was trying to avoid having to do that. I guess I'll try that next.
Dec 20th, 2005, 02:37 PM
Hack

Re: Access Reports

Quote:

Originally Posted by vbgladiator

no, I was trying to avoid having to do that. I guess I'll try that next.

It has been a while since I've dealt with Access reports, but if my failing memory :sick: serves me correctly, that was the only way that I could solve the problem.
Dec 21st, 2005, 06:11 AM
RobDog888

Re: Access Reports
You can also use code to set the orientation for the report printing upon its opening. That will definately solve the issue but will require them to enable macros too.
VB Code:
```
Option Compare Database
 
Private Sub Report_Open(Cancel As Integer)
    Me.Printer.Orientation = acPRORLandscape
End Sub
```
Dec 21st, 2005, 07:15 AM
Hack

Re: Access Reports
Quote:
Originally Posted by RobDog888

You can also use code to set the orientation for the report printing upon its opening. That will definately solve the issue but will require them to enable macros too.

VB Code:

Option Compare Database

Private Sub Report_Open(Cancel As Integer)
Me.Printer.Orientation = acPRORLandscape
End Sub
I believe he has already tried that with very mixed results. I also, back in my Access reports days, tried that, it sometimes it worked and sometimes it didn't. The one and only way I ever got landscape to print consistently was to set landscape as default at the time I created the report. Programmatically changing it was hit and miss at best.
Dec 21st, 2005, 07:30 AM
RobDog888

Re: Access Reports

I have tried it before I posted and it worked fine for me. :D

There is another way I believe. I have a db around my system somewhere that has some cool API methods for doing this. Tomorrow I will look for it.
Dec 21st, 2005, 07:33 AM
Hack

Re: Access Reports

Quote:

Originally Posted by RobDog888

I have tried it before I posted and it worked fine for me. :D

There is another way I believe. I have a db around my system somewhere that has some cool API methods for doing this. Tomorrow I will look for it.

If they do work, please post them (and God knows I could have used you 5 years ago when I was going through this :D )
Dec 21st, 2005, 07:34 AM
RobDog888

Re: Access Reports

I will. I remember that it used a few APIs and the printer dev stuff.