INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...This was the ONLY place that I could find information that I could use to resolve the problem. So thanks once again to member TomSark and the SQL forum!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Languages > VBA Visual Basic for Applications (Microsoft) Forum

Access 2007 Tabs are hidden & Office Button items hidden. How to reset?

Read More Threads Like This One

PWD (TechnicalUser)

11 Jul 12 9:17

Good afternoon, I've posted this in the Office Forum but had no replies. Impatient, or what? :)

I have inherited an Access database that appears to have just about everything locked down/locked out. All I can see is the 'Home' tab on the ribbon. When I click on the Office Button the only option left is Close Database. I can get to the macros but can't see any clues there. Does anyone have any code I can use to restore things please?

I thought I'd found an option a few weeks ago - can't remember what it was now - but it required the database to be shut down and restarted to take effect :(

Many thanks,
D€$

PWD (TechnicalUser)

11 Jul 12 10:11

Ah, found on mrexcel.com to hold the Shift key down when it's opening so that's a step further forward. I can see everything but it all disappears again when I click the 'Enable Macros'.

Many thanks,
D€$

LegalTec (Programmer)

30 Jul 12 16:58

On the ribbon click the down arrow and "More Commands"

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To VBA Visual Basic for Applications (Microsoft)