By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,115 Members | 894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,115 IT Pros & Developers. It's quick & easy.

Close icon on custom toolbar doesn't work

P: n/a
I'm moving Access2000/2003 apps into Access2007 running on XPpro
Dells.
I've found where to lower the macro security and with a tweak to
references have allowed me to use my custom toolbars without the
ribbon. My toolbars are small usually just Print and Close.
The Print icon works OK but nothing happens when you click on Close.
Any work around?

Rick

Nov 5 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
ARC
What's the macro doing on the close button? Show the exact statement if you
could..

"Rick" <rb*******@compuserve.comwrote in message
news:11**********************@e34g2000pro.googlegr oups.com...
I'm moving Access2000/2003 apps into Access2007 running on XPpro
Dells.
I've found where to lower the macro security and with a tweak to
references have allowed me to use my custom toolbars without the
ribbon. My toolbars are small usually just Print and Close.
The Print icon works OK but nothing happens when you click on Close.
Any work around?

Rick
Nov 6 '07 #2

P: n/a
On Nov 6, 6:58 am, "ARC" <PCES...@PCESoft.invalidwrote:
What's the macro doing on the close button? Show the exact statement if you
could..

"Rick" <rbrown...@compuserve.comwrote in message

news:11**********************@e34g2000pro.googlegr oups.com...
I'm moving Access2000/2003 apps into Access2007 running on XPpro
Dells.
I've found where to lower the macro security and with a tweak to
references have allowed me to use my custom toolbars without the
ribbon. My toolbars are small usually just Print and Close.
The Print icon works OK but nothing happens when you click on Close.
Any work around?
Rick- Hide quoted text -

- Show quoted text -
>>>What's the macro doing on the close button? Show the exact statement if you
could..
<<<

Not attached to a macro.
The Close icon was dragged onto the custom toolbar from the commands
tab in the Customize dialog box for toolbars

Rick

Nov 6 '07 #3

P: n/a
Rick wrote:
Not attached to a macro.
The Close icon was dragged onto the custom toolbar from the commands
tab in the Customize dialog box for toolbars

Rick
Known issue with 2007. You will have to attach the icon to a VBA function
that does the closing. I use...

Function CloseActiveReport()

On Error Resume Next
DoCmd.Close acReport, Screen.ActiveReport.Name

End Function
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Nov 9 '07 #4

P: n/a
On Nov 9, 11:59 am, "Rick Brandt" <rickbran...@hotmail.comwrote:
Rick wrote:
Not attached to a macro.
The Close icon was dragged onto the custom toolbar from the commands
tab in the Customize dialog box for toolbars
Rick

Known issue with 2007. You will have to attach the icon to a VBA function
that does the closing. I use...

Function CloseActiveReport()

On Error Resume Next
DoCmd.Close acReport, Screen.ActiveReport.Name

End Function

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Thanks for the reply, your solution will work for me.

Is Close the only toolbar icon that clitches in 2007?
Rick

Nov 10 '07 #5

P: n/a
Rick wrote:
Thanks for the reply, your solution will work for me.

Is Close the only toolbar icon that clitches in 2007?
Rick
It's the only one I know of. It wouldn't surprise me in the least if there were
more.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Nov 11 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.