Author Archives: Robert

Convert Your Mac QuickBooks Company to a QuickBooks for Windows Backup (QBB) and Vice Versa

  1. Open your QuickBooks company as the admin on the Mac.
  2. Open the File menu, select Export, then To QuickBooks for Windows.
    • If prompted to Verify before backing up, do it.
  3. Choose a location for the new QBB file, then click Save.
  4. Confirm all remaining prompts.
  5. Copy the QBB file to a Windows PC.

How to Restore a QuickBooks Backup File (QBB) on Windows

Continue reading

Caps Lock Alert for Password Input Fields

<input type="password" id="password">
<span id="warning" style="display:none;color:#c00">[Caps Lock]</span>
document.getElementById("password").addEventListener("keyup", function(event) {
  document.getElementById("warning").style.display = (event.getModifierState("CapsLock")) ? "inline" : "none";
Excel VBA

VBA EXCEL: Duplicate Comments to Matching Cells of Another Spreadsheet in the Same Workbook

I have an Excel workbook with 13 protected sheets, January through December plus a Summary that needed the same cell comments for each month.

There were 2 options…

  • Type comments into each sheet manually; then update 11 sheets (Feb-Dec) by hand whenever comments need changing 😬
  • Add VBA code to the workbook that automatically duplicates cell comments from January (unprotected) to February through December (protected) when those sheets are activated 😎
Continue reading

Add Pattern Support for HTML5 Input Type Number with jQuery

Ran into an issue earlier today that I could not figure out and ended up asking my second question on StackOverflow in seven years.

I was trying to use <input type="number" pattern="[0-9]{8}"> to enforce 8-digit numbers while allowing leading zeros. This was being done on an optional field (no required attribute) and I could not understand why it was bypassing my pattern on the populated field (eg: value “1234” was accepted, pattern ignored).

Continue reading