[AccessD] Ten most common tasks/problems in Access

Arthur Fuller fuller.artful at gmail.com
Sat Oct 18 04:20:55 CDT 2014


For a writing project I'm working on, I want to compile a list (doesn't
have to be precisely ten) of the most common tasks and problems faced by
Access developers. Perhaps I should explain my use of these terms. First of
all, I do not mean problems with Access itself.

In the first category I mean things like writing form_load and form_open
code; creating combo-boxes whose source is a named query or Select
statement; writing code to open a second form (for example, when a
double-click on one form automatically opens a second, related form); that
sort of thing.

In the second category, I mean such things like creating master-detail
forms; creating forms that will enable the user to perform complex queries
(parsing the query form and assembling the SQL from the values chosen by
the user). I suppose that into this category might go the need to write
complex processing code that has little or nothing to do with forms;
writing custom UDFs that don't exist in Access, passing values from one
form to another; creating nested reports.

I don't want to rely solely on my own experience in assembling this list.
So I'd like to reach out and take an informal poll here and see what you
think.

-- 
Arthur


More information about the AccessD mailing list