Thursday, September 30, 2010

Calc: Define Print Area

Format > Print Ranges

To view current Print Area:
View > Page Break Preview

Friday, September 24, 2010

PC lost time when turned off

Who keeps fooling with my PC's CLOCK???
www.rpgwatch.com/forums/archive/index.php/t-1940.html

Useful comment:
The non functioning world time clock is well known and documented, i have access to ten pc's and they all give the same message that you are getting. but the task bar holds true set time on them all. Various clock sync programs are available for free.

If the bios will not 'hold' the set data (time/data etc') then obviously the battery has lost it's power and needs a replacement as suggested.

If, with a new battery the bios still doesn't hold then the motherboard is suspect. Some times the bios chip is defective and in some rare cases may be re-flashed or hot-swapped depending on make/model/version (check manufactures site for bios upgrade info) as mentioned.

To quickly check for any rootkits install the free offer from AVG
http://www.softpedia.com/get/Antivirus/AVG-Anti-Rootkit.shtml

"Spybot search and destroy" will also seek-out and remove similar instances.
http://www.safer-networking.org/en/index.html

Search Google for another symptom:
windows|computer clock slow|behind

Thursday, September 23, 2010

Policy: Force policy change(es) to take effect immediately

Gpupdate /force

Source:
A Description of the Group Policy Update Utility
http://support.microsoft.com/kb/298444

Policy: Default Domain Security vs Default Domain Controller Security

How does precedence work for the Default Domain Controller Security Settings vs the Default Domain Security Settings
http://serverfault.com/questions/82923/how-does-precedence-work-for-the-default-domain-controller-security-vs-the-defaul

Useful comment:
It's worth noting that domain password policy is controlled by the resultant set of policy of all GPOs at the root of the domain, and not just the contents of the "Default Domain Policy". I don't ever modify the "Default Domain Policy" or "Default Domain Controllers Policy" in the field. I always create additional GPOs to override these settings, such that I can always disable my GPOs and return Active Directory back to "stock" behaviour if I need to.

Policy: Change when to prompt user for expiring password

Computer Configuration > Windows Settings > Security Settings > Local Policies >
Security Options > Interactive Logon: Prompt user to change ...

Wednesday, September 22, 2010

MS Query: Incorrect syntax near keyword ...

FIX: "Incorrect Syntax near the Keyword 'by' " Error Message with Column Names of "C", "CA" or "CAS"
(http://support.microsoft.com/kb/273813)

Bottom line:
Problem occured because there's a column name that conflict with SQL keyword

Solution:
Exclude the column from query OR upgrade to latest MDAC

Tuesday, September 21, 2010

2007: Cannot subtotal data obtained from MS Query

You cannot do this because when you get data from an external source, the
output converts to a Table. Once of the limitations of a table is that you
cannot use Data > Subtotals. The only option is to convert the table to a
range (and then you will be able to use Data > Subtotals) but then you will
lose the data connection with the external data source.
(www.excelbanter.com/showthread.php?t=242276)

This happens when you convert the range to a Table (Ctrl+T or Ctrl+L). A Table cannot be subtotaled. To overcome this problem, try either of the following:
1. Convert the Table back to a Range - Click on any cell inside the Table and in Table Tools (Yellow button at the top) > Design > Tools > Convert to Range > Yes. Now you will be able to convert to a Range
2. Create a pivot table - If you want to let the Table remain, then just create a pivot table. Drag Part number and Description to the row area and quantity to the data area.
(www.merawindows.com/Forums/tabid/324/forumid/90/threadid/45543/scope/posts/Default.aspx)

Bottom line:
Copy then Paste Values to another worksheet