[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 672
  • Last Modified:

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?
0
k-wow
Asked:
k-wow
  • 3
  • 2
  • 2
  • +2
1 Solution
 
Nathan RileyFounder/CTOCommented:
ctrl w
0
 
Nathan RileyFounder/CTOCommented:
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
 
GRayLCommented:
I don't have Access 2007.  What do you mean by close 'tabs'.  ie. what's a tab?
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
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 CoachmanCommented:
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
 
mbizupCommented:
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
 
k-wowAuthor Commented:
Thanks!
0
 
mbizupCommented:
Glad to help :-)
0

Featured Post

Independent Software Vendors: 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!

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now