We won again!

Great victory for the People - Tax Cut!

Office and IE

Properly Validate TextArea Length (IE vs. Firefox)

Let’s consider this example, where HTML page has a TEXTAREA and an INBOX.  When user types inside TextArea, Inbox should show the length of TextArea string. <script type=”text/javascript”> function TTLength(objTT){ var tt= document.getElementById(‘TXT1’); tt.value = objTT.value.length; } </script> <textarea onKeyDown=”TTLength(this);” onKeyUp=”TTLength(this);” rows=”10″> This Text Area Contains a string With Newline […]

No Picture
Win XP - Win 7

How to Reset Win XP Admin Password

There are two ways to reset forgotten Administrator password. Method one – Reset During Repair Reinstall: Use Win XP installation disk Run Recovery (not Recovery Console) Press Shift+F10 during GIU portion of repair / install Run LUSRMGR.MSC to reset any user password to whatever you want During my tests, this […]

No Picture
Hardware

Moving Win XP from RAID to RAID Machine

After several days of heavy exhausting battles and sleepless nights, after testing dozens of options, after browsing many proposed Internet solutions, I finally was able to move an old instance of Windows XP on a new machine with new RAID drivers. That happened at 13:23 on December 12, 2010.  I […]

No Picture
Office and IE

Count Number of Cell with Errors in Excel

This problem occurs, when you have a column with a formula that sometimes returns an error.  That is very typical for all kind of look-up situations .  Let’s say, you have a column E with formula that returns good values and errors.  You need to count how many errors are […]

No Picture
SQL Server 2008

Update Field Based on a Field in Another Table

This article contains 3 examples: – T-SQL; – MS Access; – AS/400.   This example shows a standard T-SQL syntax tested on MS SQL 2005 server: update P set P.CertMemberLevelID = Z.CertLevelTo from   UPM_MemberPermissionMask P INNER JOIN zzzCertRegistryUpdate Z ON P.MemberID = Z. Cert2ID Here we are updating one […]

Win XP - Win 7

Cisco VPN Client Error 51 – Open Your Firewall

Annoying!  How Annoying! This very simple, very typical error message, but it is so hard to find a quick solution. Symptoms: You are starting a Cisco VPN Client and immediately you are getting this error message: Error 51: Unable to communicate with the VPN subsystem. Please make sure that you […]

No Picture
ASP.NET

The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’

ASP.NET page returns this erorr: The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’. (1) First try runing this command/wizard: %WinDir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe   (2) If this doesn’t work, try this query:  — Add user ASPNET to DB role USE YourDB GO sp_addrolemember ‘aspnet_Membership_FullAccess’, ‘ASPNET’ These steps should resolve […]