Re: North Wind Trading data base question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Thomas (wills.t_at_sbcglobal.net)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 07:01:51 GMT

Thanks Larry for the quick feed back

I have created a combo box that will display the categories in a drop down
window.
Now after selecting the category I want.
I would like it to display the products in the same window.

The version of Access that I have is 7
The Northwind Trading database has a form named (Orders) that under
product(Orders Subform)
has a drop down menu that displays only all the products.
Is their a way to create that same type of drop down menu that will
display categories first and then the products from that category.

I am not sure if Access can do this type of fuction or not?
and if so it maybe over my head to write it.

If it is possable and if some can rewite the Orders subform that controls
that fuction
I woud be happy to pay you for that service.

Any programers that can or will do that
e-mail me will.t@sbcglobal.net

Thanks
ToM tHe TilE gUy

"Larry Linson" <bouncer@localhost.not> wrote in message
news:eP#87ScJEHA.3084@TK2MSFTNGP10.phx.gbl...
> As a quick summary, without opening Northwind, seems to whittle the list
> down to manageable size, you'll need cascading Combo Boxes... that is
select
> the Category/Supplier in the first, and in its AfterUpdate event, reset
the
> RowSource for the second to only those products in that Category or
handled
> by that Supplier.
>
> On the other hand, a ComboBox with AutoExpand property = Yes will scroll
to
> the first match for the characters you have typed, as you type. If the
> thousand products have sufficiently unique names, that might work -- but
> from a practical view, I rather doubt there are that many unique and
obvious
> names for tiles.
>
> What version of Access are you using? If someone's going to open Northwind
> and take a look, they might as well open the right version.
>
> Larry Linson
> Microsoft Access MVP
>
>
>
> "Ask" <here@home.net> wrote in message
> news:G6Fgc.52870$AI4.27581@newssvr25.news.prodigy.com...
> > Hello
> > I would like to use MS Access for are small tile business.
> > using the North Wind Trading data base as a example that came with MS
> > Access.
> > In the Orders (form) their is a Orders subform (form) that lists
> > products.(list box)
> > North Wind Trading only has 77 products.
> >
> > My question is can I or how can I make the (list box) display Categories
> or
> > Suppliers and then display the products with in that category or from
that
> > Supplier as we have over 1000 products to deal with.
> >
> >
> > Thank in advance
> > ToM tHe TiLe GuY
> >
> >
>
>

Relevant Pages

  • Re: GDI+ Custom Control
    ... I have actually done this already; my first MFC program was a medical data display and I ... First, I would treat each of the "tiles" as being a separate window, each a child window ... You scroll the tile. ... So there would be one "tile" for Heart ...
    (microsoft.public.win32.programmer.gdi)
  • Re: FAangband 0.2.2
    ... with the double and triple tile implementation that I have never sorted. ... I suspect its to do the with way bigtile hacks the display code to skip ... Interesting to see *bands being so sensitive to the correct graphics setup, ...
    (rec.games.roguelike.angband)
  • Re: FAangband 0.2.2
    ... with the double and triple tile implementation that I have never sorted. ... I suspect its to do the with way bigtile hacks the display code to skip ... Interesting to see *bands being so sensitive to the correct graphics setup, ...
    (rec.games.roguelike.angband)
  • Re: Displaying in C# without DirectX
    ... experience in the language but none in game programming. ... what kind of control I would use to display the map and character. ... Tile & turn based movement, directional blocking, no diagonal movement. ...
    (rec.games.roguelike.development)
  • Re: Rendering a Climbing Player
    ... probably have a rounded system; for example, ... mountain, you would go along a path, then come across a '<' tile (not ... shades of grey idea. ... I also toyed with the idea of having the background of a tile display ...
    (rec.games.roguelike.development)