Ok, thanks. I don't have any AutoExec macros.
Do you have any idea why my "FrmMaster" shows the ribbon as a startup form, but not when you double-click it on the navigation pane? This is a bigger issue than I thought it would be! Is it possible that the code needs to be put somewhere other than the "On Open" event of the form?
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi Bradley,
>
> when you save the macro, if you want it to AUTOmatically EXECute when Access is opened, then name the macro --> AutoExec
> (uppercase/lowercase letters are unimportant -- just makes the name easier to read if you mix the case)
>
> the name is what appears in the Navigation Pane ;)
>
> warm regards,
> Crystal
>
> (: have an awesome day :)
>
> --- On Wed, 7/27/11, Bradley wrote:
>
> > 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
> > > > > > > > > >
> > > > > > > > >
>
Tidak ada komentar:
Posting Komentar