Re: Use excel as database

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

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

--
Regards,
Tom Ogilvy


<deekaye@xxxxxxxxx> wrote in message
news:1132570801.660148.117520@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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?
>


.

Relevant Pages

  • Use excel as database
    ... We only have access to Excel 2003 on our computer and would like to ... edit and delete problems and solutions and assosciate certain ... excel user form only the solutions matching the problem should be ...
    (microsoft.public.excel.programming)
  • RE: URGENT- Form design and field tab-order problems
    ... creating an Excel User Form, but this would require you to get into the ... there is a TabIndex property for each control you could set. ... A requester sent several Excel files that have been formatted to print ... The reason the forms are in Excel is that all service techs already ...
    (microsoft.public.excel.misc)
  • RE: HELP: update access from excel userform
    ... Excel user form. ... new reocords using VBA code. ... "sam" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: Excel Automation - Export Txt
    ... Hey Peter, I have a similar problem like this when I try to connect the excem ... On my excel user form, ... submit button the data would be populated in the access database. ...
    (microsoft.public.excel.programming)
  • Re: Use excel as database
    ... - Excel form working as front-end for mdb file thru ADO library ... database operation based on worksheets functions ... edit and delete problems and solutions and assosciate certain ...
    (microsoft.public.excel.programming)