Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 listed below can help save you time. Window and tab shortcuts Ctrl+N Opens a new window. Ctrl+T Opens a new tab. Ctrl+Shift+N Opens a new window in incognito mode. Press Ctrl+O, then select file. Opens a file from your computer in Google Chrome. Press...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing or that has been added to the system based on the business hours set at the organization...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 objects (such as database fields, column header text objects, and summaries or subtotals) in the column by holding down the Shift key while clicking each field, until all the fields are highlighted. Right-click any of the fields, click Size, and then...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: *

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 $terms_rx){ $colors = search_get_highlight_colors(); foreach($terms_rx as $term_rx){ $color = array_shift($colors); $text = preg_replace( "/($term_rx)/ise", "search_highlight_do(StripSlashes('\\1'), \$color)", $text ); } return $text; } # determine...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Windows 7 and Google Chrome incognito mode by defaulthttps://www.joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 -incognito) Additional Note 201004201256: The shortcut key within Google Chrome is holding down the Control and Shift key and then pressing the letter N.

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 I saw this on BBC News Click and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $01 Const VK_CANCEL = $03 Const VK_BACK = $08 Const VK_TAB = $09 Const VK_CLEAR = $0C Const VK_RETURN = $0D Const VK_SHIFT = $10 Const VK_CONTROL = $11 Const VK_MENU = $12 Const VK_CAPITAL = $14 Const VK_ESCAPE = $1B Const VK_SPACE = $20 Const...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 to affect the functionality of the above and you could always hardcode a 1.00 if its confusing. In theory, if you know the shift patterns of an employee, you could enhance the above to skip day-off dates (eg. Saturday/Sunday - the above does not take...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 the batch file. Open a command prompt: Method #1 Open windows explorer to the folder you want to apply this to Hold down the shift key and right-click on the folder Select "open command window here" Open a command prompt: Method #2 Start > Run > CMD (or...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 a city name, post code, zip code or any value that is understood by the api.openweathermap.org website. There are plans to shift this to using Google Services as they are more likely to find locations that openweathermap.org cannot. Add a comma and the...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSRS Border Problemhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 a whole section of the report with just one border??? How? In Design view, click on the first cell (top-left), hold down the shift key and click on the last cell (bottom-right). This selects all cells. Now open the "Properties" pane, find the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 = False Application.ScreenUpdating = True End Sub ' Add a blank row to the top each sheet Sub InsertRow() Rows(1).Insert Shift:=xlDown, _ CopyOrigin:=xlFormatFromLeftOrAbove 'or xlFormatFromRightOrBelow End Sub ' Now copy the header row Sub...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB