Introduction In my Working with Word ebook (the 4th edition is available now), there is code that lists (among other things) the document properties in a Word document. This is useful information, but sometimes you need to know which of the doc properties have actually been used; that is what the code in the sample […]
If you have a datasheet subform on an Access form, containing numeric data in some columns, you may want to have column totals at the bottom of the datasheet. You can do this easily in an Excel workbook or a Word table, using a formula, but Access does it differently. In Access 2007, column totals […]
If you get Error #5152 when running code that saves a file, check whether there is a date formatted with slashes (2/15/2010) in the file name. Slashes are not permitted in file names, so you will get this error when trying to save a file including a date in this format. To avoid this error, […]
If you import a macro from an Access 2010 or 2013 database into an Access 2007 (or earlier) database, it will look like this in design view: This is because macro format changed between Access 2007 and 2010 (and again between 2010 to 2013, though not as much in that case). The macro may still […]
Introduction A few years ago, in Access Archon #127, I showed how to make an Access form for entering timesheet data, which was then exported to Excel. That timesheet had combo boxes in the header to select a project and a week, and columns for entering data for the days of the week. This article […]
