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

  1. Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    The following exercise focuses solely on creating an app which opens Google Maps at your current location. How? I couldn't find any instructions using the tools I had (Android Studio) which is why I've written this article. Start "Android Studio" Go to...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  2. URL passed settings in Reporting Serviceshttps://joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    I'd put a note on how to remove the toolbar using the URL as I didn't find this clear on the net. Tried it and it didn't work. That's because I was using the Reporting Manager URL rather than the Reporting Server URL. Note: Change "" to the name of your...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. SSRS Dropdown parameter cannot be blank!https://joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    ("000000-0000-..."), this worked perfectly for me as my report didn't compare the 2 remaining dummy reports it couldn't find. It doesn't even mention them anywhere in the resulting report. One Issue The report will always load when opened defaulting to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  4. Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    at work. Instead I only have the one workstation :eek Still I've been asked to test some web applications (???) so I had to find a solution to suit me. I'd done this before IE7 (so a long time since). My office workstation setup for this is: HP CMT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  5. Error during processing - Converting Date/Timehttps://joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

    Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  6. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same problem, but I'm not sure for...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  7. 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

    a range) and the second the string to search (in this case a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from Sheet2. Note that there is a dollar in front of both column name (eg. "A") and the row number (eg. "1") so that these...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  8. Zoho Deluge - Hide Reset Button on Formhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-hide-reset-button-on-form.html

    So another quick note as I couldn't find a solution on the forums. This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here goes: Why? Because I can. And because as someone said, a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  9. Forgotten Super User Password in Joomla 2.5.x - 3.xhttps://joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

    The gist: Login to your Joomla database Go to the #__users database table (where #_ is the prefix to your joomla tables) Find the column password and the row of your known user and Copy the text there Find the row of your forgotten user and Paste the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  10. SSRS Border Problemhttps://joellipman.com/component/content/article/ssrs-border-problem.html?catid=75&Itemid=165

    This is where you are trying to select a cell to have an outline border but then cells around it without a border. You may find that BIDS or Report Builder (however you're building your report) will apply the border to some cells and sometimes a whole...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  11. On Gui Resize Eventhttps://joellipman.com/component/content/article/on-gui-resize-event.html?catid=48&Itemid=165

    events... The issue here is if you want to do something when a user resizes your program. If you search and search, you'll find that GuiClose responds to when you close the app, and GuiSize will run when you resize the app. Syntax: GuiSize: GuiControl,...

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

    Couldn't find this anywhere on the net and kinda needed it so am making a note of how to do it here. The issue is that I wanted to make my autohotkey program change the image that the mouse hovers over (within it's own GUI). No third-party component or...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  13. AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    ; -------------------------------------------------------------------------------------- ; Function: CountExistingInColumn2: Find in list view occurrences of new names column CountExistingInColumn2( v_Filename ) { v_AlreadyExists := 0 Loop, %...

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

    (or £10/mo). This includes keeping the servers up-to-date and running with the latest technologies. You are welcome to find and use your own website hosts with their own support plans and I can help you configure these for the source files (as per my...

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

    (Copy)=!" ECHO Renaming !oldName! to !newName! RENAME "!oldName!" "!newName!" ) This code will rename the files. I did not find a way to undo so just run the first code to double-check what you're about to do. Save and Close the notepad file Return to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  16. Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=53&Itemid=165

    auto-versioning) --- Version status (stable, RC, beta, alpha, etc) --- Parent Project Name --- Specify Download URL (or auto find?) --- Author / developer / team name (Free text / associated to uploader) --- Create Date / Modified Date / Expired Date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  17. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    by the api.openweathermap.org website. There are plans to shift this to using Google Services as they are more likely to find locations that openweathermap.org cannot. Add a comma and the two letter country code (preferably "iso-3166-1 alpha-2") to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. Zoho Templates - Font size is inexplicably tinyhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-templates-font-size-is-inexplicably-tiny.html

    in your HTML — this will be something like img src="https://crm.zoho.com/viewInLineImage?fileContent=: You should find your code now previews at a normal font size. Step #2 Create your template without uploading images and style with your CSS....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  19. Zoho Deluge - Counting in a Map dataTypehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-counting-in-a-map.html

    this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine the code or find a some short codes that will do the same. Why? I'm aiming to automate a process which counts the number of products...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  20. Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

    is called "Switch_Over_Day". For the first Monday, we are going to select the first day of the month and then loop until we find a Monday. Same for the last Tuesday except that we will count backwards from the end of the month:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
Results 41 - 60 of 168