Using the Office Envelope Object in Office 2000 – what works and what doesn’t. Some readers have asked whether the Office Envelope Object (featured in Access Archon #122) can be used in Office 2000. Well, sort of. While writing the article, I tested the two procedures in Office 2000 and found that the Word procedure […]
This is the book you need for all those situations when Access security is required. access archon #120 Introduction I have always hated Access security. It is a pain to secure a database, and a nightmare to modify a secured database – and, after all that trouble, the database really isn’t that secure, as […]
A reader suggests using Acrobat Distiller to print forms as they look on screen, and more. Gabriel Linart wrote to suggest using the Acrobat Distiller to print forms as they look on screen, for checking form design or keeping a printed record of data entry.This is an excellent solution if you have the full Adobe […]
How to calculate and track elapsed time. We receive lots of questions about tracking elapsed time, which confuses everyone at first. If you’re working within the same 24 hour time period, you can use the simple expression [endtime] – [starttime] to return the number of hours and minutes spent on a specific task. When you’re […]
How to make the current row a different color for continuous forms or datasheet type subform (and for continuous forms-type main forms). Access Archon #173 Introduction When you have a form with a continuous forms or datasheet type subform, sometimes it is a good idea to highlight the current row by making its background a […]