This article describes several more variations of combo boxes, making them even more useful. Linked Combo Boxes You can use a set of linked combo boxes to filter a list, making it easier to get at the specific item you want to select. As an example, in the sample database (Specialty Combo Boxes, Part 2), […]
A regular combo box that gives you a choice of an item from a list (usually displaying items from a query or table) is very useful, but sometimes you need something more. This article describes several ways to expand the utility of a combo box. Hard-Coded List Combo Box When you have a small number […]
Back in 2002 I wrote an Access Archon article dealing with reference issues, among them the problem of certain references being upgraded when a database is opened in a higher version of Access, but not downgraded when it is again opened in a lower version. You might think that over the last 16 years Microsoft […]
Introduction If you need to print a report, or do some other Access task, on a regular basis, you can do this using a VBScript, a batch file and the Windows Task Scheduler. This article shows how. Access Database The sample database, Scheduling Task (AA 252).mdb, has some tables from the old Northwind sample database, […]
Introduction Back in 2004, I wrote an Access Archon article (Copying Records and Linked Records) that described a method for copying a record with possible linked data in another table, using an array based on form controls. This article describes a different approach, based on table fields rather than form controls, and also shows how […]
