New menu in Access 2010 (1 Viewer)

[Leif]

I have a database that was created in Access 2003. I'm using this MDB in Access 2010.

I need to change a user created menu. The update involves changing an existing entry and adding a new menu item. The menu looks like:

Screen Reports Excel Tools Exit

Under Screen is:

...
Project
Time Entry
Time Spread
...

I need the "Time Spread" to change to "Time Spread Daily" with a changed macro name. After that a new menu entry is "Time Spread Monthly". This menu will run a new macro that will display a form.

I think the only way to do that in 2010 is to use VBA. Is that correct? Could someone help?

Thanks,
Leif

 

[vbaInet]

Unfortunately I don't have the older version on my laptop, but yes it can only be done through code and I think you need CommandBar which will be the main command bar object and the CommandBarControl which will be the menus.

You'll then loop through the controls in the command bar to find the command bar control that has a caption of Time Spread and change it. You should find some examples in the help files.

On the other hand, get hold of a PC that has Access 2003 installed and make the change through the User Interface.