Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 the filter that is not in alphabetical order Click on the Refresh button Re-Tick the filter to add it back to the report Move this added field to the Report Filter section (click on it and select "Move to Report Filter") Advanced Sorting So the above...

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

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

05 July 2011 reappearing, the content is what I don't want to lose. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const PM_NOYIELD = 2 ;#End Region ;#Region Windows Messages Const WM_NULL = $0000 Const WM_CREATE =...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 dest files/dirs that no longer exist in source. /MIR :: MIRror a directory tree (equivalent to /E plus /PURGE). /MOV :: MOVe files (delete from source after copying). /MOVE :: MOVE files AND dirs (delete from source after copying). /A+:[RASHCNET] :: add...

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

Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 . $_FILES["uploaded_file"]["name"])) { echo "".$_FILES["uploaded_file"]["name"] . " already exists. "; } else { move_uploaded_file($_FILES["uploaded_file"]["tmp_name"], "" .$_FILES["uploaded_file"]["name"]); echo "Stored in: " . ""....

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

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

24 August 2011 that will be the parameter/filter/criteria (it will be automatically added to row or column), then click on it and select "Move to Report Filter". Shout in Gordon Ramsey-style: Done! Better than... MS Reporting Services? Yes by far. Fast, quick to setup...

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

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 This is a quick article to remind me how to move a Joomla administration section and to lock it down to a specific IP address. The below does not involve installing any third-party extensions and will remain in place even if you update your Joomla CMS....

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 each, and then output each sheet to a separate file that is formatted as XLS (Not *.xlsx). How? In summary, we are going to move the Excel file to a folder of its own. We're going to run two VBScripts in two stages, firstly to split the specified rows...

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

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 Name the workflow, I'm calling mine OnLoad Add New Action > Deluge Script: And I add the following to my deluge script, to remove the label "Tabs": v_Css = ""; v_Css = v_Css + ".zc-Tabs-label{display:none !important;}"; v_Css = v_Css + "";...

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

Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 "); } } input.Color_Picker:ui.add(" "); // // inject some CSS v_CssStyle = ""; // when hiding the color palette, need to move the button higher to align it to the field label v_CssStyle = v_CssStyle + ".zc-Color_Picker{margin-top:-7px !important;}";...

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

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

23 September 2009 to perform a search using your default search engine. Click the address bar, then press Ctrland the left arrow together. Moves your cursor to the preceding key term in the address bar Click the address bar, then press Ctrland the right arrow together....

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

How To Make Chocolate Chip Cookieshttps://www.joellipman.com/articles/_other-misc/how-to-make-chocolate-chip-cookies.html

30 September 2009 8-10 minutes, until they're golden brown, but still soft in the centers. Let them cool on the pan for a minute, and then move them to a cooling rack. This recipe makes about 4 dozen cookies. Source:...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 tabs in Internet Explorer which is very handy, but unfortunately it doesn’t work in Firefox or Chrome as yet You can also move your cursor to the lower right corner of your screen to get a preview of your desktop, click and you will be brought to your...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 -- WHERE -- `my_old_database`.jos_sampletable.user_id=1; -- You could copy and paste this whole query and then remove everything -- from the "INSERT INTO" to just before the "SELECT" (as below): -- SET @exampleLocalVariable=1; -- SELECT -- 1, 'Joel...

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

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 (is there an "Issues Log"? Anything that still needs addressing?) System Requirements (in case you need to transfer/move to another server) Critical functions used in the system? (do this yourself anyway and use theirs as a guide only) Site...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 with dll calling) Program used to open port (still need to distinguish between out/in) detect bytes instead of kilobytes GUI Move Icon Disallow program minimize Right-click on Systray Icon causes? (stuck on preferences without a INI file) Download...

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

Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 that this article is for Joomla 1.5.x sites to be converted to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot easier since it uses nested categories like Wordpress. There are lots of commercial...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 layers, I'm going to refer to them as "window_slide" and "inner_window". Slide divs to be added inside the "inner_window". Move the slides in from right to left with a transition. Push existing slide out to the left; as soon as this is out of sight then...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Access MySQL databases using Oracle SQL Developerhttps://www.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 (Connector/J) connector from http://www.mysql.com/products/connector/ [Optional Step] Uncompress the download, then copy or move the JAR file (at time of print: mysql-connector-java-5.1.22-bin.jar) to the folder of your SQL Developer program Open SQL...

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

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 misplaced_column AFTER other_column; NOTE that annoyingly the column doesn't retain the default properties it had before the move so I guess this has to be included: ALTER TABLE table_name MODIFY COLUMN misplaced_column BIT(1) NOT NULL DEFAULT b'0'...

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

Export Joomla Users scripthttps://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which allows the passwords to be in MD5. All I want is a quick bit of code to...

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