I suspect Crystal is right and you're not running the Database from a directory that is marked as "secure" by Access. ( I moved to Access 2007 some time ago and I've managed to forget how brain-dead I found the security stuff in Access 2007 at that time. Access 2010 seems to be a little less brain-dead in this respect. In case you're not aware, Access 2007 forces you to create "safe houses", directories where you tell Access 2007 "this is a safe place, trust any Code you find in it" and then allows you to install an atomic bomb in this directory and start it...) If Crystal's mention of "Trust center locations" leaves a question mark in your mind then, the Crystal Analysis is correct and your form is opening without running any of the code. I don't have the info to hand ieher as I have to set up these "safe houses" directly in the registry but basically you click on the big office symbol (top left in the ribbon) ans select "Trust Cenbter" or whatever it's called in english (Sicherheitscenter in German) there there's a button "Trust Denter Settings" (or whatever it's called in english, in German it's "Einstellungen für dads Sicherheitscenter") and there there's a place where you can set trustworthiness of various things, one of them being "locations" where you can then say that particular Directories ("Safe Houses") can be trusted.
I relaise I've propbably managed to make that very complicated, even more complicated and brain-dead than it already is...
--- In MS_Access_Professionals@yahoogroups.com, "Bradley" <bradgriffis@...> 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.
>
> --- 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