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 […]
How to deal with unwanted or redundant indexes. While reading my new book, Expert One-on-One Microsoft Access Application Development, Garry Robinson (see my review of his Access Security book in Access Archon #120) wrote to point out that I didn’t mention that giving fields the suffix “ID” can result in an index automatically being created […]
How to group database objects in Access 97. Q: Ron McIntire would like to be able to group database objects in Access 97, similar to the built-in feature in Access 2000 and higher. Is there any way to do this? A: This could be done (in a limited fashion) by using a naming convention […]
Using the FindFirst method in a DAO recordset. Q: Peter Lucero is having problems using the FindFirst method in a DAO recordset based on a table, using the following syntax: Set Rst = dbs.OpenRecordset(tablename) A: This is because when you create a DAO recordset based on a table, without specifying the recordset type, it […]