Microsoft Tidbits: Difference between revisions

From ChipWiki
Jump to navigation Jump to search
(Major Windows Annoyances So far)
 
Line 13: Line 13:
<LI>Delete it</LI>
<LI>Delete it</LI>
</UL>
</UL>
Of course, it could be something else.  ANY name change to a dependant query or table could cause grief -- they matriculate properly about half the time, judging from the last 12 hours.  Changing the "Total" type of a field in a query for example will rename a field MaxOfxxxx without asking, and in some cases without propagating to other queries that reference the field.  It's enough to drive one mad!

Revision as of 03:03, 9 March 2008

Reasons Microsoft Vista Sucks

  • "search in files" is gone. Yes, people THINK it's there, but it's not. I can't get the search to find a simple string in an .aspx file (which I have ridiculously associated with Notepad, just in case Vista is only looking for files it knows how to read). I've changed a boatload of settings, and read some other pages that seem to indicate that people got this working, but following their instruction does nothing. Is it the file type? WTF?
  • Really there are a lot of these, but given how lazy I've been updating the rest of the site you probably won't see them here unless they REALLY bother me... like whatever I have listed so far

Reasons Microsoft Access (2007) Sucks

If you have a query that constantly asks you for a prompt for no reason, it could be that you've accidentally sorted by a column that you later renamed or removed. Access 2007 doesn't quite pick up on the change, so you have to do the following:

  • Open the Query in Design View (or SQL View)
  • Open the Properties Sheet (which by default is open and docked on the right -- if not, right click somewhere and highlight "Properties")
  • See if there's anything in the "Order By" Property that shouldn't be there
  • Delete it

Of course, it could be something else. ANY name change to a dependant query or table could cause grief -- they matriculate properly about half the time, judging from the last 12 hours. Changing the "Total" type of a field in a query for example will rename a field MaxOfxxxx without asking, and in some cases without propagating to other queries that reference the field. It's enough to drive one mad!