Microsoft Tidbits
Revision as of 03:03, 9 March 2008 by Admin (talk | contribs) (→Reasons Microsoft Access (2007) Sucks)
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!