Some readers suggest efficient alternatives to writing large quantities of text to a separate document, which is then imported into Word. Several readers wrote to suggest more efficient alternatives to writing large quantities of text to a separate document, which is then imported into Word. Robin Trew and Andrew Koch suggested using DocVariable fields, which […]
A reader’s having some problems backing up back end databases. Q: Bob Linthicum writes that he is having a problem with backing up back end databases using the code from Access Archon #151. He is getting Error 76, “Path not found”. A: Try my new Extras Plus add-in (Code Sample #20), which updates the backup […]
Q: Bradley Welland writes to ask if there is any information available on using ActiveX controls in Access. A: This continues to be a sore point, even in Office 2007. ActiveX controls (other than the few native ones) can’t be depended on to work the same in Access as in other hosts (such as VB), […]
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 […]
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 […]
