Report Tree in an access Form

[Rudi]

Hi there...

I'd like to try and create a tree view of reports I'm creating in access...
but my reports have different categories, lets seay, I have 5 reports
related to machine hours, 6 relating weighing transaction, etc etc etc....

Is it possible and how do I it to create a explorer like tree view of my
reports? lets say the "folder" says weighbridge, and when expanded it shows
all ur weighbridge related reports etc etc....

I think this is possible, and if it is... maybe have a table that controls
wich report relates to which category.. and category names etc?

If you need more info I will gladly assist you in this... Thanks

PS: I am using SQL as connectivity so my access project is an adp file...
running: Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: )

Rudi Groenewald

 

[Albert D. Kallal]

You could certainly create table with the category, and the report name, and
the report description. (or, you could even use two tables, and have a
classing one to many relationship).

To display this, you can use two listboxes. Take a look at the following
screen shots to see what I mean:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

You could also use a treeview control, but it takes a bit more code, and
also there is issues of distribution. So, in place of a tree view, you could
use the above idea.

Also, I always build nice report screens. For some ideas on building report
screens, take a look at:

http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html

 

[Rudi]

Hey albert....

Thanks for all ur help,
That is egactly what I want, but if possible, could you give me a step by
step guide on how to do it? I am actually pathetic with vb coding and I'll
need some guidance... could you maybe mail me or could I mail you? mail me
on (e-mail address removed) and state SQL SERVER FORM HELP in the subject, cuase I
normally just delete mail from unkown mail addy's cause I presume it's
spam...

thanks once again, I hope u'll have time to help me on this.. thanks
Rudi