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
What's the macro doing on the close button? Show the exact statement if you
could..
"Rick"
news:1194289949.253014.283950@e34g2000pro.googlegroups.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
>
On Nov 6, 6:58 am, "ARC"
> What's the macro doing on the close button? Show the exact statement if you
> could..
>
> "Rick"
>
> news:1194289949.253014.283950@e34g2000pro.googlegroups.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
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
On Nov 9, 11:59 am, "Rick Brandt"
> 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
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