Access Reports

[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,

[Hack]

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

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.

[vbgladiator]

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,

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

[Static]

prompt.. hmm.. I know in Excel there is a security setting.. look for it and select allow macros... maybe?

[Protocol]

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

[vbgladiator]

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.

[vbgladiator]

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

thanks,

[Protocol]

@ VbGladiator...

That solution only disables Macros on YOUR pc... it wouldn't affect the clients'. They would still see the messagebox...

[RobDog888]

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.

[vbgladiator]

Protocol, that's fine. I just wanted to know if there's a way. I can tell them to disable it.

[vbgladiator]

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

[Hack]

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?

[vbgladiator]

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

[Hack]

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 serves me correctly, that was the only way that I could solve the problem.

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

Option Compare Database
 
Private Sub Report_Open(Cancel As Integer)
    Me.Printer.Orientation = acPRORLandscape
End Sub

[Hack]

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.

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.

[RobDog888]

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

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.

[Hack]

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

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 )

[RobDog888]

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