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