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 check is required, the following 173 results were found.

  1. MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    before Mondays... but what's wrong with this equation? You can tell me that "10" comes before "8" and it does but just to check, let me pad the 8 with the prefixing zero: Annoyingly "10" still comes before "08" so maybe I'm barking up the wrong tree. If...

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

  2. Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/component/content/article/excel-find-values-in-one-column-that-are-not-in-another.html?catid=110&Itemid=165

    column to say whether this is new or not. How? I found this in a StackExchange site: Method #1 =MATCH(B2, $A$2:$A$100, 0) -- Check whether value in B2 exists in range of A2:A100. -- Returns the index of column A in which the B2 value was found. --...

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

  3. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    plan. NSFW will likely be blocked. Installing Stable Diffusion on a local server is the recommended stealth mode. Check out Matt Wolfe's video on how to do this: Youtube - Matt Wolfe - Install Stable Diffusion Locally. Ok it isn't MidJourney... But it's...

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

  4. Amazon Kindle: Send PDFs to your Kindlehttps://www.joellipman.com/component/content/article/amazon-kindle-send-pdfs-to-your-kindle.html?catid=121&Itemid=165

    to the Kindle format. Fix for PDF file now showing on the Kindle If that is the case, here are a few things you can do. Check if your Kindle is connected to the internet. Sync your Kindle device. To do that, go to the Kindle Home page and tap on...

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

  5. Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

    A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for...

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

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

    has figured this out and I'm just late to the party. How? Through the wonders of Zoho CRM Client Script. So we're going to check on page onload, onchange for the Create Page (Standard), Edit Page (Standard), and Details Page (Standard). My use-case has...

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

  7. Security Checklistshttps://www.joellipman.com/articles/cms/joomla/security-checklists.html

    the gist of http://docs.joomla.org/Security_Checkli … omla_Setup is as follows: Security Checklist 4 - Joomla Setup 1. Install official versions of Joomla 2. Change the default administrator username 3. Protect directories and files 4. Adjust file and...

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

  8. Clicking on a weblink returns a 404 errorhttps://www.joellipman.com/articles/cms/joomla/clicking-on-a-weblink-returns-a-404-error.html

    and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." Just check that the category the link is in is published.

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

  9. SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    Not sure why method 3 is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the...

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

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

    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 every other browser except Internet...

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

  11. How to run a .RUN filehttps://www.joellipman.com/component/content/article/how-to-run-a-run-file.html?catid=63&Itemid=165

    a terminal by going to Application > Accessories > Terminal Type 'CD Desktop' to go to your desktop folder Type 'LS' just to check the .RUN file is in this one Type 'sudo sh nameoffile.run' Through the Gnome GUI Right-click on the file you downloaded...

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

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

    used in parameter fields to UK format (dd/MM/yyyy). You can override this in the report by: Go to Design Select the View tab Check that the "Properties" pane is displayed/ticked Change Language under Report Properties > Localization to en-GB Save the...

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

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

    Now select the column that has just been created (usually "Group1") by clicking the grey part above it Delete this column. Check that the grouping grey part (a giant parenthesis) is still there. Right-click on the grey header of the tablix row again...

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