ADD FUNCTION

  • Thread starter Thread starter DARREN
  • Start date Start date
D

DARREN

HI THERE

I HAVE DEVELOPED A PROGRAM IN ACCESS AND I WANT TO COMPILE
IT WITH OFFICE DEVELOPER, THUS I WONT BE ABLE TO UPDATE
THE DESIGN.

I NEED TO ADD PRODUCTS TO THE PROGRAM IN THE FUTURE. EACH
PRODUCT IS ASSIGNED TO A QUERY AND I WAS WONDERING IF
THERE IS ANY OTHER WAY THE USER CAN SIMPLY JUST INSERT THE
NEW PRODUCT AND AN UPDATE TO THE PROGRAM WILL BE MADE?

ANY SUGGESTIONS

THANKS
 
HUH!

Do not type in all uppercase; considered rude in newsgroups.

Would you care to explain what you mean by 'each product is assigned to a
query'?
 
sorry!!!!
at the moment i have a range of products - each with its
own query.
each product has its own button - which is linked to its
query.
if i give this program to alot of people, i would like an
add product section where it can be easy to update the
product range.

Thanks
 
sorry!!!!
at the moment i have a range of products - each with its
own query.
each product has its own button - which is linked to its
query.
if i give this program to alot of people, i would like an
add product section where it can be easy to update the
product range.
Click to expand...

It sounds like you might benefit from a Parameter query. If each of
these Queries just has a different product name as a criterion, you're
not taking full advantage of Access! You can use a criterion of

[Enter product name:]

and the user can type the name of a product and have the query search
for it; or, even better, you can have a Combo Box on your form
displaying a list of all the products, and use a criterion of

=Forms![NameOfForm]![NameOfComboBox]

as the criterion.

It's NOT necessary to redesign your database when the data in it
changes. It's not even a good idea!
 
Back
Top