Here’s the code to use to email Excel worksheets (using the Word envelope object). Access Archon #122 Access versions: 2002 and 2003 In Part I of this article I discussed how to use the Word envelope object to email Word documents and Excel worksheets, thus avoiding the pain of attachments being stripped off by overly […]
How to auto-populate City and State fields on a form when the user selects a Zip Code. Q: Joe O’Meara wants to auto-populate City and State fields on a form when the user selects a Zip Code. How can this be done? A: Here is a procedure that updates city and state from a […]
How to get full justification in a Memo field on a form. Q: Bronwyn Pugh writes to ask if there is a way to get full justification in a Memo field on a form (no jagged right edge).A: From Access 2000 on, there is an alignment selection (oddly named Distribute) for text box controls that […]
A reader wants to know if there’s a tool that sets up code for error handling. Q:Stephen Young writes to ask whether there is a tool for Access that sets up the code for error handling in a function or sub. A:There is no built-in tool for this purpose in either Access 97 or Access […]
How to find Outlook mail messages from a specific sender. Q: Ray in New Zealand writes: “I’m trying to link my Access db (Accommodation) to Outlook. I receive accommodation bookings from guests and would like to be able to click on a button on the guest data form which will take me to the emails […]
