Bradley-
It's a timing bug in Access. I had to do this to get it to work:
Private Sub Form_Load()
Dim sglTimer As Single
' Make sure I'm fully loaded
Me.SetFocus
' Wait a sec to let the Ribbon paint
sglTimer = Time
Do Until (Time - sglTimer) > 2
DoEvents
Loop
' Now try to hide the ribbon
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Sub
Note that I moved your code from the Open to the Load event.
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 11:11 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Hiding the Ribbon
Bill, I created several macros, but they are all very simple, and I don't see
the word AutoExec anywhere. Maybe I'm not looking in the right place. Maybe
someone else could take a peek.
As you can see from my previous post, John and I both noticed that when
FrmMaster is opened from the navigation pane the ribbon disappears, but for some
reason it doesn't disappear when FrmMaster is opened as the Startup Form. Any
more ideas?
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...>
wrote:
>
> Bradley
>
> The "Display form" is the same thing as the startup form. Do you have a macro
named AutoExec? If so, that might be interferring with the startup form.
>
> Bill Mosca, Founder
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bradley" <bradgriffis@>
wrote:
> >
> > It sounds like we're getting close, but I must be missing something. I see
that when hold my shift key down and go into the DB and double-click FrmMaster
from the navigation pane, the ribbon is gone. But if I close the DB and bring
back up by double-clicking on the DB file itself, the ribbon is still there. I
checked the Access Options and the "Display Form" is FrmMaster. Is there a
"Startup Form" property I need to set?
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
wrote:
> > >
> > > Bradley-
> > >
> > > When I open FrmMaster in the sample database you uploaded, the Ribbon
hides just
> > > fine. You have to make FrmMaster the Startup form.
> > >
> > > 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 8:44 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Re: Hiding the Ribbon
> > >
> > > Thanks John, I experimented with a test database I put on our company
network
> > > drive. I added the code to the "On Open" event of the master form, then
went to
> > > the trust center and browsed for my database and made it a Trusted
Location. I
> > > closed the DB and re-opened. The ribbon is still there. Any other ideas?
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@>
wrote:
> > > >
> > > > 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
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> >
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar