Search - Joel Lipman .Com

21. Excel - Check a column for values found in another column: / Excel /; ... purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm shelf allow unity press board wreck shake decay Sheet2 ...; Created on 14 February 2019
22. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
23. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... Subroutine: ClearTreeView: Clears the current TreeView ClearTreeView: TV_Delete() Return ; -------------------------------------------------------------------------------------- ; https://autohotkey.com/board/topic/39659-func-autobyteformat-convert-bytes-to-byteskbmbgbtb/ ; ...; Created on 28 January 2019
24. Display Feeds to major Social Networks: / Web-Development /; What? A quick article on how I displayed feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff ...; Created on 16 May 2016
25. List of Font Awesome: / Web-Development /; ...  fa-clipboard []  fa-clock-o [] 4.4  ...; Created on 04 September 2015
26. Android: Replace return key with done, go, send...: / AndroidOS /; What? A quick article on how to replace the return key on a soft keyboard (software based) on a touch-device. Why? I have an editText where a user can enter any text value but if they typed a ...; Created on 03 November 2014
27. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... specification for type onboard - Factory: share database mismatched equipment - Factory: advanced mode (motors, - Help: choose which governing bodies to include - Help: download for offline use (further ...; Created on 24 October 2014
28. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2: / Joomla /; ... at AreYouAHuman.Com: Basic Signup: Signup and you will be redirected to a dashboard. On the dashboard, note the Publisher's key (eg. "c518c95f01312c9ac97ace9ace199ace0c38d9d") On the dashboard, note ...; Created on 27 April 2014
29. ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5: / Joomla /; ... plugin later. STEP #1: Signup at AYAH You need to have a publisher and scoring key, sign up for FREE at AreYouAHuman.Com: Basic Signup: Signup and you will be redirected to a dashboard. On ...; Created on 24 March 2014
30. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... it out so that it could be used in other SSIS packages. If we included an SSIS Script in each package, any change to the script would need to be repeated across the board. The following example is an ...; Created on 04 October 2013
31. Proposed Budget i3 PC under £200: / IT Support /; ... CPU ( 3.30GHz, Socket 1155, 3MB Cache, Ivy Bridge, 55W, Intel HD Graphics 2500, Advanced Vector Extensions) - Intel £88.50 Motherboard AsRock H61M-DGS Motherboard (Socket 1155, Intel H61, DDR3, ...; Created on 26 January 2013
32. Reminder on SSRS row separator: / SQL Server Reporting Services /; ... Office 09:00 17:00 Notes Monday 03/10/2011 Boss' Office 09:00 17:00 Notes Monday 03/10/2011 Stationary Cupboard 09:00 17:00 Notes Tuesday ...; Created on 26 October 2011
33. Win32 Constants: / AutoHotkey /; ... = $0306 Const WM_DESTROYCLIPBOARD = $0307 Const WM_DRAWCLIPBOARD = $0308 Const WM_PAINTCLIPBOARD = $0309 Const WM_VSCROLLCLIPBOARD = $030A Const WM_SIZECLIPBOARD ...; Created on 05 July 2011
34. Run commands for Windows: / Windows OS /; ... Bluetooth Transfer Wizard fsquirt Calculator calc Certificate Manager certmgr.msc Character Map charmap Check Disk Utility chkdsk Clipboard Viewer clipbrd Command Prompt cmd Component Services ...; Created on 05 July 2011
35. Alternate row background colour in Reporting Services: / SQL Server Reporting Services /; ... pane and scroll down to the "Fill > BackgroundColor" row and copy the value to your clipboard or notepad, etc. Then select all the remaining cells in the row and paste your expression in the "Fill > BackgroundColor" ...; Created on 04 February 2011
36. Crystal Reports: Exporting to Excel omits column headers: / Excel /; ... Select "Size and Position..." Copy to clipboard the exact height value Right-click on a faulty heading textbox Select "Size and Position..." Paste ...; Created on 03 June 2010
37. Another ASCII Extended Character Set for PC: / Windows OS /; Typing an ASCII character In DOS: Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178) In Windows for a DOS character: Hold ...; Created on 14 April 2010
38. Changing the yourdomain.com for phpBB3: / Joomla /; This is related to the issue of renaming yourdomain.com as your title page in phpBB3. You need to login to the phpBB admin control panel (ACP). On the General tab, look under Board Configuration ...; Created on 01 October 2009
39. Forum Rules: / Static Items /; ... Muting - This is where you are not able to talk on the board. You may still view it. Temporary Ban - This is where you are not able to view the board for a certain period of time. Permanent ...; Created on 31 May 2009
40. Modals: Created on 17 April 2017