asked on

Menu commands: How do figure out how to do menu commands using VBA

Hi EE,

Was wondering how you figure out how to do menu commands using VBA
(since Access does not have a macro recorder)

Do you just browse intellisense of Docmd/

pls advise, tx, sandra

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Helen Feddema

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mytfein

ASKER

Helen Feddema!
what an honor !!!!! wow! pls see below.....

Mx:
I would like to congratulate you on your MVP 2009 Access award....

Mx please excuse me for waxing poetic about Helen...
Helen helped me years ago with Access to word automation to generate labels programmatically.
I found Helen's website, and contacted her with questions and to my utter delight Helen held my
hand while I figured out the technique. I still use the VBA, and all users are impresses as they
watch the labels zippily being populated on the Word screen. I always rave that an author took
the time out to help me....

Thank you soooo much Helen...

OK, now i'll come in for a landing...
thx Helen and Max, I need to digest your info and get back to you...

tx again, s

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

" what an honor !!!!! wow! pls see below....."

Yes ... and I'm waiting for a few others to catch on !!

"Mx please excuse me for waxing poetic about Helen..."

lol ...

Helen ... fyi --- Sandra is one of the most funnn people on EE ...

mx

mytfein

ASKER

mx,

hope you noticed my congrats about your mvp award!
was hoping you would respond to one of my posts, so i could acknowledge your
accomplishment!
Does EE recommend you, does Microsoft find you, or do you apply for the award?
(just wondering)
You are quite fun and funny (and smart), too! tx, s

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"hope you noticed my congrats about your mvp award!"
Ahhhh ... humm, I guess I missed that, wow. But .... Thank You !

Someone on EE nominated me ... a TOTAL surprise, btw.

mx

mytfein

ASKER

Hi Helen and Mx,
a)customized menus are one of my weakpoints
so thx mx, for the links especially since they show screen shots
thx helen, for the concept that one can execute from a custom menu

b) Mx,
thx for confirming the DoCmd.RunCommand as a viable command to browse its intellisense
c) Helen,
I am using A2003 ....
Another weak point I have is working with the Object browser
I followed your instructions so far, and pasted a screen shot
can you give me an example of what to look for to "complete this exercise"

tx again everyone, s

ObjectBrowser.GIF

mytfein

ASKER

Hi mx,

Nominated and a surprise.... lovely! Well deserved...
tx again, s