Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

30 September 2011 Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for...

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

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

11 February 2019 prompted for the number of rows per sheet (eg. 3000). In my example, this will produce an extra 12 worksheets in this file. Using the above module, overwrite the code you previously pasted with the below (note the file format for Excel 97-2003): Sub...

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

Excel - Check a column for values found in another columnhttps://joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

14 February 2019 in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B...

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

GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

07 April 2022 Authority Bundle: (CABUNDLE)" textarea field. Clicked on "Install Certificate" A popup confirmed the domain and then using other browser profiles, I was able to verify that SSL had successfully been applied...

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

DJI Phantom FC40 - Fun at the raceshttps://joellipman.com/component/content/article/dji-phantom-fc40-fun-at-the-races.html?catid=113&Itemid=165

17 September 2014 of about 3 people high and stood so I could see the height of our 1 marshall's head. To be honest, the reason I wasn't using my propeller guards was that I clean forgot which was rather reckless of me, but the winds were really strong, I'd doubled the...

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

Is it a scam? Gumtree.com's warning signshttps://joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

12 October 2010 and the amount you passed on as the difference. Fake escrow sites. A buyer/seller or prospective tenant/landlord suggests using an escrow service to complete the transaction. These escrow websites often may look official, but are actually run by...

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

Zoho CRM: Client Script: Swap Quote Account with Deal Lookuphttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-swap-quote-account-with-deal-lookup.html

20 January 2026 the opportunity into the account.". Category is Module, Page is Create Page (Standard) (change this depending on if you're using a canvas or not) Module is Quotes Type is Page Event Event is onLoad Click on the button Next The code: /*...

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

Zoho CRM: Make Upload File Field Mandatoryhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 on making an "upload file" field mandatory. Why? Because for some reason, it wouldn't appear as selectable when I tried using a layout rule. Probably everyone else has figured this out and I'm just late to the party. How? Through the wonders of Zoho CRM...

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

Joomla: Unable to find install packagehttps://joellipman.com/articles/cms/joomla/joomla-unable-to-find-install-package.html

05 September 2009 was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to resolve this, he had to do a fresh install and double-checked the server settings for a...

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

Forgotten Super User Password in Joomla 2.5.x - 3.xhttps://joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

06 February 2015 A quick article on how to set a password using the database tools for super users. Why? It happens to us all, especially me. I like to use different passwords for every site but this came up as a client had lost their super user password. How? This...

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

JComments errors in PHP 7: plgContentJComments and JCommentsACLhttps://joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

13 March 2020 During a site upgrade, the commenting extension for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments...

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

Windows 7 and Google Chrome incognito mode by defaulthttps://joellipman.com/component/content/article/windows-7-and-google-chrome-incognito-mode-by-default.html?catid=61&Itemid=165

24 March 2010 Basically if you've just started using "incognito" mode with the Google Chrome web-browser, this article is just how to switch the quick launch shortcut (next to your start button). All the articles I googled were windows vista so I thought I'd share...

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

$_SERVER['http_referer'] returns blank in Internet Explorerhttps://joellipman.com/component/content/article/serverhttpreferer-returns-blank-in-internet-explorer.html?catid=62&Itemid=165

19 October 2009 I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in...

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

Android Background Image Resolutionshttps://joellipman.com/articles/else/app-dev/android-os/android-background-image-resolutions.html

01 December 2014 A reference to what size an image background should be set to for various screen sizes. Why? A background image I was using was unedited at 1600x2133 (364kb) and was not displaying on smaller devices. Configuring drawables for each layout seemed to be...

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

Trim in T-SQL and SSIShttps://joellipman.com/component/content/article/trim-in-t-sql-and-ssis.html?catid=74&Itemid=165

14 May 2013 -- or split for clarity TRIM( LOWER( REPLACE( REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar equation can be written:...

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

If Then Else in Report Builder 2.0 Expressionshttps://joellipman.com/component/content/article/if-then-else-in-report-builder-20-expressions.html?catid=75&Itemid=165

06 May 2010 Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0)...

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

Change Regional Settings for your Reporthttps://joellipman.com/component/content/article/change-regional-settings-for-your-report.html?catid=75&Itemid=165

17 May 2010 Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a...

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

Reminder on SSRS row separatorhttps://joellipman.com/component/content/article/reminder-on-ssrs-row-seperator.html?catid=75&Itemid=165

26 October 2011 04/10/2011 Another Office 09:00 17:00 Notes Row Seperator This follows on from my T-SQL Record Separator article. If you are using SQL Server Reporting Services (in my case version 2008 R2), then yes, you won't need to use the database level solution...

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

SSRS Subscriptions cannot be createdhttps://joellipman.com/component/content/article/ssrs-subscriptions-cannot-be-created.html?catid=75&Itemid=165

22 November 2013 with the credentials stored, here are the details to our report As developers, we connect to the datasource directly using our Windows Credentials. For the SSRS server holding our report, we do NOT have an unattended service account. The report uses a...

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

SSRS Change Background Color of Imagehttps://joellipman.com/component/content/article/ssrs-change-background-color-of-image.html?catid=75&Itemid=165

08 April 2014 color instead: Right-click on the cell you want to put the image in. Insert > Rectangle Set the Rectangle Fill color (I'm using an expression based on the status) to output: Green (for Success), Red (for Fail), Orange (for Unknown). Right-click on the...

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