HOW TO ADD/SUB GOOGLE SPREADSHEET COLUMN

HOW TO RESTORE GOOGLE SPREADSHEET INTO OLDER DATE

First take a look in the revisions (File->Revision history...) of the open document. You may be able to revert to the revision that contains your recent work.

Joining Multiple Tables with SQL Inner Join Statements

SELECT * FROM drivers, vehicles, locations
WHERE drivers.location = vehicles.location
AND vehicles.location = locations.location

How to pair Sony ericsson Bluetooth Headset with a phone?

Topair the headset in automatic pairing mode (this only works the very first time you turn on the headset):

1. To switch on the headset, press and hold the Call handling button for 5 seconds, until you hear a beep. The Call handling button is located on the front of the headset.
2. The indicator light will now flash red and green, which indicates that the headset is "Pairing mode".
3. In the phone, you now have to add the headset to the phone's list of Bluetooth devices. For detailed instructions, click on Product Information/Getting Started in the left hand navigation menu, or use the phone's user guide.
4. You have to enter a Bluetooth passkey in the phone. The default passkey is 0000.

To pair the headset in manually pairing mode:

1. Press both VOLUME BUTTONS, (+) and (-), at the same time for 5 seconds until your hear a beep.
2. The indicator light will now flash red and green, which indicates that the headset is in “Pairing mode”.
3. In the phone, you now have to add the headset to the phone's list of Bluetooth devices. For detailed instructions, click on Product Information/Getting Started in the left hand navigation menu, or use the phone's user guide.
4. You have to enter a Bluetooth passkey in the phone. The default passkey is 0000.

How to give hyperlink to a label

FIRST ON CLICK EVENT WRITE Process.Start("http://www.icelabsolutions.com/")
Private Sub Label3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label3.Click
Process.Start("http://www.icelabsolutions.com/")
End Sub
SECOND STEP ON MOVES MOVE CHANGE CURSOR IMAGE
Private Sub Label3_MouseMove(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Label3.MouseMove
Label3.Cursor = System.Windows.Forms.Cursors.Hand
End Sub

How to change cursor icons in vb.net

Private Sub Label3_MouseMove(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Label3.MouseMove

Label3.Cursor = System.Windows.Forms.Cursors.Hand

End Sub

Mysql query for select last x rows

QUERY = "SELECT * FROM USER ORDER BY USERID LIMIT X

HOW TO TAKE CURRENT DATE AND TIME FROM MYSQL DATABASE

For date
query= "SELECT CURDATE() "
For date and time
query = "SELECT now() "
ForTIME
query = "SELECT Curtime()"

QUERY FOR CURRENT DATE AND TIME INSERT IN MYSQL DATABASE

For date
query_ = "INSERT INTO TABLE(dp_name, dp_date)VALUE ('anuraj)', CURDATE() )"
For date and time
query = "INSERT INTO TABLE (dp_name, dp_date_time)VALUE ('anuraj)', now() )"
ForTIME
query_ = "INSERT INTO TABLE (dp_name, dp_time)VALUE ('anuraj)',curtime() )"

How to Type Prefix characters in Microsoft Word?

1. Select the text you want to make a superscript.
2. Press CTRL/SHIFT/=

DDDDDDT^TT

How to Type Suffix characters in Microsoft Word?

1. Select the text you want to make a superscript.
2. Press CTRL/=


ADDDDD_DD