[AccessD] Ten most common tasks/problems in Access

Arthur Fuller fuller.artful at gmail.com
Sat Oct 18 06:35:11 CDT 2014


Thanks, Stuart. Come to think of it, I do a lot of that too. I'll add it to
my list.

A.

On Sat, Oct 18, 2014 at 7:28 AM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> One that immediately comes to mind is maintaining multi-level hierarchies
> on a single form
> through cascading side-by-side continuous forms.
>
> I seem to do a lot of that.
>
> --
> Stuart
>
> On 18 Oct 2014 at 5:20, Arthur Fuller 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
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Arthur


More information about the AccessD mailing list