Can Access 2007 be made to look like Access 2003

[magicdds]

After using Access versions 2.0, 97, 2003, for the last 10 years, I am used
to the way all the buttons, toolbars, database window, property window, etc.
lays out. With Access 2007, I can't find where anything is!

Is there a way to get Access 2007 to look like Access 2003, while I am
developing a database application?

Thanks,
Mark

 

[Bob Vaughn]

I've been able to simulate a "drop down" menu in the ribbon by setting up
multiple Tabs on the Ribbon and using the XML Menu Control, and creating a
supporting module in my application. One of the tabs would look like the
following:


<group id="Group2" label="Families/Students">

<menu id="Menu2" label="Families/Students"
imageMso="AccessOnlineLists">

<button id ="Group201" label="Add/Edit Families and Students"
onAction="HandleOnAction" tag="Families Primary Data Form"/>
<button id ="Group202" label="Class Assignments"
onAction="HandleOnAction" tag="Class Assignments Preliminary"/>
<button id ="Group203" label="Transfer All Students From One Class
To Another" onAction="HandleOnAction" tag="Transfer All"/>

</menu>


And the supporting module looks like this:

Public Sub HandleOnAction(Control As IRibbonControl)

On Error GoTo HandleonActionError

DoCmd.OpenForm Control.Tag

HandleOnActionExit:
Exit Sub

HandleonActionError:
Resume HandleOnActionExit

End Sub


Setting up several Tabs like the above XML code has produced what looks like
a Menu Bar in the Ribbon, and it can be modifed as needed as you add new
functions.

 

[Allen Browne]

Yes, it certainly takes a bit of getting used to.

I would suggest you try to adapt, Mark. This little Flash app helps you find
where things are in the ribbon:
http://office.microsoft.com/en-us/access/HA102388991033.aspx

If you prefer a static list, here it is as an Excel workbook:
http://office.microsoft.com/search/redir.aspx?AssetID=AM101757761033&CTT=5&Origin=HA101666061033

If you really can't adapt and don't plan to use Access much in the future,
Avenius Gunter has created a database window for A2007 instead of the nav
pane:
http://www.avenius.de/index.php?Produkte:DBC2007

And here's a list of other things that might help you adapt to the new
version:
http://allenbrowne.com/Access2007.html

Hope that helps.