Learning Materials 59 Screenshots, videos or full articles as references or learning new technology

Card image cap
Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

Card image cap
Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

Card image cap
Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

Card image cap
Most recent in Oracle DB

List the most recently added rows based on a date column.

Card image cap
Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

Card image cap
Checkbox.asp

A simple Classic ASP checkbox implementation, helpful for beginners. ...

Card image cap
Windows Clock

Restore Windows 10 clock to Windows 7 Analog clocks

Card image cap
Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

Hyperlink-Excel-Fix.zip

Card image cap
Classic ASP vs VBA

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...

Card image cap
Control the Panel

A set of commands (or shortcuts) allowing users to access Control panel items ...

Card image cap
Send To folder

Where can I find the SendTo folder? I always wanted to modify that list and ...

Card image cap
Windows God Mode

Control panel shortcuts part 1