SharePoint 2007: Change profile picture with minimal permissionshttps://www.joellipman.com/articles/microsoft/sharepoint/sharepoint-2007-change-profile-picture-with-minimal-permissions.html

07 November 2013 profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given. Why? Because I can How? Setup an account with...

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

MS Excel: Convert a text to a numberhttps://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 #VALUE! How? The problem is that I have a column which includes the currency symbol as per the following image: I create another column with the symbol omitted using the formula: =SUBSTITUTE(B3, "₱", "") Which leaves the value as a literal string... Now...

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

SSRS Subscriptions cannot be createdhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 the exact problem. If you include linked images in the report (as in images not in the report itself but referring to other systems holding the images), then please refer to my article on SSRS External Images don't display. The answer to this error is...

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

Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 student surname contains non-alphanumeric characters and does not contain apostrophes -- eg. O'Brien will NOT be returned -- Other REGEXP Functions for Oracle: -- -- REGEXP_REPLACE(country_name, '(.)', '\1 ') -- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+')...

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

VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example...

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

Make bootstrap carousel responsive to swipehttps://www.joellipman.com/articles/web-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

14 December 2016 put forward by Mark Shiraldi: The code is minimal but does what it needs to do (tested on iOS) and doesn't appear to effect other javascripts. Put this in a JS: /*! Bootstrap Carousel Swipe jQuery plugin v1.1 | https://github.com/maaaaark/bcSwipe | MIT...

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

Zoho Deluge - Pad with leading Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-pad-with-leading-zeros.html

07 February 2020 There may be other articles out there documenting this but I can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though writing...

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