Here’s a quick solution to get databases linked again if the Linked Table Manager is missing from the Database Utilities menu. Q: Jeanne M. writes: “I sent new back-end and front-end databases to a client, and told him to re-link the front-end to the back-end, but he said there was no Linked Table Manager on […]
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 […]