Developer Tab missing in Access 2007

[jakubsisak]

I don't seem to be able to turn on the developer tab in Access. Unlike in the
other Office apps installed on my machine, the option to do so (Access
Options -> Popular)
is not there.
When i consult Help, it says to turn it on the same way i did in Word and
Excel.
am i missing something?
Thanks

 

[Dirk Goldgar]

I don't seem to be able to turn on the developer tab in Access. Unlike in
the
other Office apps installed on my machine, the option to do so (Access
Options -> Popular)
is not there.
When i consult Help, it says to turn it on the same way i did in Word and
Excel.
am i missing something?

I don't think there is a Developer tab in Access 2007. The Database Tools
tab covers a lot of the functionality, and VB code is always available by
either opening an existing module from the navigation pane or creating a new
module from the Create tab.

 

[jakubsisak]

Thanks for the reply. True, there probably isn't one, and makes sense that
accessing vba is more readily available here but i am starting to get used to
the ribbon in other applications and it has become a common place to look for
groups of related controls.
What prompted my question was an entry in the Office help where it says that
the developer tab can in fact be turned on.

In help go to Access Home -> Security and Privacy -> Enable or disable
macros in Office documents

scroll down to Access

at the very bottom of the Access section there is a TIP which says:

"You can open the macro security settings dialog box from the Developer tab
in the Ribbon, which is part of the Microsoft Office Fluent user interface.
If the Developer tab is not available, click the Microsoft Office Button, and
then click Access Options. Click Popular, and then select the Show Developer
tab in the Ribbon check box."

Is this an error in the help file?

 

[Dirk Goldgar]

What prompted my question was an entry in the Office help where it says
that
the developer tab can in fact be turned on.

In help go to Access Home -> Security and Privacy -> Enable or disable
macros in Office documents

scroll down to Access

at the very bottom of the Access section there is a TIP which says:

"You can open the macro security settings dialog box from the Developer
tab
in the Ribbon, which is part of the Microsoft Office Fluent user
interface.
If the Developer tab is not available, click the Microsoft Office Button,
and
then click Access Options. Click Popular, and then select the Show
Developer
tab in the Ribbon check box."

Is this an error in the help file?

I think so. Of course I could be wrong, but (a) I've never heard of the
Developer Tab in Access, and (b) I found this blog post from the Access
Product Team:

http://blogs.msdn.com/access/archive/2006/03/23/new-office-ui-in-access-12.aspx

dated March 23, 2006, saying,

<QUOTE>
"Database Tools" is the last of the 'regular' ribbons, and contains all of
the more advanced tools in Access that will mostly be of interest to
developers. In the other new UI apps, this is called the "Developer" tab
and is hidden by default. In Access we believe that developers are a core
part of our user community so display the ribbon as a core part of the
application.
</QUOTE>

 

[jakubsisak]

Thanks, that makes sense. The entry in the help must be erroneous then.

 

[Albert D. Kallal]

Actually, if you installed the packwizard (runtime tools), then when you hit
the office button, you will notice a "new" entry called

developer.....



When you click on the option you get two options

package solution
and
save as template

 

[Dirk Goldgar]

Actually, if you installed the packwizard (runtime tools), then when you
hit the office button, you will notice a "new" entry called

developer.....



When you click on the option you get two options

package solution
and
save as template

Is that showing up as a Developer tab on the ribbon, in which case the help
file is right part of the time? Or is it just a separate dialog off the
Office button?

 

[Tony Toews [MVP]]

Actually, if you installed the packwizard (runtime tools), then when you hit
the office button, you will notice a "new" entry called

developer.....

Also note that when you switch to A2003 and back to A2007 you will
lose that entry. See the third question at Microsoft Office Access
2007 Developer Edition FAQ
http://www.granite.ab.ca/access/developeredition2007faq.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Albert D. Kallal]

Is that showing up as a Developer tab on the ribbon, in which case the
help file is right part of the time? Or is it just a separate dialog off
the Office button?

ah...ok.... (no after installing the developer tools, you get a separate new
entry after you hit the office button, not something on the ribbon....

 

[Keith]

THIS IS NUTS
Why are the M$ people talking like there was never a Developer tab in Access
2007. I've been using it up to about a week ago. It disappeared and I can't
get a straight answer out of anyone. I don't think half of the MVP even use
access enough to know it's missing. What gives!!! Is it going to come back???
I was using the heck out of it and all the text books I have (NEW) refer to
the buttoms on that tab.
SOMEONE PLEASE GIVE ME A STRAIGHT ANSWER!!!

 

[Albert D. Kallal]

THIS IS NUTS
Why are the M$ people talking like there was never a Developer tab in
Access
2007. I've been using it up to about a week ago. It disappeared and I
can't
get a straight answer out of anyone. I don't think half of the MVP even
use
access enough to know it's missing. What gives!!! Is it going to come
back???
I was using the heck out of it and all the text books I have (NEW) refer
to
the buttoms on that tab.
SOMEONE PLEASE GIVE ME A STRAIGHT ANSWER!!!

If you are taking about the developer extensions, they are what we call an
add-in.

IF that add-in fails, or your perhaps have more then one version of access
installed on your machine, then the developer option will often become
disabled.

Thus even re-installing the developer tools will NOT re-enable the
developer option). So, re-installing will not help this.

To re-enable the developer options, simple go:

office button->access options->add-ins

on the bottom is combo box for Manage: COM Add-ins

click on the "go" button

check the box
[x] Microsoft Office Access Developer Extensions COM Addin

and click ok.

When you hit office button, you should now see a "developer" option in the
list....

By the way, you likely can't find any info on this because that developer
option is NOT really a ribbon tab, and thus calling it a "tab" is the wrong
terminology here....

 

[Philip Herlihy]

THIS IS NUTS
Why are the M$ people talking like there was never a Developer tab in Access
2007. I've been using it up to about a week ago. It disappeared and I can't
get a straight answer out of anyone. I don't think half of the MVP even use
access enough to know it's missing. What gives!!! Is it going to come back???
I was using the heck out of it and all the text books I have (NEW) refer to
the buttoms on that tab.
SOMEONE PLEASE GIVE ME A STRAIGHT ANSWER!!!

I think you may not be aware that the people who give their time in this
forum to solve your problems do so entirely voluntarily, and as the MVPs
are recognised experts the time that they give is correspondingly that
much more valuable. So, questioning their knowledge and SHOUTING ABOUT
IT is probably going to bring you responses from only the most patient
and forgiving of contributors, and that would certainly rule me out.

Phil, London

 

[Rich Wonneberger]

Albert,

Does this one come with Office? (Access 2003 or 2007 I think)

TIA
Rich W.

 

[Keith]

It was a tab right next to Database Tools. Had alot of Textbox options and
VBA. Property sheet options, Avanced controls, ect... All my brand new text
books refer to it constantly. Yes. Tab is what I meant. The help file was
right. I set that option under Access options>popular on 10 installations of
Access 2007. What update made it go away?

THIS IS NUTS
Why are the M$ people talking like there was never a Developer tab in
Access
2007. I've been using it up to about a week ago. It disappeared and I
can't
get a straight answer out of anyone. I don't think half of the MVP even
use
access enough to know it's missing. What gives!!! Is it going to come
back???
I was using the heck out of it and all the text books I have (NEW) refer
to
the buttoms on that tab.
SOMEONE PLEASE GIVE ME A STRAIGHT ANSWER!!!

If you are taking about the developer extensions, they are what we call an
add-in.

IF that add-in fails, or your perhaps have more then one version of access
installed on your machine, then the developer option will often become
disabled.

Thus even re-installing the developer tools will NOT re-enable the
developer option). So, re-installing will not help this.

To re-enable the developer options, simple go:

office button->access options->add-ins

on the bottom is combo box for Manage: COM Add-ins

click on the "go" button

check the box
[x] Microsoft Office Access Developer Extensions COM Addin

and click ok.

When you hit office button, you should now see a "developer" option in the
list....

By the way, you likely can't find any info on this because that developer
option is NOT really a ribbon tab, and thus calling it a "tab" is the wrong
terminology here....

 

[Philip Herlihy]

Albert,

Does this one come with Office? (Access 2003 or 2007 I think)

TIA
Rich W.

The Access Developer Extensions are an optional download. Up to 2003,
they were a paid-for product (and not at all cheap) but for 2007 they
are free.

http://msdn.microsoft.com/en-us/office/bb229700.aspx

Phil

 

[Albert D. Kallal]

It was a tab right next to Database Tools. Had alot of Textbox options and
VBA. Property sheet options, Avanced controls, ect... All my brand new
text
books refer to it constantly. Yes. Tab is what I meant. The help file was
right. I set that option under Access options>popular on 10 installations
of
Access 2007. What update made it go away?

Yes, some books do refer to it.

All of the "other" office applications (word, excel) etc. refer to the
developer tab. Because access "is" a development system, then there is not a
developer tab (darn near everything is for development).

So, there are some "out of date" help files that assumed all office
applications will have/has a developer tab. That tab is available in
most other office applications but just not in access....

 

[Keith]

You don't understand. I'm not crazy and I'm not blind. I enabled it in Access
throught the options under popular. (On ten PCs). We have been using it. I
have been using it. 10 People are unable to do their job the same without it.
It was there, I swear to God! It was there! Why is the ribbon tab gone and
the option not visible. Are you with Miscrosoft?

 

[Keith]

Too many forums with too many dead ends or people who think I was seeing
things. Asking desperately in capital letters, though it might not be up to
you texting etiquette, wasn't meant be to taken as yelling. Just trying to
get some answers.

 

[Philip Herlihy]

Too many forums with too many dead ends or people who think I was seeing
things. Asking desperately in capital letters, though it might not be up to
you texting etiquette, wasn't meant be to taken as yelling. Just trying to
get some answers.

Noone here owes you an answer, and noone here works for Microsoft. All
volunteers. Read your posts again in that light.

Phil

 

[Albert D. Kallal]

You don't understand. I'm not crazy and I'm not blind. I enabled it in
Access
throught the options under popular. (On ten PCs). We have been using it. I
have been using it. 10 People are unable to do their job the same without
it.
It was there, I swear to God! It was there! Why is the ribbon tab gone and
the option not visible. Are you with Miscrosoft?

No, I am not with Microsoft...I am a regular user of access like you....

The only thing that I know that goes away is some of the Macro options
depending on your security.

This is noted here:

http://accessjunkie.com/faq_02.aspx

Access 2007 does not have a developer tab.