Use excel as database
 

We only have access to Excel 2003 on our computer and would like to
build the following form.

It should have a combo box populated with a list of problems.
It should have another populated with a list of solutions.

Each one these should be bound to some sort of data source and be able
to add, edit and delete problems and solutions and assosciate certain
problems with solutions.

Also we should be able to assosciate certain solutions only with
certain problems such that when the first combo box is selected on our
excel user form only the solutions matching the problem should be
displayed.

I know how to do this in a relational db such as Access, but without
access is it possible to do it in Excel and could someone explain how?

Use excel as database
 

On way is demonstrated by Debra Dalgleish using Data validation Dropdowns:

http://www.contextures.com/xlDataVal13.html

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
We only have access to Excel 2003 on our computer and would like to
build the following form.

It should have a combo box populated with a list of problems.
It should have another populated with a list of solutions.

Each one these should be bound to some sort of data source and be able
to add, edit and delete problems and solutions and assosciate certain
problems with solutions.

Also we should be able to assosciate certain solutions only with
certain problems such that when the first combo box is selected on our
excel user form only the solutions matching the problem should be
displayed.

I know how to do this in a relational db such as Access, but without
access is it possible to do it in Excel and could someone explain how?

Use excel as database
 

I suggest one of below methods:
- Excel form working as front-end for mdb (Access) file thru ADO library
(I've done some apps this way,and it works really well and stable). Then you
doesn't need Access, only MDAC packet. If you have some experience in Access
(so I ;-) you'll be enyojed possibility working on SQL syntax
-if database doesn't require a lot of rows simple way could be make basic
database operation based on worksheets functions

Good Luck
MaC

Uzytkownik napisal w wiadomosci
oups.com...
We only have access to Excel 2003 on our computer and would like to
build the following form.

It should have a combo box populated with a list of problems.
It should have another populated with a list of solutions.

Each one these should be bound to some sort of data source and be able
to add, edit and delete problems and solutions and assosciate certain
problems with solutions.

Also we should be able to assosciate certain solutions only with
certain problems such that when the first combo box is selected on our
excel user form only the solutions matching the problem should be
displayed.

I know how to do this in a relational db such as Access, but without
access is it possible to do it in Excel and could someone explain how?

Use excel as database
 

Thanks Tom, but I'm actually using user forms not worksheets and I
would actually like to work purely in Excel no access component, as
bizarre as that sounds. I'm not sure if we have that component on our
PC's. Surely someone must have attempted something like this. No
links for me?

Tom Ogilvy wrote:
On way is demonstrated by Debra Dalgleish using Data validation Dropdowns:

http://www.contextures.com/xlDataVal13.html

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
We only have access to Excel 2003 on our computer and would like to
build the following form.

It should have a combo box populated with a list of problems.
It should have another populated with a list of solutions.

Each one these should be bound to some sort of data source and be able
to add, edit and delete problems and solutions and assosciate certain
problems with solutions.

Also we should be able to assosciate certain solutions only with
certain problems such that when the first combo box is selected on our
excel user form only the solutions matching the problem should be
displayed.

I know how to do this in a relational db such as Access, but without
access is it possible to do it in Excel and could someone explain how?