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