Is there a shortcut key to close all tabs when in Datasheet View in Access 2007?

Ctrl+W closes only 1 tab. What shortcut key closes all tabs that are open in Datasheet View in Access 2007?
k-wowAsked:
Who is Participating?
 
mbizupConnect With a Mentor Commented:
There are a ton of websites listing shortcut keys for A2K7. This is one of the most comprehensive ones I've seen:
http://mkkumar.sulekha.com/blog/post/2007/09/microsoft-access-shortcut-keys.htm

I haven't seen any that explicitly tell you how to "Close All" tabs using the keyboard alone.

However, I just noticed that if you hit

Ctrl + W (or Ctrl+F4)

The selected tab will close.

Keep holding the key combination down, and after a slight pause the remaining tabs will close simultaneously.
0
 
Nathan RileyFounderCommented:
ctrl w
0
 
Nathan RileyFounderCommented:
Well maybe not what your looking for after reading further.  how about

In AccXP if you do Alt --> Q --> R it would work

I found it from here

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23835829.html
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
GRayLCommented:
I don't have Access 2007.  What do you mean by close 'tabs'.  ie. what's a tab?
0
 
k-wowAuthor Commented:
Access 2007 has the capability to display tables in Tabs. Similar to how IE8 displays browser sessions in tabs. I have included a screenshot for your review.
Access-2007---tabs.jpg
0
 
GRayLCommented:
Thanks, talk about a picture worth 10,000 words!
0
 
mbizupCommented:
k-wow,

I am not aware of any shortcut keys in A2K7 that will close all object tabs.

However, you can right-click any of the tabs and select "Close All" for this effect.
0
 
Jeffrey CoachmanMIS LiasonCommented:
k-wow,

Make a Public function to close all open forms:

Public Function CloseAllTabbbedForms()

Dim objOpenForm As AccessObject
   
    For Each objOpenForm In Application.CurrentProject.AllForms
        DoCmd.Close acForm, objOpenForm.Name, acSaveYes
    Next objOpenForm

End Function


Then create an "AutoKeys" Macro to run it.

Here is a sample:

Open the database.
Open all three forms.
Press: Control-Shift-W
... to close all the open forms

JeffCoachman
Access-EEQ23886611CloseAllTabbed.mdb
0
 
k-wowAuthor Commented:
Thanks!
0
 
mbizupCommented:
Glad to help :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.