creating commandbars

[NigelShaw]

Hi

i found this db a while ago and the content when the buttons are clicked is something i would like to create on my current db however, ive never had to create these before so im really unsure how to make them. i thought that i wiuld be able to look at the example in the attached db but there isnt ( as far as i can see ) anything there that has created the menu.

could i get a little guidance please?


regs


Nigel

 

[ajetrumpet]

what are you talking about nigel? making your OWN menus?

 

[boblarson]

Check this out Nigel.

 

[NigelShaw]

Hi Adam,

on the example db, there is a small menu appear when the mouse pointer is whe nthe form button is pressed yet in the db, i cant find where the small menu was created. Obviously, it has been created so my question was, How as i would like to create something similar.

thanks


Nigel

 

[Kryst51]

Check out this site it seems to have instructions on how to create the menu. Then it looks like the button is set through the on click event procedure to pull that menu.

Edit: Bob's looks excellent as well! He posted while I was working on mine

 

[NigelShaw]

Hi Thanks guys,

query: is this pre 2007? i have 2007 and the options of customize on the form right click are not available.


nidge

 

[boblarson]

Hi Thanks guys,

query: is this pre 2007? i have 2007 and the options of customize on the form right click are not available.


nidge

2007 require a few different things. I haven't played with creating right-click menus that way (which is what they are just invoked by a button). Perhaps something on the Access Freak site will help, or perhaps Jeff Conrad's site.

 

[NigelShaw]

Hi

in 2007 I have found out that you can create your right click menu with macros one macro to create the menu and another macro to call the menu. You then add the menu to the shortcut menu property on the "other" tab in properties.

Seems to work ok but I'm going to see if by converting the macros to vba, they'll still work. I never really gelled with macros!!


Regs

Nidge

 

[boblarson]

I never really gelled with macros!!

You might want to start getting reacquainted with macros as they take a bigger place of prominence in 2010. Especially if you plan to use any data macros (data macros are like SQL Server Triggers). They do have a nice new macro builder which is more "code like" in Access 2010.

 

[NigelShaw]

Hi bob

played around with the new builder. It is more code like which is good. I do like the visual enhancements

nige