How to create a database with links to external documents. Q: I am looking for some information and examples for creating a database of documents….(Excel spreadsheets, PDF files, word documents, jpegs, and bimps). I would like to see an example of records with links to external docs, and perhaps an example of how to build […]
How to retrieve some commonly used folder paths using contemporary syntax. Access Archon #148 Introduction Back in 1996 or 1997 I wrote a set of articles for Office Underground Office Newsletter (that was the one printed on bright yellow paper) on retrieving various paths, such as the Windows and Office folder paths. Before Windows 95, […]
How to get accented characters in Access fields. Q: Ray Bona wants to know: “How can I get an accented character (e.g. e-acute, n with a tilde, or o with an umlaut, etc.) in text that I enter in an Access field?” A: One way is to create the accented character in Word (using Insert […]
Readers offer their solutions for calculating total hours. Many readers have contributed better (or at least different) functions or expressions as alternatives to the rather awkward method I described in AW 7.04. Here they are for your consideration, with my comments. (Bill Patterson’s contribution was described in AW 7.10). For testing and comparison, I am […]
Looks at the different types of item counts you can get for listboxes and combo boxes. Access Archon #132 Introduction Recently I received some emails from AW readers requesting help on counting selections in listboxes and combo boxes. This article deals with the different types of item counts you can get for listboxes and […]
