Hi,

I am going to convert our application that we sell and distribute (MDE
in Access 2003) to Access 2010. How do I use the current menu system
that we use. I wrote a module that enables and disables menu choices
so I need to use our 2003 menu for it to work.

I thought I saved a topic on this from this newsgroup but I can't find
it. Sorry.

I assume that the ribbon is not required and a regular menu system
(File/Reports/Utilities/Clients...) can be used instead?

Thanks,

-paulw

"PW" wrote in message news:qo96b79fijr42k955o30egrpji481df7nj (AT) 4ax (DOT) com...

Yes, you can do this. How to do this is explained here:

http://www.accessribbon.de/en/index.php?FAQ

scroll down to :
I want my database created in A2003 (or before) display my own menubar
only.

You can do this, but I kind of recommend you continue to develop an access
2003 if in fact those menu bars and systems you've developed are built using
the access built in user interface. The reason for this is that while you
can use the menu bars in 2007 and 2010, you don't have the GUI anymore to
create those menu bars like in pre 2007.

I will say I seen a lot of access applications in which VBA code is used to
create the custom menu bars and if this is YOUR case the you could jump to
Access 2010 without pain.

However, without a built in GUI to create menu bars and if you require this
GUI to create/maintain menu bars then IN THIS case I recommend you stick
with using access 2003 or you jump to custom ribbons.

It can be a bit of work to create the menu bars as ribbons, but I have some
tips and an example code download that I used to "help" me convert to ribbon
here:
http://www.kallal.ca/Ribbon/ribbon.htm

I'm pretty much of the view if you jump to the newer version of Access then
you should probably invest the time to convert over to the ribbon. While the
ribbon has been controversial among many Access developers it simply a ship
that has sailed and this is the deck of cards we been dealt.

I very much like the ribbon but at the end of the day, it really does not
matter much since the ribbon is what we have and it what users have come to
expect in office anyway.

Here is a few screen shots of an commercial application called ShowWorks
written in Access.
The screens and ribbon looks quite nice IMHO:

http://fairsoftware.com/images/speci...shots/main.png
or
http://fairsoftware.com/images/speci...ots/checks.png

more screens here:

http://fairsoftware.com/screenshots.aspx

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

On Sat, 5 Nov 2011 00:21:27 -0600, "Albert D. Kallal"
<PleaseNOOOsPAMmkallal (AT) msn (DOT) com> wrote:

I've been studying that page of yours. So the class module (code) to
use is in the sample download?

Wow! How do we make our software look like that??!! And the icons
and graphics!

I will check out everything else you provided tomorrow Albert. Thanks!

-paul

On Sat, 5 Nov 2011 00:21:27 -0600, "Albert D. Kallal"
Agreed but can I enable and disable ribbons/menu choices like I am
doing now dependant on what user signed in to the application (through
a custom login form)? Maybe you said that already!

-paulw

Any one know of resources for images I can use in an Access 2010
ribbon, etc... other than the MS Office ones? Or how to create them?

-paulw


On Thu, 03 Nov 2011 17:47:36 -0600, PW
<emailaddyinsig (AT) ifIremember (DOT) com> wrote: