Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming below is required, the following 165 results were found.

  1. The Mermaidhttps://www.joellipman.com/component/content/article/the-mermaid.html?catid=96&Itemid=165

    seas do roar, And the stormy winds do blow, And we jolly sailor boys were skipping up aloft, And the land lubbers lying down below, below, below, And the land lubbers lying down below. Then up spoke the Captain Of our gallant ship, And a fine old man...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  2. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    do? After many tweaks and corrections having upgraded multiple sites in the past few years with this script, the version below migrates the following: Articles Banners Categories & Sections Menus * NEW Messages Newsfeeds Users * UPDATED Weblinks So this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/component/content/article/add-image-mouseover-effect-in-autohotkey-gui.html?catid=48&Itemid=165

    AND MOUSEOVER EVENT WM_MOUSEMOVE() { static CurrControl, PrevControl, _TT ; _TT is kept blank for use by the ToolTip command below. CurrControl := A_GuiControl SearchButton_Over:=A_ScriptDir "\images\program\icons\search_globe_over.png"...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  5. Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    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. Why?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    build a prompt combining any of the following in a table (this is not an exhaustive / limited list). Do note that the images below were generated using MidJourney v4: Type of Photography Nature Photography Aerial Photography Astrophotography Cityscape...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  7. Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-custom-related-lists-deluge.html

    how to do this and it takes about an hour to go through the documentation and get a working solution. How? So the article below shows how to do this Zoho CRM and how to do it in Zoho Books... The example below is that we are going to search for some...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  8. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    accessible link or URL of the image. Why? I've got some other articles on handling images in Zoho Creator (see "Sources" below), the most relevant one being my article Zoho Deluge: Get Image Uploaded in Creator Form which has one method of getting a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-template-not-being-able-to-edit-a-text-box.html

    raised an issue that they had previously hard-coded the address of their organization into the body of a template (just below the header... they weren't using the header section) but then they changed address and couldn't change the template. So they...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html

    use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/else/app-dev/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    apps (and audio). How? Note that the restore can be done when the new phone prompts you to set it up but you could do the below again at anytime (as I discovered). The steps below apply after having gone through the process of setting up the phone and...

    • Type: Article
    • Author: Joel Lipman
    • Category: iOS
    • Language: *
  13. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    results table if empty" though I will add that if you wanted to put a message instead of hiding the table then following the below will also let you do this (requirements: common sense or the IQ of a duck). It's what I've been searching for for the past...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    into the field that says "Columns". Right-click on the grey left margin and select "Insert Row" then "Outside Group - Below". Delete the row with the left parenthesis Click on the dropdown of "Data" and select "TimeStamp". Click in the left of that...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    times the Dates cte can recurse OPTION (MAXRECURSION 100) I'd appreciate if you bear with me as I add captions to the below screenshots: Design the Query: So copy the above text, click on query builder and "edit as text", then paste it into there. When...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  16. Win32 Constantshttps://www.joellipman.com/component/content/article/win32-constants.html?catid=48&Itemid=165

    = $0001 Const HHT_ONHEADER = $0002 Const HHT_ONDIVIDER = $0004 Const HHT_ONDIVOPEN = $0008 Const HHT_ABOVE = $0100 Const HHT_BELOW = $0200 Const HHT_TORIGHT = $0400 Const HHT_TOLEFT = $0800 ;#End Region ;#Region List View sub item portion Const...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  17. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

    using JavaScript, along with the AHK COM "translations" (AutoHotkey_L in Black, AHK Basic in Green) - also, note Sean's post below. (Using COM requires Internet Explorer, but JavaScript can be used with most Web Browsers) The guidelines for...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  18. Client Services: Website Development Agreementhttps://www.joellipman.com/component/content/article/client-services-website-development-agreement.html?catid=50&Itemid=165

    you have been directed to this page, this is a draft article on a standard development project. The below is just a draft agreement and has to be mutually agreed. As the client, feel free to adjust, suggest and query against this. Here is an outline...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  19. Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/component/content/article/batch-process-to-rename-multiple-files-using-windows-dos.html?catid=51&Itemid=165

    don't count on it. I'm going to use a short batch process but to save time on the different ways of doing this, the example below uses a command prompt to a) create a batch file b) use it to rename the files c) delete the batch file. Open a command...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  20. Joes Word Cloud (JWC)https://www.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=53&Itemid=165

    Download the appropriate file for your system (see compatibility table below) Login to your Joomla admin panel and install as per usual. How to Use Install the ZIP using your Joomla! Admin Panel > Extension Manager View the module on your front-end to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 1 - 20 of 165