Tree View Question

alastair69

alastair69

Registered User.
Local time
Today, 12:34
Joined
Dec 21, 2004
Messages
562
Good morning from the UK,

I hope one of you can help me out.

I am looking at setting up a treeview for users, with the idea that it will be easier for people to use.

The data i need to pull of is as follows:-

The table i have is called tbl User Accounts, the true values could be set to false as well as true.

Top Node = User Names
Alastair Lane
Password norman27
AccessDatabase True
AccessUsers True
SalesInput True
ProcessInput True
AddClients&Contacts True
EditReports True
ApprovalOfAccount True
ImportReports True
ExportReports True
ManagementTools True
UnLockRecord True
Calls 35

Nevil Appleton
Password password
AccessDatabase False
AccessUsers True
SalesInput True
ProcessInput True
AddClients&Contacts True
EditReports True
ApprovalOfAccount True
ImportReports True
ExportReports True
ManagementTools True
UnLockRecord True
Calls 10


I am not sure how to even start this process so any examples would be good.

Alastair
 
Is this question in the right section can anybody tell me as i posted it this morning and i have still not got any responce.

Alastair
 
I am assuming you are using a table to allow access to areas of the database.

One of the databases I inherited has the same thing.

He has tables with users names and roles assigned to each person.

In a seperate table, it has what functions each role is allowed. That table then inturns drives the switchboard. The switchboard dictates what they can and can not do in the database.

Exp.

Manager
Reports = true
Update = True
Delete = True
Read = True
etc.

Admin
Reports = False
Update = False
Read = True
Delete = False.

Is that what you are refering too?
 
alastair69 said:
Yes this is exactly what i am after.
Click to expand...


I can't do it at this moment, but around 2 or so I will strip the database I have and send you only what I have so you can look at it.
 
selenau837 said:
I can't do it at this moment, but around 2 or so I will strip the database I have and send you only what I have so you can look at it.
Click to expand...

Many thanks, sorry for getting a bit upset i think it is the wrong time to stop smoking between Christmas and New Year.

Thanks again, you help is apreachiated

Alastair
 
alastair69 said:
Many thanks, sorry for getting a bit upset i think it is the wrong time to stop smoking between Christmas and New Year.

Thanks again, you help is apreachiated

Alastair
Click to expand...

Oh yeah, I feel your pain. I am quiting again. Tomorrow is my last day.
 
Try this.

I have included the classes and mods that run it.

I have commented some code out of the ModDec. Leave those commented out because they call upon classes that I didn't include.

If you have questions, please feel free to ask.
 

Attachments

Thank you i am having a look at it now and i will let me know if i have any problems or questions.

Alastair
 
Thank you very much for your help this sample database was very useful.

Alastair
 
alastair69 said:
Thank you very much for your help this sample database was very useful.

Alastair
Click to expand...

You are very welcome. Wish I could say I wrote it, but I didn't. It is in the database I inherited.

Good luck!
 
You must log in or register to reply here.

Similar threads

mloucel
Solved Use MouseUp and MouseDown
Replies
5
Views
509
Cronk
Cronk
P
MS Forms Tree View Slow Loading Issue
2
Replies
24
Views
1,407
Pac-Man
P
Mylton
Solved Difficulty with login and permission
Replies
16
Views
1,218
Mylton
Mylton
mloucel
Solved SubForm [Continuous Form] not updating data.
Replies
18
Views
835
mloucel
mloucel
M
VBA output report to PDF and email
Replies
18
Views
1,232
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom