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

Hide "Document Tabs" programatically?

Is there a way that I can programatically perform the process of unchecking the box under the "Current Database Options" of "Display Document Tabs"?

I want the tabs to be there when I open the database holding the shift key down, but I don't want the tabs to show up from normal users.

If it matters, I'm using Access 2007
Thanks.
0
SheaJeff
Asked:
SheaJeff
  • 4
  • 4
1 Solution
 
Dirk EberhardtCommented:
You can use Currentdb.Properties("ShowDocumentTabs") = False to disable the tabs
0
 
Jeffrey CoachmanMIS LiasonCommented:
"I want the tabs to be there when I open the database holding the shift key down, but I don't want the tabs to show up from normal users."

AFAIK, this setting cannot be "toggled" (Between Tabs and overlapping windows) by holding down the shift Key.

Note:
While pco_pf's code will probably turn off the tabs, the database will still need to be closed, then re-opened for the changes to take effect.

JeffCoachman
0
 
SheaJeffAuthor Commented:
Where do I actually put this code so that it runs when the user opens the database?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
SheaJeffAuthor Commented:
No response to my followup question on clarification
0
 
Jeffrey CoachmanMIS LiasonCommented:
How are you adapting the solution to Toggle with the shift key?
0
 
SheaJeffAuthor Commented:
boaq2000,
How exactly would I do that?
That sounds like it might be what I want.
0
 
Jeffrey CoachmanMIS LiasonCommented:
SheaJeff,

<How exactly would I do that?>
<That sounds like it might be what I want.>
That is what I was asking you.

You "Acceped" the post as the "Answer" so I thought you got it to work.

I stated in my post that I could not see how it could be toggled, via the shift bypass key.
You seemed to have ignored my post, because you did not reply.

So then my question is:
Is you original question:
  "I want the tabs to be there when I open the database holding the shift key down, but I don't want the tabs to show up from normal users."
...solved completely?
Yes or no?

JeffCoachman
0
 
SheaJeffAuthor Commented:
Jeff,
My original question was not FULLY answered; I added the VBA to my main form and it worked (ON LOAD), but if I am editing the database and open the form, it removed the tabs, so I'm not exactly sure where to put the VBA so that it doesn't close the tabs when I open the program for changes (using shift key).
I am thinking that I should have the database open a hidden form with the VBA above, then when the program closes from the user, the hidden for ON CLOSE event will re-enable the tabs so that if I open it with the shift key, the hidden form will not open, and the tabs will be visible.  Is there better way?
BTW, I closed the question because I got an automatically generated email saying there hadn't been any comments in a few days, and I thought I had to close it.
0
 
Jeffrey CoachmanMIS LiasonCommented:
The Auto genereated message is just a reminder for you to stay involved in the question.
You technically have 21 day to close a question.

Again, as I stated in my post, most of the start up settings require you to close, then re-open the database, for the changes to take effect.

I have no problem with you accepting pco_pf's post, I just did not see how it fully answered your question.
 
If you have a system that works, then fine.

JeffCoachman
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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