[AccessD] Most common problems/situations

Arthur Fuller fuller.artful at gmail.com
Tue Aug 19 11:07:51 CDT 2014


I'm trying to gather a list of the most common problems and situations
faced by an Access developer (strictly referring to design/coding/form
types/control types/classes, etc., and leaving aside problems such as
time-and-billing, getting paid in a timely fashion, how to factor into your
billing rate the depreciation on your hardware and software investments,
etc.).

The initial ones that come to mind are:
- Input masks
- Master/Detail forms (could be nested, as in Customers/Orders/OrderDetails)
- Combo boxes (also involves Cascading Combos and NotInList behaviour)
- List boxes (also involves NotInList behaviour)
- Linked forms (a pair of forms; navigation on either causes navigation on
the other)
- Office Integration (links to Excel, Word, Outlook,etc.)
- Custom Nav buttons (assuming you don't like those built-in)
- On-the-fly creation of new forms/dialogs/reports
- Search and Filter facilities
- Reports scoped to either the current row, or criteria
- API calls
- Export current record/report to PDF and email same
- (Advanced) Creation of custom classes, most commonly custom controls

These are the common problems I have commonly faced and addressed. Do you
have others to add to this list? Eagerly seeking addition to this list.

-- 
Arthur


More information about the AccessD mailing list