Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 bit more time, you could tidy up the code to do multiple images. Note: I've updated the above code so that even if you have other objects in the GUI, hovering the mouse over other objects will no longer cause the search button to flicker. More...? How...

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

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 to fail (faking the disk size). I got badgered by my colleagues to splash out and get a worthwhile pen. Aside from some other failures, I decided to get the bulletproof, waterproof, fireproof, shockproof 32Gb USB Pretec Pen (as advertised by Gadget Show...

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

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 Version 1.0 + This is version 1.0 unless people have suggestions I don't see the need to release service packs and updates. OTHER NOTES: This program does not install other files nor is a setup. It was created in AutoHotkey and the download includes the...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 this isn't a problem for those that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?! I am in the middle...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 is how your report should look now. Result: You can even run/preview it and you should get the below: Formatting In other words, making it look pretty. I'm doing this now because you may not need parameters or events. The above should create your...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 time along the top. We select a matrix because this will automatically group the rows by room (you need to do this anyway otherwise it will look a bit like a staircase of bricks). 4. Design the Matrix: In other words, put where all the values are going...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 there is other documentation out there. I'm basing most of this article on the official Joomla 1.6 documentation: http://docs.joomla.org/Creating_a_profile_plugin and I want to use an example that worked for me. Important: This is for Joomla version...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 time it worked? Emails received since? Programs installed since? Alternative documents/programs to do this? Same errors on another computer? What are your workarounds? Protocol for Troubleshooting: Check system properties for RAM and CPU speeds Reduce...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 you have selected BMP then this has to be a "no_thumbnail_yet.bmp" file). Save it to the images folder which keeps all your other thumbnails for this module. No Semi-Transparency Effect? Not obvious but to switch this off, the parameter...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 include the Username check as well (…WHERE StudentID=@StudentReference OR StudentName=@StudentADAccount). And according to other web articles on this matter, I have to change the order of my parameters (I will be checking "Student Username" first as...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the photos....

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 on a network (ie. not connected to the internet), this program is extremely boring and doesn't do anything. But unlike many other similar programs which add to the network traffic, this program adds NOTHING to the network traffic, and therefore is a...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular report (which searches for results matching the...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 FROM student_accounts WHERE student_accounts.studentID = trim(:p_myparameter) ), '???') FROM DUAL; The other issue The "other" issue was the problem after all. The first query was erroring despite the stored procedure compiling successfully. An empty...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Proposed Budget i3 PC under £200https://www.joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 workstation upgrade running Windows 7 So another year gone and our workstations running Windows 7 are somewhat lagging when opening too many apps. The recent release of Windows 8 has led to a review of our developer's equipment and the verdict is that...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch...

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

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 In the Database Properties dialog box, click the Options page. From the Restrict Access option, select Single. If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections,...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 date). JoelLipman.Com will make the source files available for download 24/7 so in the event that we lose contact with each other, the project manager has the option of going to another developer with the source files in order to continue the work....

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 some time. Why? I have an Excel report which dynamically gets its content from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 Joke3:="If he were any more stupid, he'd have to be watered twice a week." Joke4:="He has two brain cells, one is lost the other is out looking for it." Joke5:="If you gave him a penny for his thoughts, you would get change." Joke6:="The gates are down,...

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