Moving to Access 2007

  • Thread starter Thread starter Paradigm
  • Start date Start date
P

Paradigm

I have a number of applications using Access 2K and Access 2003 that use
customised menus and toolbars and turn off all other Access menus. I have
coordinated it so that the correct menus appear when various forms and
reports are opened. I distribute the applications as mde files. They link to
an sql backend.
I have been having a first look at Access 2007 and it appears that all my
menus appear on toolbars that need to be selected and opened and there does
not appear to be a way of turning of the stupid ribbon menus. This will
confuse my users.
Is there a quick way to get my programs working again or am I going to have
to reprogram them all. I am talking about 80 different applications each
with 4-10 menus and toolbars.
The other issue is that everytime a program is opened there are security
warnings. With Access 2003 I could make a registry change to eliminate the
warnings. Is there an equivalent with 2007?
Alec
 
I know of no way to customize the ribbon yet, but there is an MVP working on
it and it may be available when Office 2007 is available. I haven't
experimented with registry settings to turn off security warnings in Office
2007 but it does have a new feature that should make that unnecessary. Tou
can create a "Trusted" folder and everything put in that folder will not
prompt the security warnings.
 
The short answer is you have some work ahead of you.

You can customize the built-in Ribbons and even create your own custom Ribbons. Just like with menu
bars and toolbars you can assign a specific Ribbon to display for a form or report. You can build
one master Ribbon to display at all times for your application. Once you really start creating your
own Ribbons you'll see how power they have over menu bars and toolbars. I've done this myself and
I'm really quite impressed with the versatility of Ribbons.

Now for the bad news. There is no simple, easy way to convert all of your menu bars and toolbars
into Ribbons. You will have to recreate them using XML. A topic like this goes far beyond a simple
newsgroup post so let me provide some reading resources.

For a good discussion of this topic, do the following:
1. Open Access
2. Click the Help button in the upper right corner
3. Maximize the Help screen if it's too small to see things easier
4. In the Help Search box in the upper left corner type this in:

HA10036544

(You can copy and paste it from here if you'd like)

5. Now hit the Search button
6. Access should now list the perfect help topic you need (Result 1 of 1)
7. Click the link to read the help topic on this subject.

That Help topic discusses how you can use your existing menu bars and toolbars in Access 2007 to
achieve virtually the same effect you saw in previous versions.

I also suggest these MSDN articles:
http://msdn2.microsoft.com/en-us/library/ms406046.aspx
http://msdn2.microsoft.com/en-us/library/aa338199.aspx
http://msdn2.microsoft.com/en-us/library/aa722523.aspx

You may also want to review this excellent post on the Access BLOG:

http://blogs.msdn.com/access/archive/2006/07/13/664757.aspx

Concerning the security warning the easiest thing to do is to create a Trusted Location and place
your database files in that location. You won't be prompted by any security warnings. Very slick.

Search for this Help topic ID to find all the information you need:

HA10031999

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

in message:
 
Thanks for your help. This means that, not only do I have to do a lot of
work but I will have to make my system specific to Access 2007 or have to
maintain 2 versions. At the moment my system works with any version of
Access from 2K upwards. I wonder how many people will feel that this is the
last straw at using Access.
Alec
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Customising the Ribbon in 2007 5
tool bars / ribbons 2007 3
Access 2007 : How can i create customized menus e toolbars in mdb'sin Access2000/2003 style? 1
Access 2007 Ribbon 1
Menus and ribbons 1
Where to add a Toolbar to start it up with Access, not the databas 2
Access 2007 crashing with right click on subform 8
Legacy toolbars in Access 2007 6

Back
Top