If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Clear Grid in Access 2007
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! |
#2
|
|||
|
|||
Clear Grid in Access 2007
On Jul 10, 9:12*pm, "Jill" wrote:
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 |
#3
|
|||
|
|||
Clear Grid in Access 2007
"Jill" wrote in message
... 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... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada |
#4
|
|||
|
|||
Clear Grid in Access 2007
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 ---------- "Jill" wrote in message: ... 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! |
#5
|
|||
|
|||
Clear Grid in Access 2007
On Jul 10, 10:46*pm, "Jeff Conrad [MSFT]"
wrote: 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 ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.mspx ---------- "Jill" wrote in message: ... 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! Another example of Office 2007 totally messing with the UI in ways that make things harder... |
#6
|
|||
|
|||
Clear Grid in Access 2007
"Jeff Conrad [MSFT]" wrote in message
... 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... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada |
#7
|
|||
|
|||
Clear Grid in Access 2007
You rock, Jeff!
"Jeff Conrad [MSFT]" wrote in message ... 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 ---------- "Jill" wrote in message: ... 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! |
Thread Tools | |
Display Modes | |
|
|