Add right click menu choice to table

[chromachem]

We would like to add a menu choice to the right click menu in a table.

Basically, we would like to right click a field in a table and have an additional choice to the menu that normally pops up.

Right click field - have the choice to click "Reports" on the menu.

Click reports would run a macro - something simple such as

MsgBox "Hello"




Easy to do from a cell in Excel. Driving myself nuts trying to figure out how to do it in Access 2010.

THX

[rpeare]

I don't know that it's possible to change the context menus at the table level, you can do it at the form level (example link below). You might be able to create custom menus but that's a long way to go. Is there a reason you need a context menu at the table level and not, say, on a form instead?

[Missinglinq]

I don't think you can create custom menus for a Table...in truth, Tables aren't really meant to be used for data entry...especially by end-users! You need to create a Form off of a Table, using the Form Wizard, if need be, and go from there!

Linq ;0)>

[chromachem]

Got it. I have to get my head out of the Excel/VBA mentality, and think of things from a database perspective.

I did make a form to do what I wanted today.

Thanks.

[Missinglinq]

I have to get my head out of the Excel/VBA mentality, and think of things from a database perspective.

It's really good that you realize that! VBA for Excel...and VBA for Access, are not the same language! They both derive from Visual Basic...but they both differ from VB, and from each other, in many ways!

To make it even more confusing, they (VB, VBA for Excel, VB for Access) share many of the same Functions, name-wise...and many of the same Properties, name-wise...but they don't always work in the same way!

Only real advice I have to give, when going from one to another, is that if something doesn't work as you're expecting it to, be sure to check the syntax in the new language.

Linq ;0)>

[chromachem]

My problem has been approach. I am so used to working with spreadsheets. When I see a table - it looks like a spreadsheet, and psychologically I try to treat it as a spreadsheet. Even when working with a form, my first instinct is to stick everything in a variable, rather than using data residing in a table.I'm getting the idea of how to approach problems, and how to implement the solution. I need to repeat to my self - you're not dealing with a cell, you're not dealing with a cell.....

I'll get there.

[Missinglinq]

As I said before...it's really good that you realize that! And always know that we're here to help!

Good luck with your project!

Linq ;0)>

[chromachem]

Good to know there is someone to turn to. THX!!!