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 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 […]
Introduction If you want to delete a record in a form bound to a single table that is not linked to another table, you can just select the record and press the Delete key, or use two simple commands in VBA code. However, if the form’s source table is linked one-to-one or one-to-many to another […]
by Helen Fedemma 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 […]
