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