Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Location
    Netherlands
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Information at a glance (2000)

    Anyone any tips in how to display information so users get insight once they see my form?
    What do I mean:
    Query on Table with factories and Table on orders of each factory. How to display it like this e.g.:

    Factory1
    Order 1 of factory 1
    Order 2 of factory 1
    Order 3 of factory 1
    Factory2
    Order 1 of factory 2
    Factory3
    Order 1 of factory 3
    Order 2 of factory 3

    etc.

    It's quite illustrative when factory-names als in Bold-face.

    How can I do this?

    Is there a tree-view like in Explorer? I don't use Developers Toolkit!
    Or are there easy-to-use advanced versions of listboxes?

    Can anyone help?

    rettnuc.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Information at a glance (2000)

    Save yourself a lot of frustration and do it with an Access report. You can easily use sorting and grouping in the report to group by Factory and show the Orders in the detail, sorted by order number or date or whatever. You won't be able to control fonts, etc. in queries.
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Information at a glance (2000)

    Perhaps the easiest way is to use side-by-side listboxes. The Left (or Factory) listbox contains the factories, the Right (or Orders) listbox contains the Orders for the factory selected in the Left listbox. The rowsource for the Orders listbox must use value of the Factory listbox as a selection critieria. The AfterUpdate of the Factory listbox must include a requery the Orders listbox.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Information at a glance (2000)

    In addition to Mark's answer, If you need more than can can fit in a listbox, you can use two forms, with the order form linked to the Factory form by an Id. In the On Current of the factory form, you can update the query form the Order form.
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •