• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

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
0
midfde
Asked:
midfde
  • 4
  • 4
  • 3
  • +2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
from the ribbon

create > Macro dropdown > module

or open form in design view and hit Alt + F11
0
 
midfdeAuthor Commented:
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)".
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
midfdeAuthor Commented:
Wrong answers. For a correct one please see the attached image.
-.bmp
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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!
0
 
midfdeAuthor Commented:
Want to follow LSMConsulting's suggestion.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yes ... I had done the Customize thing on all of my A2010 systems ... View Code.

mx
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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!!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I've always had that button on the Toolbar (A2003)

mx
Capture1.gif
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Well, I do that too ...
0
 
Nick67Commented:
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
0
 
midfdeAuthor Commented:
"View code" is instead of "Code"
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 4
  • 4
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now