[AccessD] Ten most common tasks/problems in Access

Arthur Fuller fuller.artful at gmail.com
Sat Oct 18 04:49:33 CDT 2014


I forgot an obvious task/problem that I have frequently needed in my
projects -- Office Integration -- using Access to create documents in Word
and Excel.

Arthur

On Sat, Oct 18, 2014 at 5:20 AM, Arthur Fuller <fuller.artful at gmail.com>
wrote:

> 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
>
>


-- 
Arthur


More information about the AccessD mailing list