Re: Is Relational Hierarchy Possible with Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 06/23/04 

Date: Tue, 22 Jun 2004 23:15:05 -0400

the easiest is to turn on the macro recorder and apply the filter manually.
You can then turn off the macro recorder and adapt the code to meet your
needs. 

-- 
Regards,
Tom Ogilvy
"addi" <addi_s@hotmail.com> wrote in message
news:6f426fb3.0406221751.50c4e8e3@posting.google.com...
> "Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:<10dgeo2stmiql48@news.supernews.com>...
> > This is the exact behavior of the Autofiler (which puts the "comboboxex"
at
> > the top of the columns of your data).  No code needed. But if you want
to
> > apply and manipulate it with code, that is possible as well.
> >
> > -- 
> > Regards,
> > Tom Ogilvy
> >
> > "addi" <addi_s@hotmail.com> wrote in message
> > news:6f426fb3.0406212149.1cb0a04e@posting.google.com...
> > > All,
> > >
> > > I want to provide a data entry template to load equipment information
> > > for our customer sites, but I am struggling to create the 3 tier
> > > relationship within excel to perform this task.I am wondering if it is
> > > even possible to do automatic filtering via VBA code using more than
> > > one combo box to add records.
> > >
> > > My scenario is as follows.
> > >
> > > We need to add Equipment records for Customer Sites. The Site is 3
> > > levels down the Customer hierarchy as follows:
> > >
> > > Customer
> > >    --> Contract
> > >         --> Site
> > >
> > > So if we need to add Site specific equipment information, first we
> > > need to Select Customer Number, then in the next column-filter
> > > (Contract combo box) we need to select Contract Number associated with
> > > the Customer selected, and then in the next/3rd column-filter (Site
> > > combo box) we need to select the desired Site for that
> > > Customer-Contract. The question is how do I do all this in Excel and
> > > all programitically.
> > >
> > > For example, when we chose a particular Customer, the Contract combo
> > > box should only display, filtered Contracts that are associated with
> > > the Customer chosen. Similarly, once a desired Contract has been
> > > selected, the Site combo box should filter the Sites associated to
> > > that particular Customer-Contract.
> > >
> > > Please note that there are multiple Customers, each having many
> > > Contracts; and each contract can have many sites.
> > >
> > > I can provide data examples as well if needed.
> > >
> > > I'll appreciate any help anyone can offer. I need to perform all this
> > > programitically.
> > >
> > > Best Regards,
> > >
> > > Addi
>
> Hi Tom,
>
> Thanks for the reply. You have answered my first half of the question
> "if it is possible". Now the question is, how do I do that with the
> code. Are there any examples or resources that you can share or point
> to.
>
> Regards,
>
> Addi

Relevant Pages

  • Re: Customers- Contracts form problem
    ... Contract table is the CustomerID of that customer. ... To illustrate this you can try it directly in your query ... CustomerID - Autonumber - Primary key with no ...
    (microsoft.public.access.forms)
  • Re: Online Shopping Contract Advice
    ... if a customer is rejected legitimately by a risk ... contract that is fair to a consumer. ... The question is when the retailer becomes *obliged* ... to take the money from your card and it is not taken until I request it. ...
    (uk.legal)
  • Re: Customers- Contracts form problem
    ... customer info actually part of the contract record itself. ... In this case you would not use a combobox to lookup a ... contract/customer query that fuels your subform, ...
    (microsoft.public.access.forms)
  • Re: Another Scum ADT salesman
    ... What if the customer was lying, ... customers never lie so we should rush to judge the alarm ... not knowing the terms of the contract. ... last 8 installs 1 was a combo 1 straight burg and rest fire only. ...
    (alt.security.alarms)