Skip to main content

Posts

Showing posts with the label classic-archive

Outlook Missing Attachment Reminder - All versions (2003, 2007, 2010, 2013)

This Outlook macro will remind you to attach a file if it finds the word "attach" or "PFA" in your email and no actual file is attached. Adding a macro to Outlook is easy. Just copy everything below starting with "Private Sub" through "End Sub."  In Outlook, select the "Tools | Macro | Visual Basic Editor" menu option.  In Outlook 2010, Select File | Options | Customize Ribbon | Under Customize the Ribbon | Check the "Developer" option to enable it and click "OK" to close the dialogue box. Then Click on the Developer in the Ribbon Menu and click on Macro. You may need to expand the project by clicking the plus signs under  Project1  until you see  ThisOutlookSession , and double-click it. Click into the big white empty page and hit Paste. Please find the screenshot attached of what the editor should look like below the code. Click Save and you'll be all set. If you've previously disabled mac...

How to add additional languages to your Blackberry

All language packs for BlackBerry smartphones are provided to BlackBerry smartphone users by the wireless service provider where the BlackBerry smartphone was purchased. The language packs are contained in the BlackBerry® Device Software for the specific BlackBerry smartphone model and specific wireless service provider. To view the language packs installed on a BlackBerry smartphone: For BlackBerry Device Software 4.1 to 5.0: From the home screen, select  Opt i ons  >  Advanced Options  >  Applications  or  Options > Language . For BlackBerry Device Software 6: From the home screen, select  Options > Device > Application Management  or  Options > Typing and Input > Language. To install a language pack, select and download the latest BlackBerry Device Software for the BlackBerry smartphone model from the appropriate wireless service provider from the list located here:  BlackBerry Desktop...

Replacing a carriage return (new line) in SQL query

Replace How to Remove/Replace carriage return in queries: Carriage returns inside the data plays havoc with export functionality.  Here is the simple way to remove or replace the carriage return with an alternate character using simple  Replace string function. The first replace changes the carriage return + new line char (\r\n), the next replace them if there are present separately. REPLACE(REPLACE(REPLACE(dbo.MyRemarkField , CHAR(10) + CHAR(13), ' '), CHAR(10), ' '), CHAR(13), ' ') AS MyRemarks,

Regsvr32 - Register, UnRegister a DLL

  DLL Syntax REGSVR32 [/U] [/S] [/C] [/I:[ Command_Line ]] DLL_Name REGSVR32 [/U] [/S] [/C] /N /I:[ Command_Line ] DLL_Name Key /u Unregister Server. /s Silent - no dialogue boxes. /c Console output. /n Don't call DllRegisterServer /i Call DllInstall (or DllUninstall if /u is specified) Command_Line An optional command line for DllInstall Examples Unregister (disable) a dll REGSVR32  /u  C:\Windows\System32\sample.dll Register (enable) a dll REGSVR32 sample.dll REGSVR32 c:\myfolder\sample.dll  On Microsoft Windows operating systems, a DLL stands for Dynamic Link Library. DLL's are relatively small files that include a library of functions- usually data that can be shared across multiple applications. DLL's are called upon by various applications and can be loaded and utilized by these applications concurrently.     Random Related articles: [PC][Tutorial] .DLL FILES. Wha...

SQL Server: How to find related db objects (views, stored procedure) for a table; Search stored procedures

The following code will help to find all the Stored Procedures (SP), Views, User defined functions which are related to one or more specific tables.  This is very useful since sp_help and sp_depends does not always return accurate results. SELECT DISTINCT SO.NAME, SO.XTYPE FROM syscomments SC INNER JOIN sysobjects SO ON SC.ID=SO.ID WHERE SC.TEXT LIKE '%tablename%'