Category Archives: General Computing

ILT – Simple technique to toggle between true and false or one and zero

20/06/2013 If you want to toggle a value from 1 to 0 or 0 to 1 depending on the current value then you are at the right place. (i.e. change the value to 0 only if it’s 1 now and … Continue reading

Posted in Algorithms & Concepts, General Computing | Tagged , , , , | Leave a comment

XSD validation for integer – How to allow empty values for integer while limiting value range (ILT)

19-06-2013 How to write XSD to validate an integer field so that only a range of values and empty tags are allowed. Example: I wanted to allow any value between -1 and 999 and also had to allow empty tags … Continue reading

Posted in Database-Concepts, General Computing | Tagged , , , , , , , , | Leave a comment

ILT – How to find if two time frames overlap or collide?

14/06/2013 Let’s assume that time frame 1 starts from Start1 and ends on End1 (Time Frame 1 = Start1 – End1) Similarly Time frame 2 = Start2 – End 2 Time Frame 1 and Frame 2 Over Lap IF: Start1 … Continue reading

Posted in Database-Concepts, General Computing, SQL Server | Tagged , , | Leave a comment

How to force your website to download a file (rather than opening)

07/05/2013 I wanted to add a download link to one of my products. The file was an Windows Installer Package (*.msi). However, FireFox started to open the file on the browser rather than downloading it so when my visitors tried … Continue reading

Posted in Blogging, General Computing | Tagged , , , , , , | Leave a comment

ILT – Command to lock a windows computer

19/03/2013 How to program your custom keyboard key to lock your computer? How to programmatically lock your computer? How to lock your computer from the run dialog box? How to lock your computer form DOS? Answer: Just use following command … Continue reading

Posted in C#.Net, General Computing | Tagged , , , , , , | Leave a comment

Tool to Display a Reminder When You Log Off , Turn Off or Restart Your Computer

This tool enables you to display a reminder message when your computer is logging off, Shutting down, or Restarting. buy from ebay: http://www.ebay.com/itm/251240517391 Have you ever forgotten to submit daily reports before logging off or shutting down your computer for … Continue reading

Posted in General Computing, Products, Tips and Tricks | Tagged , , , , , , , , , , , , , , , | Leave a comment

Replace Function Doesn’t Replace Double Quotation in VBA

13-11-2012 I had to remove all double quotation marks from a string using VBA. I tried to do this by using the Replace function as shown below. Also Note that two double quotation marks are used to represent the quotation … Continue reading

Posted in General Computing, Microsoft Access | Tagged , , , , , , , , | Leave a comment

Virtual Laser Keyboard – How it works.

20-02-2009 Computer is the electronic device that has been evolved in the most rapid phase over the time. All parts that all together compose the computer now have come a very long journey when compared with their ancestors. The keyboard, … Continue reading

Posted in General Computing | Tagged , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

How to Search for UnRead Emails On Gmail?

26-09-2012 How to find un-read emails that are hidden under stacks and stacks of read emails? Simple, just add is:unread to your search then Gmail will bring all unread emails relevant to your search. For example, if you want to … Continue reading

Posted in General Computing, Internet, Tips and Tricks | Tagged , , , , , , , , , , , , , , , , , , | Leave a comment

How To Write A DOS Bat (Batch) File To Check And Delete A Folder With Contents And Then Self-Destruct?

05-09-2012 How to write a simple bat file (DOS command batch file) to find if a directory exists and delete it with all items in it (all files and sub folders). Simple DOS command explanation: IF EXIST will check the … Continue reading

Posted in General Computing | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment