Here’s a brief overview of my latest book, Expert One-on-One Microsoft Access Application Development. I wrote my latest book (Expert One-on-One Microsoft Access Application Development, Wrox) for experienced Access users, who know how to create tables, queries, forms and other Access objects, and have some familiarity with writing Access VBA code, but need help in […]
How to suppress printing of a record or a control on a report. Q: Luis Pelaez is looking for a way to suppress printing of a record on a report if the Balance Due field is zero. A: If you wish to just suppress printing of one or more controls, code like the following will […]
How to change the Overtype mode in text boxes to Insert mode. Q:John Lawrence is frustrated with the Overtype mode in Access text boxes, and wants to know if it can be changed to Insert mode. A:Yes, this can be changed in the Options dialog. Click the Keyboard tab, then select the “Go to start […]
How to set column heading text for datasheets. Q: Jane H. writes that she has started using a naming convention for form controls (Helen’s comment: definitely a good idea!), but now she is seeing the control names, with prefixes, as the column headings in datasheet subforms. Is there any way to remove the prefixes in […]
Access Archon #170 Before we finish this article a reminder that mass emailing should always comply with all local laws. More generally, you should ensure that all mailings are to people who have authorized the use of their email address for that purpose. Our purpose is to help you efficiently send emails from Access – […]
