Hey to get rid of the ribbon you need to program it using XML. It's not hard to just get rid of it. Do this:
1) Create a table named USysRibbons with the fields: RibbonName (Text, 255), RibbonXml(Memo). This table wil be hidden as it's a system table that Access will search to load up any custom ribbons.
2) Right-click the Navigation pane where it says All Access Objects (Top of navigation pane).
3) Click navigation options
4) Show system objects
5) Then open the USysRibbons table (or alternatively create a form with this table as its record source - this way you can later update it if you decide you want to create a custom ribbon for your database application)
6) In the ribbon name field type in a name (anything you want)
7) In the ribbon xml field copy and paste the following:
<customUI xmlns="
http://schemas.microsoft.com/office/2006/01/customui">
<ribbonStartFromScratch="True">
</ribbon>
</customUI>
8) Save the change, then close and re-open the database (you
have to close and re-open it)
9) Then go to the access options and under current database, ribbon name, select the ribbon you just wrote. Press OK.
10) Message says re-open database, so close and re-open it.
And that should do it! Hope this helps
. Please let me know if it doesn't and I'll try my best to help you (I've customised ribbons before so I know this is possible, so please let me know if this doesn't work and I'll try to sort it out for you.)
