Access Archon Column #230 – Making Concatenated Strings from Linked Tables and Multi-valued Fields Access versions: 2007-2013 Level: Intermediate Introduction Back in 2001, I wrote an Access Archon article (#89, Flattening Linked Data) which showed how to create a string of concatenated data from values in a one-to-many linked table. That technique is still useful, […]
Access Archon Column #229 – Fixing Normalization Errors Access versions: 2002-2013 Level: Intermediate Introduction Sometimes when you take over an Access database created by an amateur (or at least, someone with a minimal understanding of normalization), you will find data such as employee names stored in a Text field in the Orders table. If the […]
An interesting font idea from Spain – handwriting of homeless people turned into fonts. HomelessFonts.org is a series of fonts based on the handwriting of homeless people. For example, here’s the Francisco font. There are five fonts at present with more promised. Priced per font at €19 Euros for individuals and €290 for companies The […]
You can get match results automatically in Outlook Once great thing about Outlook’s Internet Calendar feature is that it can be updated automatically. The 2014 World Cup (football/soccer) is a good example. As we’ve already explained, you can make a separate Outlook calendar with the match schedule for your time zone then overlay that with […]
How to get the World Cup schedule into Outlook automatically. The football/soccer World Cup is about to start with 64 matches being played over the next month. Here’s how to get a reliable schedule into your Outlook calendar quickly and easily. Outlook lets you import an Internet feed of calendar items. This is better than […]