Clear Grid in Access 2007

[Jill]

I can't find it anywhere! How do you clear the query grid in Access 2007? I
have to just close the query and start over completely!

 

[CompGeek78]

I can't find it anywhere! How do you clear the query grid in Access 2007?I
have to just close the query and start over completely!

I've not found a simple solution for this myself. There are several
ways to do this, but if you really want to clear everything out,
closing and starting anew may be the fastest way to go.

You could:
1.) remove the tables you are using from the top of the grid. Right
click them and choose Remove Table (works well if you only have one or
two tables)
2.) click and drag on the little gray bar above the first field in the
grid (your mouse pointer should turn into a black arrow pointing down)
across to the last column, hit delete
3.) click on the same little gray bar, hold down the Shift key and
click the last column in the grid, hit delete

All of those options should work, which one works best for you is up
to you to decide.

Keven Denen

 

[Albert D. Kallal]

I can't find it anywhere! How do you clear the query grid in Access 2007? I
have to just close the query and start over completely!

I guess the idea is to either save the query, or simply close it if you want
to start over.

Yours is an interesting question, since none of the versions of ms-access
ever had some button to clear things out.

If there just one table in the query, simply click on the table in the
graphic part of the query builder, and then hit the delete key. It will
clear out the gird and the table. You can then either choose right click and
show table, or choose show table from the ribbon.

The above procedure will allow you to quickly start over without having to
close the query and start a new one.

A lot of people I suppose just close the query, answer no, and then create a
new one...

 

[Jeff Conrad [MSFT]]

Hi Jill,

Here's a new FAQ page on my site created just for you:
http://accessjunkie.com/faq_57.aspx

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[CompGeek78]

Hi Jill,

Here's a new FAQ page on my site created just for you:http://accessjunkie..com/faq_57.aspx

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentialshttp://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info:http://www.AccessJunkie.com

Another example of Office 2007 totally messing with the UI in ways
that make things harder...

 

[Albert D. Kallal]

Hi Jill,

Here's a new FAQ page on my site created just for you:
http://accessjunkie.com/faq_57.aspx

As Gomer pile would say.....Gooooolllly....

I did not know that!!!

cool little tip....thanks...

 

[Jill]

You rock, Jeff!

Hi Jill,

Here's a new FAQ page on my site created just for you:
http://accessjunkie.com/faq_57.aspx

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx

 

[pcreview858]

The best way I could find to handle this is to add the toolbar option for clearing the grid to your toobar

right click on the ToolBar Ribbon
click Customize
Show All commands
and choose the Clear Grid