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