How To Use Home and End Keys in Gmail in Firefox on the Mac OS

While I love my MacBook Pro, I have issues with certain things in the usability department. For instance, after all that talk about a controlled User Interface and cross-application consistency, we still get hit with some pretty annoying bugs. Just like trying to use the Home and End keys in Gmail in Firefox – the default method (where you hit Cmd+left for home, or Cmd+right for end) just doesn’t work. Solution? You have three actually, as below: If you need

Continue Reading

How To Search For ID Values In A Different Worksheet With Excel VBA

This Excel VBA function allows you to take a column of values (e.g. ID numbers) in one worksheet, and use that to get corresponding values that are in a second worksheet. If you understand SQL, it’s something like: SELECT b.country FROM idtable as a, countrytable as b WHERE a.id=b.id I’ll explain the scenario further with screenshots, but basically we have one worksheet having client IDs, and another worksheet having client IDs with their corresponding countries. The first worksheet looks like

Continue Reading

Difference Between Integer Types in MySQL and Their Max Values

In MySQL, there are 5 different integer types, and each type allows for different integer value sizes. In addition, each type can be signed or unsigned. If your value is always positive, then you can make your integer type unsigned. The following table shows the values that different integer types (signed/unsigned) can hold: Integer Type Start Value End Value TINYINT -128 127 TINYINT (Unsigned) 0 256 SMALLINT -32,768 32,767 SMALLINT (Unsigned) 0 65,535 MEDIUMINT -8,388,608 8,388,607 MEDIUMINT (Unsigned) 0 16,777,215

Continue Reading

How To Remap Keyboard Keys In Windows (Such as the with Apple Keyboard)

I use the Apple bluetooth wireless keyboard, but I use it with my Windows computer, not a Mac. I love it though, and I think it’s the best bluetooth keyboard around – the problem is, while most keys generally work fine, certain keys are missing. For instance, on the Apple keyboard, the command key is the Windows key by default, so that’s convenient. However, I don’t have the Home and End keys, which make text-editing cumbersome. Furthermore, I have no

Continue Reading

Site Footer

Sliding Sidebar

Disclaimer

The contents on this blog are not intended as professional advice. The author disclaims any liability, loss, or risk taken by individuals who directly or indirectly act on the information contained on this blog.