Access 2007 tips and tricks from the teamhttp://blogs.office.com/b/microsoft-access/archive/2007/12/18/access-2007-tips-and-tricks-from-the-access-team.aspxMonths ago I posted a three part tips and tricks series on Access 2007 on my personal blog . I recently got feedback that the series should be posted on the Access team blog--makes sense as this blog gets about 3 million more hits a month than my personalen-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)re: Access 2007 tips and tricks from the teamhttp://blogs.office.com/b/microsoft-access/archive/2007/12/18/access-2007-tips-and-tricks-from-the-access-team.aspx#17257Wed, 19 Dec 2007 18:23:30 GMT53587256-c606-4c9b-bad4-97c86b12ce62:17257Ron West<p>I don&#39;t have Access 2007 yet. Does it still have the stupid bug in 2003, that the &quot;SQL&quot; toolbar button is grayed out when you are in the Queries window? And if you have DoCmd.SetWarnings set to True and open up a Query definition that it can&#39;t display graphically [eg when you join to Oracle tables where the driver translates the numeric Oracle primary key to a String, and you have to wrap the Oracle PK with VAL() ], does it still trash the query definition and automatically save the trashed version without telling you?</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=17257" width="1" height="1">re: Access 2007 tips and tricks from the teamhttp://blogs.office.com/b/microsoft-access/archive/2007/12/18/access-2007-tips-and-tricks-from-the-access-team.aspx#17258Wed, 19 Dec 2007 16:51:40 GMT53587256-c606-4c9b-bad4-97c86b12ce62:17258Tim<p>Clint: Will Access 14 become less important in Office 14 than this version? I like Access very much. Do not want to see Sharepoint to replace it.</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=17258" width="1" height="1">re: Access 2007 tips and tricks from the teamhttp://blogs.office.com/b/microsoft-access/archive/2007/12/18/access-2007-tips-and-tricks-from-the-access-team.aspx#17259Wed, 19 Dec 2007 12:26:21 GMT53587256-c606-4c9b-bad4-97c86b12ce62:17259Mark Jones<p>I must say, having not liked the navigation pane (like everyone else) to begin with, using the search facility is an absolute boon. I can now find my objects much quicker than the old database window. When I&#39;m working back in Access 2003 I keep looking for it!</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=17259" width="1" height="1">