Wednesday, September 28, 2011
Thursday, October 21, 2010
USB Setting
Hi friends r u feeling nervous to insert pendrives to u r PC with out u r
permission to disable USB ports just simple follow the given steps below:
Start->Run->Type =regedit
Then u can see the Registry Editor Select
HKEY_LOCAL_MACHINE->System->CurrentControlSet->Services->USBSTOR on right
side pane u can see the start option then double click on the start option
and chage the value 3 to any value above 50.
permission to disable USB ports just simple follow the given steps below:
Start->Run->Type =regedit
Then u can see the Registry Editor Select
HKEY_LOCAL_MACHINE->System->CurrentControlSet->Services->USBSTOR on right
side pane u can see the start option then double click on the start option
and chage the value 3 to any value above 50.
SQL : nth Max Salary
How to get nth Max salary record from employee table;
select ename from emp where sal=(select min(sal) from (select * from emp order by sal desc) where rownum<=n);
Here n denotes number, say if you need to retrieve 22nd Max salary then n=22 here.
select ename from emp where sal=(select min(sal) from (select * from emp order by sal desc) where rownum<=n);
Here n denotes number, say if you need to retrieve 22nd Max salary then n=22 here.
Thursday, January 29, 2009
Excel 2000: Open each Excel spreadsheet in a different windows.
Open Windows Explorer
Select "Tools"
Select "Folder Options"
Select the "File Types" Tab
Scroll down to find and select the XLS extension
Click the "Advanced" Button
Select the "Open" action from the list
Click the "Edit..." Button
Where is says "Application used to perform action:"
/e "%1"
to the end of the file path and then uncheck use DDE checkbox.
Refer more @
http://www.eggheadcafe.com/software/aspnet/29922442/how-can-i-open-2-excel-fi.aspx
Select "Tools"
Select "Folder Options"
Select the "File Types" Tab
Scroll down to find and select the XLS extension
Click the "Advanced" Button
Select the "Open" action from the list
Click the "Edit..." Button
Where is says "Application used to perform action:"
/e "%1"
to the end of the file path and then uncheck use DDE checkbox.
Refer more @
http://www.eggheadcafe.com/software/aspnet/29922442/how-can-i-open-2-excel-fi.aspx
Thursday, October 2, 2008
Add Copy To / Move To to the Windows Explorer Right Click Menu
Inorder to add Copy To/Move To options either you need to open registry editor or else save the commands in a .reg extension file and double click it.
Procedure:
On desktop create a new file and paste the below information and save it as copyandmove.reg, Double click this file one time and delete it. Right click on any file/folder u will notice the change immediately.
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers\Copy To]
@="{C2FBB630-2971-11D1-A18C-00C04FD75D13}"
[HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers\Move To]
@="{C2FBB631-2971-11D1-A18C-00C04FD75D13}"
Procedure:
On desktop create a new file and paste the below information and save it as copyandmove.reg, Double click this file one time and delete it. Right click on any file/folder u will notice the change immediately.
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers\Copy To]
@="{C2FBB630-2971-11D1-A18C-00C04FD75D13}"
[HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers\Move To]
@="{C2FBB631-2971-11D1-A18C-00C04FD75D13}"
Tuesday, September 30, 2008
Create your own search engine
Its easy to create a search engine in Mozilla firefox using a Addon
"Add Search Bar" -> https://addons.mozilla.org/en-US/firefox/addon/3682.
After creation of a search engine if you want to customize it goto this location
C:\Documents and Settings\Ur_Username>\Application Data\Mozilla\Firefox\Profiles\
Open the profile directory and goto "searchplugins" folder and select the xml file created using above addon and modify it according to ur convenience.
"Add Search Bar" -> https://addons.mozilla.org/en-US/firefox/addon/3682.
After creation of a search engine if you want to customize it goto this location
C:\Documents and Settings\Ur_Username>\Application Data\Mozilla\Firefox\Profiles\
Open the profile directory and goto "searchplugins" folder and select the xml file created using above addon and modify it according to ur convenience.
Monday, September 8, 2008
Forgot to mention subject, while writing an official mail??????
Don’t worry……… just follow the simple steps mentioned below and see the result.
Here are the below steps
1.Open your outlook
2.Press Alt+F11. This opens the Visual Basic editor
3.On the Left Pane, one can see "Microsoft Outlook Objects", expand this. Now one can see the "ThisOutLookSession".
4.Click on "ThisOutLookSession".
5.Copy and Paste the following code in the right pane.(Code Pane)
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim strSubject As String
strSubject = Item.Subject
If Len(strSubject) = 0 Then
Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?"
If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo Then
Cancel = True
End If
End If
End Sub
6. Save this and now close the VB Code editor and take a breath. From now on, this macro will make sure you do not make the mistake of sending a mail without subject
Here are the below steps
1.Open your outlook
2.Press Alt+F11. This opens the Visual Basic editor
3.On the Left Pane, one can see "Microsoft Outlook Objects", expand this. Now one can see the "ThisOutLookSession".
4.Click on "ThisOutLookSession".
5.Copy and Paste the following code in the right pane.(Code Pane)
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim strSubject As String
strSubject = Item.Subject
If Len(strSubject) = 0 Then
Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?"
If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo Then
Cancel = True
End If
End If
End Sub
6. Save this and now close the VB Code editor and take a breath. From now on, this macro will make sure you do not make the mistake of sending a mail without subject
Subscribe to:
Posts (Atom)