Bradley-
If your database isn't in one of the "trusted" locations listed, then none of
the code will run when you open the database.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bradley
Sent: Wednesday, July 27, 2011 5:49 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Hiding the Ribbon
Thanks Crystal, I took a look at the "Trusted Locations" in the Trust Center,
but am unsure what I should see, or what I need to do. I'll keep doing some
research. Let me know if you find the answer in the meantime.
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...>
wrote:
>
> Hi Bradley,
>
> Do you have your Trust Center locations set up? In other words, is the macro
not working because it is being blocked? I am running off to class so I don't
have time to look up links -- perhaps someone else can expand on this
>
> warm regards,
> Crystal
>
> (: have an awesome day :)
>
> --- On Wed, 7/27/11, Bradley wrote:
>
>
> > Thank you both for the help. I'm not
> > aware of an occurrence of ShowToolbar in any of the macros I
> > created, and I am not sure what SendKeys is. If you get a
> > chance, could you please take a look at my test database to
> > see if you can find the problem? I'll keep looking in the
> > meantime. It may help to know that my database was created
> > in version 2003 and then converted to version 2007 and
> > modified. Thanks again.
> >
> > --- "acravenrohm" <yahoo@> wrote:
> > >
> > > The command you're using is correct if what you're
> > trying to do is maximise the amount of space you have on
> > screen. If you just want to get rid of the stuff from the
> > ribbon then you are going to have to look at creating an XML
> > file as described in one of the other answers.
> > >
> > > The code works for me so there must be something else
> > going on in your Database that's switching the ribbon back
> > on. Have you searched for other occurences of the
> > ShowToolbar in code or macros? Or maybe a SendKeys?
> > >
> > > --- > "Bradley" <bradgriffis@> wrote:
> > > >
> > > > Hello, I want to hide the ribbon on my database.
> > I put the following code in the "On Open" event of my
> > startup form "FrmMaster," but the ribbon still appears. What
> > am I doing wrong? My test database is "TimeTool_3" in
> > the "PTS Time Tool" folder. I use Access 2007 and my
> > experience level is beginner.
> > > >
> > > > Private Sub Form_Open(Cancel As Integer)
> > > > DoCmd.ShowToolbar
> > "Ribbon", acToolbarNo
> > > > End Sub
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Brad
> > > >
> > >
> >
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar