i am building up an inventory system as a project.

the system has a master database whereby the user can either add in new
items or delete existing items using a user-interface. the user should be
able to search for the an item under either the category that it belongs to
or by keywords on the interface too.

currently, i am stuck at the parts on deleting existing items from database
on the user-interface and searching by keywords for the items. Could anyone
pls give some advise on how to do them?

Hi OneZero,

You may wish to look at Excel's built in Data Form:

Data | Form.

You may also wish to look at John Walkenbach's Enhanced Data Form, which is
more flexible and which, for a relatively nominal payment, provides access
to the source code:

http://j-walk.com/ss/dataform/index.htm


---
Regards,
Norman



"onezero" wrote in message
...
i am building up an inventory system as a project.

the system has a master database whereby the user can either add in new
items or delete existing items using a user-interface. the user should be
able to search for the an item under either the category that it belongs
to
or by keywords on the interface too.

currently, i am stuck at the parts on deleting existing items from
database
on the user-interface and searching by keywords for the items. Could
anyone
pls give some advise on how to do them?