MS Access:Can't Add New Record to Subform

A subform we were entering data into stopped working. One day it was working, the next, it was not. The problem turned out to be the datasource; the underlying query started with "select distinct". For some reason, probably because there were duplicate records in the underlying table, the query caused the form to stop accepting edits -- it became a read-only query. The solution was to set the uniqueness to "no", which removed the "distinct" from the query.

Some posts on the web say as much: the record source has to be writeable, meaning it can't be a UNION, most JOINs, and DISTINCTs.

Quicker Reinstall of Windows (Vista, on an HP 530)

The specific computer probably doesn't matter, but it's listed there for deniability. The basic idea is to load up the service packs, and then do the online updates. This ends up saving a lot of time, so your computer can be ready in a day.

USB Booting System for Clonezilla SE, Diskless PC

(This article is good, but somewhat obsolete. I'm now doing something slightly different.)

This mini project took a USB hard drive, made it bootable, and then used it as a disk cloning network. It's worked very well.

MS Access: VBA CRC32 Function

Here's a CRC32 function based on the work at: cCRC32.

The main difference is that this is a function, and the crc32 table is not recalculated each time. If there's a way to do constant arrays, I'd like to know. I haven't found anything online.

Function CRC32(str As String)
    Dim crc32Table(256) As Long
    crc32Table(0) = 0
    crc32Table(1) = 1996959894
    crc32Table(2) = -301047508
    crc32Table(3) = -1727442502
    crc32Table(4) = 124634137

No More "Arabic" Numbers: American Numbers from Now Onward

I've been reading about the War on Terror and the potentially pernicious effects of Islam on western civilization and America, and have come to agree that we must purge our culture of this foreign inf

Sharing Slightly Older Printers with Windows 7 on a 32 Bit Windows Server 2003 Network: Driver Not Found

We have this somewhat old HP 2430 printer, which isn't really that old, but it's old enough that there are different drivers for XP/2000 and Windows 7 x64, and Win7 users are supposed to use in-OS or

MS Access: Showing "Continue..." Conditionally at the bottom of a Section in a Report

Maybe I'm missing something - but it looks like Access doesn't have this feature - to put "Continued..." or "More..." at the bottom of a section if the next section is on the next page. If it exists, please comment or email me at johnk@ the domain name of this site. I seriously hope it exists.

I have this complex report that is a little non-standard - and here's how I did it. The general technique is at this other post:
Printing a Repeated Section Message like "Continued"

A Short Guide to Some Asian Brands, like LG, Samsung, ASUS, Acer, Lenovo

When people go to buy computers or other electronics, they end up encountering some Asian brands that are unfamiliar.

How to Renumber the LAN (with New IP Addresses for a VPN)

If you want to VPN, there are some varied solutions, most of them not requiring a LAN renumbering, but with trade offs.

Information Technology Workers: an IT Labor Union?

If you have reached this page through a search engine, and are interested in IT organizations, please check out Bright Future Jobs. Their URL is

This is a short list of links to groups that organize or try to organize programmer labor unions and other computer-based worker unions, as well as lobby organizations. This document is undergoing constant revision.

Page News
I just found out about CyberUnions a podcast and community about FOSS and labor.

Printing Blues

What I learned today....

Back when there were only two types of printers, parallel and serial, it was a lot easier. But even then, there was this annoying issue of incompatible interfaces. Today, the three dominant interfaces are ethernet, wifi, and usb, which takes over the role played by parallel cord interfaces.

PHP DOM to Implement a Form Class with Pure HTML Templates

So, I had this painful gout attack today and was mostly bedridden. It sucked. But I got some reading done, which was nice. My mind wandered and came up with this idea (and a headache).

Languages, IMC Keywords, Zend Framework, and Bad Data (random caffeinated thoughts)

I'm getting back to setting up Drupal for LA IMC, but keep hitting little walls. I've decided I definitely want to extract proper nouns and keywords from the articles.

Set up a Personal bin/ for PowerShell

In Unix, people often create a folder, ~/bin and save their own programs and scripts there.

What is a Cat5 HDMI Extender?

More to the point, what the hell is a cat-5 HDMI extender?

Syndicate content