Several readers have written to recommend using a certain format when date stamping files. In AW 7.04 I recommended date-stamping files using date formats such as “m-d-yyyy” or “d-mmm-yyyy”. The latter is the one I use most frequently, because it prevents confusion as to whether the day or month is in the first place. Several […]
How to change the names for the fields in the column headings. Q: Marlene H. writes: “I want to display more user-friendly names for fields in the column headings for the lists in combo boxes and listboxes – for example, Project Code instead of PrjCode. How can I do this? “ A: The text in […]
Some code or query expressions that were working have stopped – here are the updated applications. Recently, I have had to modify several Access 2000 applications that are currently running in Access 2002 or 2003 because code or query expressions that used to work have stopped working. The problems are all data type-related. It appears […]
How to email attachments using the Redemption Library – and avoid the Object Model Guardian. Mark Riddick wrote in response to Access Archon #114, Avoiding the Object Model Guardian with the Redemption Library, asking how he could email report snapshots using the Redemption Library (he used to do this with the SendObject method). I prefer […]
Here’s another way to strip a character from a text string, a simpler alternative to the StripCharacter function. Q: Robert Greiff writes to say that there is a simpler way to strip a character from a text string than the StripCharacter function I described in WAW 4.24. He proposes using the Replace function instead, as […]