Link to home
Start Free TrialLog in
Avatar of midfde
midfdeFlag for United States of America

asked on

What is instead of "Code" button in database toolbar in Access 2007?

Access 2007: How do I "one-click" access form's code please?
Please see the attched image.
.
-.jpg
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

from the ribbon

create > Macro dropdown > module

or open form in design view and hit Alt + F11
Avatar of midfde

ASKER

Is "open form in design view and hit Alt + F11" a one-click / keystroke as it used to be in 2003?
I am asking about the button on my image: Open VBA code editor for selected form. Not create a new module ("create > Macro dropdown > module)".
I don't think there is one in 2007/2010. You'd have to open the form in Design view, then click the View Code button in the Design ribbon item.
ASKER CERTIFIED SOLUTION
Avatar of midfde
midfde
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I'd encourage you to select your last comment as the answer. This will move the question into the knowledgebase, where others may benefit from your expertise!
Avatar of midfde

ASKER

Want to follow LSMConsulting's suggestion.
Yes ... I had done the Customize thing on all of my A2010 systems ... View Code.

mx
Odd ... I never used that button in earlier versions. I always just opened the form/report in Design view, then went to the code editor from there. Ya learn something new every day around here!!
I've always had that button on the Toolbar (A2003)

mx
Capture1.gif
It was there, I just never used it. Just got in the habit of opening in design view and then moving to the code module.
Hafta look at that.
As per our Access 2010 dicussion The lack of right-click|properties is a major PITA for me in 2007/2010

Nope.  Dammit.
If you are in form view, it's greyed out.
I sure hope in Access 2012 they give us back, in order
1. right-click|properties in form view
2. the database windows
3. the File|View|edit menu bar

Yes, there are add-ins but there cludgy
Avatar of midfde

ASKER

"View code" is instead of "Code"