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

  1. Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

    if(v_CheckDateEnd.toString("E")=="Sun") { v_DST_EndTime = v_CheckDateEnd; } } info "Start Date (Next Year): " + v_DST_StartTime.toString("EEEE, yyyy-MM-dd HH:mm"); info "End Date (Next Year): " + v_DST_EndTime.toString("EEEE, yyyy-MM-dd HH:mm"); Yields:...

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

    An article on setting a date field to either the first Monday of the next month or to the last Tuesday of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the month is before the current date, then set it to the last...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  3. Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

    & Run the setup.exe Go to Start > Programs > Microsoft Virtual PC In the wizard, select "Create a virtual machine" > Next Name it (eg. Test VirtualPC 001) > Next Select the Operating System (eg. Windows XP) > Next Use the recommended RAM > Next Select...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  4. MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

    code Sub SplitData() Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next xTitleId = "JoelsTooCoolForExcel" Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Specify Data Range",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  5. Keyboard and mouse shortcuts in Google Chromehttps://joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

    at the specified position number on the tab strip. Ctrl+9 Switches to the last tab. Ctrl+Tab or Ctrl+PgDown Switches to the next tab. Ctrl+Shift+Tab or Ctrl+PgUp Switches to the previous tab. Alt+F4 Closes the current window. Ctrl+W or Ctrl+F4 Closes...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  6. Mediawiki Extension for Camtasia Studio SWF videoshttps://joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    Studio and produce the SWF files Finish doing your video Go to File > Produce Video As... > Custom production settings > Next Select 'Flash (SWF/FLV) - Adobe Flash Output' > Next ExpressShow (complete optional settings) > Next Video Info (complete...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  7. Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    on "Reports" in the Solution Explorer > select "Add New Report" Select the "Shared Data Source" you just created > Next Click on the "Query Builder" button Right-click on any empty space in the first frame > Select "Add Table..." Add and specify the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. Android: Replace return key with done, go, send...https://joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

    date time // selectable time android:imeOptions normal actionUnspecified actionNone actionGo actionSearch actionSend actionNext actionDone actionPrevious IME_ACTION(s) IME_ACTION_DONE // the action key performs a "done" operation, typically meaning...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  9. Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

    doing was wrong or whether a warning is necessary to explain it to you. If I do not give a warning, I will skip ahead to the next step in the penalty list. Muting - This is where you are not able to talk on the board. You may still view it. Temporary...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  10. Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

    it and select "Drop-down List Box Properties" Under "List box entries" select Look up values from an external data source Next to "Data source" click on Add Select "Create a new connection to" and then Receive Data Select SharePoint library or list Copy...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  11. Slideshow div layer through a windowhttps://joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

    of the displayed slide. Hide currently displayed slide to expose the first slide again (restores the starting position of "next slide"). The Gist Strategy This may not be a great idea, I'm just trying something out. The brief was pretty much just...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
  12. SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

    me when I had blank rows in a flat file, where it appeared to add the special carriage return or line feed characters to the next viable row, see my original data file here (sample data): And this is what a Data Viewer returned when executed: My columns...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  13. Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

    a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous week. This is a follow on from my other articles on restyling Creator: Zoho Creator: Change Radio into Tabs and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. MySQL day of week ending on Fridayhttps://joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

    - DAYOFWEEK( DATE_ADD(givenDate, INTERVAL 1 DAY) ) ) DAY ) AS WeDate -- yields -- 2012-04-27 -- this Friday -- 2012-05-04 -- next Friday -- 2012-05-04 -- next Friday Not sure why this works, thinking about it hurts my head but it worked with my test...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  15. Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

    Client Script Configuration: Login to ZohoCRM as a system administrator and go to the Setup page (cog icon in the top right next to the profile image) Under "Developer Hub" go to "Client Script" Click on "New Script" button (the blue one - not the "Add...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Uninstalling AEC Central and installing Community Builderhttps://joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

    Community Builder 11. Click on the Tools link and click on Synchronize Users 12. Go to Extensions > Module Manager 13. Tick next to CB Login, CB Workflows, CB Online and click Enable 14. Return to Components > Community Builder > Configuration 15. Click...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  17. Windows 7: System Clock is constantly going out of synchttps://joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

    Click on Change date and time settings link Click on the tab Internet Time Click on the Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  18. Windows Live Messenger: Error 80048820https://joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

    Click on Change date and time settings link Click on the tab Internet Time Click on the Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  19. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    to the name of your new Joomla 3.0 database (don't change the table prefix for the new Joomla and instead do this as the next step). Rename any instance of "my_new_database.my_prefix_" to the name of your new Joomla 3.0 database (note that we're...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  20. SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

    act as a confirmation page (already holds the parameter passed to it from the previous page and that it will pass to the next page which executes the stored procedure) So this is the 3rd page which will actually execute our stored procedure. Here we...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 1 - 20 of 101

Please publish modules in offcanvas position.