Here’s how to make a reminder automatically pop up with a MessageBox when a date has expired. Q: Martin writes: “I keep trying to make a reminder that automatically pops up with a msgbox when a date has expired, but no luck… If cboPartshøringSlut >= Date Then MsgBox “Partshøringen sat til den: ” _ […]
More on creating mass emails with report attachments. Access Archon #135 When the database is opened, the CreateSnapshots procedure is run to automatically create report snapshots for the four reports in the database, in the DocumentsAccess Merge folder (this folder will be created if it doesn’t already exist, using methods of the FileSystemObject). The CreatePDFs […]
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 […]
