Looks at importing Excel data to Access databases. Q: Graham Alison has two Excel workbooks, and when he imports them into an Access database, he just gets the data, not the formats that make the spreadsheets work. A: Data is all you will get when importing from Excel. If you need special formatting or calculations, […]
How to format times and/or dates in the way you want to see them. Q: M. Schiller wants to know how to convert a time to the 12 hour time format. A: There is no need to convert – just use the Format function to format dates and/or times in the way you want to […]
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 […]
