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 […]
How to print a report footer “page X of Y”, where X is the current and Y is the total. Q: Don Fox wants to know how to print a report footer “Page x of y”, where x is the current page and y is the total number of pages. A: Use the following expression […]