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

23 September 2009 arrow in the browser toolbar. Displays your browsing history in the tab. Press Backspace, or Alt and the left arrow together. Goes to the previous page in your browsing history for the tab. Press Shift+Backspace, or Alt and the right arrow together....

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

Terms & Conditionshttps://joellipman.com/static-items/terms-conditions.html

30 May 2009 and use this website you are agreeing to comply with and be bound by the following terms and conditions of use, which together with our privacy policy govern Joel Lipman .Com's relationship with you in relation to this website. The term 'Joel Lipman...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Newbies guide to be the local computer guyhttps://joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 fix in the time I have, all your issues have been dealt with and I also did this..." "So this is what I've quickly put together for demo purposes."

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 and it will work. Set MySQL parameters (using @ - same as T-SQL) and Microsoft Excel 2007 gets confused. Putting it all together Create a SQL query that will return: staffname, activity date, duration, week/year, person days, resource names, and the...

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

MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 1 day of 7:00 will result in 37:00 total. // Our working week starts on Monday 00:00 and ends on Sunday 23:59. Putting it together Your first query should loop through the users list, within the loop run the activities query and replace the string...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 T-SQL concatenation which requires plus signs and thinks it's super clever when it tries to add a number and a string together; then remembers it's a Microsoft by-product and realises it can't. Solved by checking the datatypes for each field in the...

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

Hide a Drive per User in Windows 7https://joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 from the list below you want to set as restricted, and click on OK. -- Restrict multiple drives by adding the values together -- For Example: To Restrict B & C, enter 6 decimal -- " " E & G, enter 80 decimal or 50 hexadecimal Drive Letter Decimal Hex A...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic memory to do the same. My beloved DJI Phantom and the Hubsan X4...

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

Excel - Check a column for values found in another columnhttps://joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 =SUMPRODUCT(--ISNUMBER(SEARCH(Sheet2!$A$1:$A$4,Sheet1!A1)))>0 Where: SumProduct( is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 as I found moving my mouse from 4 to 5 involved going up to 2, right through 3 to 1, then down to 5... Now it all blends together: Error(s) Encountered: DisplayPort to DVI cable doesn't work: I get what I pay for I guess... I went for a slightly more...

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

Zoho Deluge: Proper Case for Nameshttps://joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 = v_LastName.replaceAllIgnoreCase(v_Exception, v_Exception, false); } v_LastName = v_LastName.trim(); // // join all together v_FullName = trim(v_FirstName + " " + v_LastName); info v_FullName; // // yields: Billie-Jo McDonald-O'Leary II of...

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

Cranberry flapjackhttps://joellipman.com/articles/_other-misc/cranberry-flapjack.html

07 July 2009 50g/1¾oz butter 50g/1¾oz caster sugar 50ml/1¾fl oz double cream 1 orange, peeled and segmented Method 1. In a bowl mix together the oats, honey, self-raising flour, egg and dried cranberries. This should form a thick batter. 2. Melt the butter in a...

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