Link to home
Create AccountLog in
Avatar of mytfein
mytfein

asked on

new to Access 2010 - i tried out the show ribbon = no, and now missing the create tab

Hi EE,

i searched EE for how to hide ribbon and found this:

DoCmd.ShowToolbar "ribbon", acToolbarNo

1) what exactly does it hide when set to "no"

a    - entire ribbon?
b    - navigation pane?
c    - leaves the file and home tab, and hides the create tab?

2)  i'm seeing  b and c happen....  would you agree?

when

i set it back to:
DoCmd.ShowToolbar "ribbon", acToolbarYes

3) would you agree that:

it seems that the Navigation pane is still gone, and i have to go to File/options/current database to check off show navigation bar

4) how do i get the create tab back?

5) i have a vba module to   DoCmd.ShowToolbar "ribbon", acToolbarYes
     the vba module is called
    :  010_ResetMenuBar  - yet Access is not letting me f8 thru this module to execute
                                          this sentence

Below is a screen shot of the create tab is missing
Uploaded accdb, and when you open you will see that create tab is missing

tx in advance for your help, sandra


User generated imageEE-ARG-00-MainSystem-frontend.accdb
SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
<DoCmd.ShowToolbar "ribbon", acToolbarNo

1) what exactly does it hide when set to "no"

Hides the entire Ribbon


check this
File > Options > Current Database

Navigation
      see if the checkbox is checked or not

Ribbon And Toolbar Options

      see if there is a ribbon name selected  from the Drop down box
Avatar of mytfein
mytfein

ASKER

Hi Everybody,

i'm guessing that the f8 is not working, bec. the create tab is missing

so i exit accdb and go back in to accdb with shift+f11

so create tab show, and am able to walk through fyed's code,
      but when exit accdb, and click on it, create tab is still missing

sigh....
did you do what i posted above ?
Avatar of mytfein

ASKER

User generated image


should i just create a new accdb
      by copying my old mdb to accdb again

           and using fyed's code

maybe i corrupted the current accdb, somehow...

tx, sUser generated image
Avatar of mytfein

ASKER

Hi fyed,

tx for writing:
   - when you show the navigation pane, you default to showing tables?
   - why are you testing the version of the application, and what does 12 mean?


Hi Cap,
tx for writing
   - when i click to open the accdb
           the create tab is gone, and the file tab is limited
                 so i exit the accdb
                          and open it using shift_f11,
                               the i go to file/options/currentdatabase
                                         and navigation is checked off


it's really weird, that f8 does not always work when i go to 000_resetmenubar module
that has the show ribbon to yes

when f8 does work, the create tab came back, but when i exitted the accdb and came back
the create tab was gone again

will try fyed's idea...tx,  s
have you done a Compact and Repair

File > Manage > Compact and Repair
Avatar of mytfein

ASKER

Hi Cap,

yes, just tried,  exitted accdb, clicked, and create tab is still gone

will try again tomm....

tx, s
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of mytfein

ASKER

tx Cap!

yes, that restored the Create tab

tx so much
Avatar of mytfein

ASKER

Hi Everybody,

if you have time, can you read this related question that i just posted?

tx

https://www.experts-exchange.com/questions/28140641/new-to-Access-2010-hide-ribbon.html