In previous Access Archon columns, I have discussed concatenation of dollar amounts (Access Archon #179), or children’s names and school subjects (Access Archon #230). In this article I discuss a more complex type of concatenation, where concatenation is done for sets of records filtered by three values. The Form The sample database, Complex Concatenation, has […]
Q: On one of my Access reports, strange light grey bands print here and there. What causes them, and how do I remove them? A: This is most likely because of the Access default setting for Alternate Back Color for group headers and footers in reports. Alternate row shading is an excellent feature for the […]
By Helen Feddema Access versions: 2007-2013 Level: Intermediate Access Archon #240: Introduction In a database (like the sample Northwind database) that records orders, you might want a quick and easy way to send order lists to customers. This article demonstrates how to send order lists to customers in both Plain Text and HTML format emails. […]
Q: Don Ruppel writes: “I am using Access 2010 to track my collection and have photos attached. I want to filter and list any records that do not have an attachment (photo) so I know which items that need to take photos of. Every time I try to filter the table or create a filter […]
Q: Jane writes that when she makes a new form by clicking the Form button in the Create tab of the Ribbon, all the controls are the same width, and she can’t resize them individually, as in older versions of Access. A: This is a “feature” of recent versions of Access. It is called Layout, […]
