parameter queries--too many of them!!!
hi,
I'm developing an application that largely depends on parameter queries
(around 20 of them) that are usually based on a certain number a user
selects
from a combobox on one of 15 or so forms. due to the nature of my data,
it is
stored in around 10 tables, many of which are one-to-many
relationships. the
problem is that many of the actions the application does require
parameter
queries and using them in VBA means you first need to create a new query
and
the SQL statement has to be coded each time. then i run into two
problems:
coding those damn things over and over is a royal pain
and
each time you run the code, you must delete the query created last time
because otherwise you get a 'query already exists error' (and you can't
use
'stored' parameter queries--they need to be created 'on the fly'). the
problem
here is that the database becomes enormous because of the repeated
creation
and deletion of objects.
my database will be used at three different sites and i'm not sure that
hard
coding the compact will be very effective....it will be used by people
who
have never used access before.
thanks!!!!
