USE FULL ABBREVIATIONS

1)GOOGLE: global organization of oriented group language of earth.. 
2)YAHOO: yet another hierarchical officious oracle..
3)WINDOW: Wide interactive network development for office work solution
4)COMPUTER: Communication oriented machine purposely utilized technical educational research a scholarly article.
5)VIRUS: virtually infected reputed utilized software
6)UMTS: universal mobile telecommunication system
7)AMOLED: active matrix organic emitting diode. 
8)OLED: organic light emitting diode.
9)IMEI: international mobile equipment identity. 
10)ESN: electronic serial number. 
11)UPS: uninterruptiblepower supply. 
12)HDMI: high definition multimedia interface. 
13)VPN: virtual private network. 
14)APN: access point name. 
15)SIM: subscriber identity module. 
16)LED: light emitting diode.
17)DLNA: digital line network access. 
18)RAM: random access memory. 
19)ROM: read only memory. 
20)VGA: video graphic array. 
21)QVGA: quarter video graphic array. 
22)WVGA: wide video graphic array. 
23)WXGA: wide extended graphic array. 
24)USB: universal service bus. 
25)WLAN: wireless local area network. 
26)PPI: pixel per inch. 
27)LCD: liquid crystal display. 
28)HSDPA: high speed downlink packet access. 
29)HSUPA: high speed upload packet access. 
30)HSPA: high speed packet access. 
31)GPRS: general packet radio service 
32)EDGE: enhancement data rate for global evolution. 
33)NFC: near field communication. 
34)OTG: on-the-go 
35)S-LCD: super clear liquid display.
36)O.S: operating system. 
37)SNS: social networking sites 
38)H.S: HOTSPOT 
39)P.O.I: point of interest 
40)GPS: global position system 
41)DVD: digital video disc 
42)DTP: desk top publishing. 
43)DNSE: digital natural sound engine. 
44)OVI: Ohio video intranet. 
45)CDMA: code division multiple access. 
46)WCDMA: wide-band code division multiple access. 
47)GSM: global system for mobile communication.
48)WI-FI: wireless fidelity 
49)DIVX: digital internet video access. 
50)APK: authenticated public key. 
51)J2ME: java 2 micro edition 
52)SIS: symbian installation source. 
53)DELL: digital electronic link library. 
54)ACER: acquisition collaboration experimentation reflection. 
55)RSS: really simple syndication 
56)TFT: thin film transistor 
57)AMR: adaptive multi rate 
58)MPEG: moving pictures experts group 
59)IVRS: interactive voice response system.
60)HP: Hewlett-Packard

Retrieving data from SQL Server using RecordSet object in VBScript

Option Explicit

Dim Conn ' Connection Variable
Dim rs ' Recordset Variable
Dim sqlQuery
Dim serverName
Dim field


'Declare the SQL statement that will query the database
sqlQuery = "SELECT UserName FROM dbo.UserList WHERE ID = '9'"


'Create an instance of the ADO connection and recordset objects

Set Conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")


'Open the connection to the database
Conn.Open "DSN=getUser;UID=user1;PWD=password;Database=dbUserList"


'Open the recordset object executing the SQL statement and return records 
rs.Open sqlQuery,Conn


'Check if any record exist in table 
If rs.EOF Then 
wscript.echo "No Record Found"
wscript.quite
Else 

Do While NOT rs.Eof   
field = rs("UserName")
if field <> "" then
  wscript.echo field
end if
rs.MoveNext     
Loop

End If


'Close Connection and Recordset
rs.Close
Set rs=nothing
Conn.Close
Set Conn=nothing

VBScript Prompt a User for Input

It was been ask by one of my friend that how to get input from user in VBScript. I though by adding this to blog, that will help other.

getStringValue = InputBox("Please enter some value :","Window Title")

You can also use this in condition also in this.

If getStringValue="" then

 Wscript.Quite

else

  Wscript.Echo getStringValue

End if

VBScript to update Access Database

Save following line to .VBS file

Const adOpenStatic = 3
Const adLockOptimistic = 3

Set objConnection = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.Recordset")

objConnection.Open _
    "Provider = Microsoft.Jet.OLEDB.4.0;; Data Source = C:\Temp\Local.mdb"

objRecordSet.Open "Update Set = ", _
        objConnection, adOpenStatic, adLockOptimistic

OR

objRecordSet.Open "Insert into Values(,,...)", _
        objConnection, adOpenStatic, adLockOptimistic

Execute script Via Command Line

1. Hold your windows key and press “R” to open the command prompt
2. type: “%windir%\SysWoW64\wscript.exe ”
3. Press OK

Twisty or Collapse or expand parts of a document

When you’re working on a long, complicated document, you can collapse everything except the part you want to focus on. Or, if you think you might be overloading your readers with too much information, you can display summaries and leave it to your readers to open the summary and read the details if they want.

The ability to collapse and expand content in your document is based on its outline level. You can quickly add an outline level and make part of your document collapsible by adding a heading using Word's built-in styles.

After applying the heading style, you’ll see a small triangle when you move your cursor over the heading. Click the triangle to collapse the body text and subheadings below it.

TIP:  If you’re working on a touch device, tap to place your cursor in the heading to see the triangle.

Click the triangle again to expand that part of the document.

To collapse or expand all the headings in your document, right-click the heading and click Expand/Collapse > Expand All Headings or Collapse All Headings.

When you close and reopen a document, the headings will be expanded by default. If you want the document to open with the headings collapsed, follow these steps.

1) Place your cursor in the heading.

2) On the Home tab, click the arrow in the Paragraph group.

3) In the Paragraph dialog box, click the checkbox next to Collapsed by default.

4) Click OK.

Contents are reference from Site

The Best Excel Shortcuts You Need to Know

Almost everyone uses Excel in some form or fashion in the modern workforce, but many of us may be wasting a little too much time trying to format those pesky spreadsheets. In order to help you work a little bit faster, or maybe more efficiently. Find below best Excel shortcuts that you need to know!

• F2 : Edit selected cell
• F9 : Calculates all worksheets
• F11 : New chart
• ALT : Access the ribbon for formulas
• ALT + = : Automatically SUM() selected
• ALT + Enter : Start a new line in the same cell
• ALT + o-c-a : Auto size columns
• PG + UP/PG+DOWN : Go to next/previous worksheet
• CTRL + ` : Display Formulas
• CTRL + Backspace : Show active cell
• CTRL + Shift + # : Change Date format with day, month and year.
• CTRL + K : To insert Hyperlink.
• CTRL+ Shift + $ : Applies the currency format to the selected cells.
• CTRL + Shift + & : Applies border to cells
• CTRL + B : Bold
• CTRL + I : Italics
• CTRL + U : Underline
• CTRL + Shift + ~ : General style number
• CTRL + Shift + $ : Currency style number
• CTRL + Shift + % : Percentage style Number
• CTRL + Shift + ^  : Scientific notation style
• CTRL + Shift + # :  Date style
• CTRL + Shift + @ : Time Style
• CTRL + Shift +! : Number Style
• CTRL + F12 : Open
• CTRL + Spacebar : Select the entire column
• CTRL + [ : Select all cells directly referenced by formulas in the selection
• CTRL + A : Select All
• CTRL + Shift + J : List Constants
• CTRL + D : Copy equation down
• CTRL + F : Find
• CTRL + H : Find&Replace
• CTRL + Right arrow : Move right
• CTRL + Left arrow : Move left
• CTRL + Up arrow : Move up
• CTRL + Down arrow : Move down
• CTRL + Enter : Same data in multiple cells
• Shift + Spacebar : Select the entire row
• Shift + F3 : Find Previous

Visual Studio Keyboard Shortcuts

To format document in visual studio
Ctrl + K, D

To comment selected code
Ctrl + K, C

To uncomment selected code
Ctrl + K, U

Show intellisense
Ctrl + Space

Covert selected text to UPPERCASE
Ctrl + Shift + U

Covert selected text to LOWERCASE
Ctrl + U

Toggle Full Screen
Alt + Shift + Enter

Build Project
Shift + F6

Build Solution
Ctrl + Shift + B OR F6

Attach the debugger to a process
Ctrl + Alt + P

Expand or Collapse current element
Ctrl + M, M

Collapse all
Ctrl + M, O

Toggle all Outlining
Ctrl + M, L