Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / August 2005

Tip: Looking for answers? Try searching our database.

Printing a tree

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gimena - 31 Jul 2005 15:45 GMT
Good evening to you all. Im sorry if  this message gets too long, eheh , but
its as short as i can get it.
Well, I have a slight problem printing a product tree that is organized as
follows. Well, there is a product name field, a product number, and product
origin.

ORIGIN     NUMBER  NAME
000               001         BUILDING
001              002         1ST FLOOR
001               003         2ND FLOOR
001                004        3RD FLOOR
002               005         APARTMENT
005               006        KITCHEN
005                007       RESTROOM
005               008        KITCHEN TABLE
004                005       APARTMENT

and so on. I didnt write the product names, because i dont know how to
translate them from portuguese. :)))
Well, the tree works as follows, the building contains the floors that
contain the apartments and so on, but an important detail is this last row I
added, because if I have referenced the apartment 005 and what it contains,
if it appears as a link in any other part of the table  linked to another
floor, it still contains the same rooms. Like a product that appears in many
parts of a product tree and doesnt need to be described again. Its easy to
structure this in a tree view, by adding branches recursively. But when I
want to print  this, I cant be adding the branches recursively to the form (
andI need to be printing the rows,  not the treeview, because the rows have
lots of other information). My problem is that the details section of a
report print real rows, and if apartment 005 shows in any other part of the
tree, its rows have already been printed. And anyway, if I want to take this
info to a report, there is no order in which i could arrange the rows to be
printed neatly as a tree, because each time i want to see the table i have to
assemble it again.
Well, again, Im sorry if the message got toooo long, but I hope to hear from
you!!!
Thanks 1!!!!
Jeff - 05 Aug 2005 02:59 GMT
I'm not sure if I totally understand
but it sounds like your needs may be met
if you had a TreeView that supported multiple columns
and also had direct support for printing

If I am correct, take a look at TList at
   www.Bennet-Tec.com

Also if TList looks good to you feel free to drop me
a note directly at Jeff @ Bennet-Tec.com
( Please include a copy of this note and your original post )

* * Please include a copy of this message with your reply

    Jeff Bennett
    Jeff@Bennet-Tec.Com

    *    Bennet-Tec Information Systems, Inc
    *    50 Jericho Tpk, Jericho, NY 11753
    *    Phone 516 997 5596,  Fax - 5597
    *    RELIABLE Components Make You Look Sharp!
    *    TList/Pro    *    ALLText HT/Pro    *    MetaDraw    *
    *    Custom Software Development Services Too.
    *    WWW.Bennet-Tec.Com
   
===================     ===================
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.