Formatting of a Report from Switchboard

[MikeFord]

I've got a report which is set up to appear from a switchboard.

I've used a maximise macro (On Open) to ensure that it appears on a full screen; however, the zoom display is set to Fit whereas I want it to display at 100%, so that users have use of the scroll bars.

Also, is it possible to put a command button on the report itself so that users can return to the switchboard...at the moment it seems the only way of returning to the switchboard is to click on the close button.

Any ideas? I'm a beginner who's just found the macro button so please take it easy on me!! Thanks.

 

[boblarson]

In the On Open Event of the Report, put this code after the DoCmd.Maximize:

DoCmd.RunCommand acCmdZoom100

 

[MikeFord]

Thanks very much for your quick response Bob. I did plug your command into Code Builder and tried it in a Macro too; unfortunately, it comes back with a run time error that it is not available at this time!

Can I get round this or is it tough! Thanks again

 

[boblarson]

Try putting it in the On Format event of the Detail Section.

 

[MikeFord]

Sorry Bob, I'm a bit of a novice, can you just clarify where the Detail Section is as I can't seem to find it? Thanks.

 

[boblarson]

 

[MikeFord]

I've just got there myself actually but it says that it's still not available. Any other ideas?

By the way, I'm on Access 2002.

 

[boblarson]

I just tried doing it on every event and I'm not finding it. Sorry, I seriously thought I'd seen it used before. Keep looking and Google it. Something is bound to come up.

 

[MikeFord]

Thanks for trying anyway! I'll give Google a go.

 

[Thooom]

I've got a report which is set up to appear from a switchboard.

I've used a maximise macro (On Open) to ensure that it appears on a full screen; however, the zoom display is set to Fit whereas I want it to display at 100%, so that users have use of the scroll bars.

Also, is it possible to put a command button on the report itself so that users can return to the switchboard...at the moment it seems the only way of returning to the switchboard is to click on the close button.

Any ideas? I'm a beginner who's just found the macro button so please take it easy on me!! Thanks.

Have you tried setting the report's Auto Resize property to No? I just tried this on a couple of reports (that automatically open up for me resized to fit in the active window....too small to read), and setting Auto Resize to NO allows the report to open up at 100% size. At least on my system.

If you haven't already, give it a shot, if this is what you're looking for.



Thooom

 

[MikeFord]

Thanks that's done the trick.

By the way, do you know if it's possible to put a command button on your report so users can return back to the switchboard.

 

[Thooom]

Thanks that's done the trick.

By the way, do you know if it's possible to put a command button on your report so users can return back to the switchboard.

Yes and no. Access will let you add a command button to a report, and it'll show up on the page, but you can't really make it do anything useful.

Instead, just write a line of VBA code in the OnClose event for the report:
DoCmd.OpenForm "MySwitchboardForm"

It's not a button, but a user will usually just click the close button of a report window anyway....and with this code, it'll automatically open up whatever form you want when the report is closed. Let us know if this does it for you.



Thooom

 

[MikeFord]

For some reason, it already returns to switchboard on close...not sure why now, as I haven't added anything to the Report poperties...might this not happen then in certain circumstances!?!

One thing I did do though was in the properties of the switchboard added a Restore Macro which ensures that the switchboard reappears in its original size.

 

[Thooom]

For some reason, it already returns to switchboard on close...not sure why now, as I haven't added anything to the Report poperties...might this not happen then in certain circumstances!?!

One thing I did do though was in the properties of the switchboard added a Restore Macro which ensures that the switchboard reappears in its original size.

Well, unless I'm missing something, that's the only "normal" thing that should happen. You said you open the report from a switchboard. The report opens (it's just another window on top of the switchboard form). You close the report (you close the window on top of the switchboard form). The switchboard is visible again. Very much expected behavior. I really, really think a _button_ to close the report is unnecessary (as well as being impossible in Access). Are you home free yet?


Thooom

 

[MikeFord]

I agree with your sentiments, I've got some users who aren't that IT literate and was attempting to make it 100% foolproof...hopefully, they should be able to work out to click the close button.

 

[Thooom]

I agree with your sentiments, I've got some users who aren't that IT literate and was attempting to make it 100% foolproof...hopefully, they should be able to work out to click the close button.

OK, I see what you mean (about "some" users). In the past, I have had to use a form (rather than a report) in place of a proper Access Report, to allow for clickable controls. The biggest downside (in my case) was that this form didn't print quite as "pretty" as a standard report. In other cases, the lack of things like grouping and formatting mean a form won't do the job as well as a report. Good luck.


Thooom

 

[MikeFord]

I've since discovered that altough the report now opens at 100% from the switchboard if the report spans 2 pages it does not allow you to view the 2nd page...if you click on "the page turner" at the bottom of the page it just zooms in on the 1st page...urghh..back to the drawing board!!!

 

[Thooom]

I've since discovered that altough the report now opens at 100% from the switchboard if the report spans 2 pages it does not allow you to view the 2nd page...if you click on "the page turner" at the bottom of the page it just zooms in on the 1st page...urghh..back to the drawing board!!!

Hmm...according to my copy of Access, setting AutoResize to No prevents this (what you said) from happening. Not sure what's going on for you now; sorry.



Thooom