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.
--- In MS_Access_Professionals@yahoogroups.com, "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?
>
> --- In MS_Access_Professionals@yahoogroups.com, "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