Another thing that you will also notice, now that you can run your application without a visible toolbar, is that there is now no toolbar for reports, as well.  That becomes a bit of a problem, as there is no obvious way for the user to print the report.

There are a couple of ways to go about making sure that users have a visible option to print the report.  One easy way is to just assign your favorite toolbar to the toolbar or menubar property of the report.

My favorite way, as I am a code writing kind of guy, is to use the following code:

Option Compare Database
Option Explicit

Private Sub Report_Close()
 DoCmd.ShowToolbar "Compliance Database", acToolbarNo
End Sub

Private Sub Report_NoData(Cancel As Integer)
 MsgBox "No records found"
 Cancel = True
End Sub

Private Sub Report_Open(Cancel As Integer)
 DoCmd.ShowToolbar "Compliance Database", acToolbarYes
End Sub

If you have already converted your database to Access 2007 format, perhaps because you are not running any earlier versions, then the water has already gotten deep. 

First of all, (grumble, grumble) Access 2007 does not have a facility to visually edit (drag and drop) toolbars.  It seems that in Access 2007, if you choose to change anything on toolbars, you are expected to write Visual Basic code to do it (or else use that old copy of Access 2000 that you still have lying around)

Secondly, (grumble some more) toolbars are handled in a different way in Access 2007 when you are running a database which has been converted to the Access 2007 format (in other words, a database with an AccDB extension)  In that case, the toolbars that you wrote using Access 2003 or earlier show up under a tab called "Add Ins"

Well, I didn't want my users to have to choose an "Add Ins" tab every time that they used my menu.  After much searching and a lot of hair pulling, I finally figured out how to make a custom ribbon and change the label of the "Add Ins" tab so that it would be called something else, whatever name I wanted it to be called.

The task, unfortunately, is a little daunting, even after having already done it.  The way that one person described it is as follows: "To remove the ribbon, you create a USysRibbons table and in the one row, add the following XML, which will remove all other std Access 2007 ribbon tabs and rename add-ins"  There are several steps in this process, and a good tutorial of how to get started is at the following link:

http://www.databasedev.co.uk/access2007ribbon.html

Remember how you could view Hidden files and System files in in Access 2003?  Well to be able to create a new ribbon, you have to create a new system table. So, in order to do that, you have to use the same option in Access 2007 that is like the check box in Access 2003 under "Tools" "Options" "View" "System Object".  That is to say, you have to be viewing system objects.  The link above has pictures of where to go in Access 2007 to view system tables. 

Then you have to create a system table called USysRibbons.   Basically, you add three fields to it, a standard ID field of the type that Access will sometimes make for you (an Autonumber Primary Key type field), a text field called RibbonName, and a memo field called RibbonXML.  By the time you finish, this new system table should have a single record in it.  The contents of the RibbonXML field define the custom ribbon.  In order to do this, you'll have to be familiar with changing the size of memo fields in datasheet view to be able to view larger amounts of text.

The example at the web site listed above, however, is of doing something more complicated than what I wanted to do.   I mean, I just wanted to get rid of the doggone thing so that I could clean up my user interface and also keep my users out of trouble, ya know?

So for my example, the code that you paste into the single record in the newly created USysRibbons system table is as follows: 

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
  <ribbon startFromScratch="true">
     <tabs>
        <tab idMso="TabAddIns" visible="true" label="Projects" />
     </tabs>
  </ribbon>
</customUI>

The label tag in the above XML changes the name of the "Add-Ins" tab to "Projects". 

Having that XML define the contents of the ribbon, setting the "AllowFullMenus" property and the "AllowBuiltinToolbars" property to "False" (which could be done using the ChangeProperty function described above) and in addition setting the "StartupMenuBar" property to my custom menubar that I'd already developed in Access 2003 which had options for "File", "Edit", "Reports", and "Maintenance" did the trick. 

So far, at the time that I am writing this, I haven't done enough development under Access 2007 to need to do the Access 2007 method programmatically yet.  The way that I approached the development that I did under native Access 2007 so far was to just use the shift key to bypass the special menu in the development folder.

The result of running the native Access 2007 database under Access 2007 came out looking something like the following: