How to create a simple Add-to Combo Box. Access archon #161 Introduction Back when my Access Archon column appeared in Office Watch (around 1998), and there were no code samples, in Access Archon #7 and #8 I described how to create add-to combo boxes that let users enter new list items on-the-fly. In this […]
At the end of Access Archon #159 (in AW 9.06), I noted that in some cases, multi-valued fields can replace complex code for add-to combo boxes. As it turns out, I have to take that statement back – I was relying on a feature that was pulled from Access 2007 at the last minute (that […]
How to have a form open to the last record. Q: Manjit Lota writes to ask how he can have a form open to the last record. A: There are several ways you can do this. If you want to use the form for data entry, change the form’s DataEntry property to Yes. Then it […]
How to create an Add-to Combo Box with a Data Entry Form. Access Archon #161 Creating an Add-to Combo Box with a Data Entry Form If you want to add new entries to a table that has more than one or two fields, a different technique is needed: opening up a form that has all […]
How to recover from an AutoNumber disaster. Access Archon #165 Introduction A standard AutoNumber type field (with its NewValue property set to Increment) should start at 1 (though it is possible to start with a higher number), and each new record should be assigned the next higher number, so the AutoNumber type ID field […]
