Search results

Sorry, not absolutely sure what you're asking. Lvl1Chk is a checkbox control with it's control source set to the db field Lvl1. Is this what you're confirming?

I could see the 'invalid use of null' being the result if some users not having completed any levels so the value in the Lvl field would be null.

Gasman Yes, each of the Lvln fields is a Y/N and the checkbox control's data source corresponds to the field.

DHookom and ..Doc_Man Thanks both for your very prompt response. Do not interpret my delay as disrespecting your diligence. >>With Access, as you might remember from 20 years ago,... Sorry Doc, I'm faking it until I make it here. I spent days looking at other forums and viewed some YT vids, and...

Thanks Gasman. That was a ditto for the previous line. The formatting was changed making it confusing. Sorry.

Overview: Students progress through a course of study broken into levels. When a level is complete, the user record is updated, indicating level completion via a Y/N field. On a report I want to graphically indicate level completion with an .jpg icon in an image control. (This is located in a...

I'm a mixed bag of much-forgotten information. It's been almost 20 years since I've done anything transferable to Access/VBA. Concepts remain but implementation is wanting. I programmed in VB3-6/VS. I'd characterize that work as (at least) advanced intermediate. I authored a robust 50KLOC...