[AccessD] How do you close report in print preview mode inAccess2007

Doug Murphy dw-murphy at cox.net
Thu Feb 21 16:31:30 CST 2008


Thanks Kath,

Looks promising.  The site seems to be down now, but will keep trying to get
the download. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
Sent: Thursday, February 21, 2008 2:16 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How do you close report in print preview mode
inAccess2007

Doug - I have also been struggling with 2007 this year and I found this tool
invaluable:

http://ribboncustomizer.clatonh.com/Main.aspx

I got it from a link sent to the list by Dan (see
http://blogs.msdn.com/access/archive/2007/12/05/access-ribbon-customizer.asp
x).

It is a free download which helps you to quickly create a custom toolbar. It
allows you to select commands and it sets up the XML for you......one for
reports and a difft. one for your main application might be good for what
you are doing?

Alternatively you could just customise the quick access toolbar and pop a
close button there....I have done that for one client. Right click on the
QAT (quick access toolobar, select customise....) That way you could get rid
of the ribbon. Or use the tool mentioned above to replace the ribbon with
one of your own.

I have done both - happy to send more details if you need them but am racing
out the door now....

Kath

----- Original Message -----
From: "Doug Murphy" <dw-murphy at cox.net>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, February 22, 2008 5:51 AM
Subject: [AccessD] How do you close report in print preview mode in
Access2007


> Against my best recommendation a client has moved to Access 2007 so I 
> am forced to use it for their projects.  My productivity has gone down 
> the drain, but I am getting there.
>
> One thing I can't figure out is how to close a report in print preview 
> mode with the ribbon bar collapsed.  In the options settings for the 
> current database I have the Document Windows options set to 
> Overlapping Windows to turn of the Tabbed document display.  I want 
> the user to close objects, not just select the tabs to navigate 
> around.  When the database is set this way and a report is displayed 
> in print preview mode there is no X to close with and I can't figure 
> out how to create a little custom tool bar or menu bar as I did in 
> previous versions to print or close the report.  I am sure there must 
> be an easy way to do it, but help isn't very helpful.
>
> Any suggestions, aside from going back to Access 2003 would be welcome.
>
> Thanks
>
> Doug
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list