Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) |