If you need to filter by a Text value, such as person’s name or a company name, you may run into this problem: An error caused by an apostrophe in a Text string This is because the apostrophe is a Text delimiter. The way I deal with this problem is to make a calculated field […]
Introduction Recently I had occasion to update an Access database that used a DateTimePicker ActiveX control for selecting times. This control had worked for many years (about 15 years in this case), but stopped working when the user updated to 64-bit Windows 10. I was able to replicate the functionality of the old ActiveX control […]
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 […]
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 […]
