Well, I'm no SQL guru...
but if a select works anything like a loop, you may not be able to do a check of:
Info* = NULL
Info* <> NULL
etc...
The reason I think this is we know, well almost know, that everyone probably has a name populated. Thus, this works fine. But we may not have gotten...
You may have to take into account what happens when the value is NULL. I remember adding code for this, though I don't remember if it was for department or another object.
Quick note, I think you need to loop through that recordset again so that you can extract distinct entries for departments... so you don't have repeating groups.
I see you did this for someone else... so it may not apply for you setup.
I was thinking about doing something like that... just no time. This is the "fun stuff" that I have to hold off on until other projects are completed.
A variation of that will work for the printable list I wanted to do though, as grouping by department is preferred. I'd just do...
YGM
I have some different features in my endeavor.
The ability to navigate up the org chart, assuming you have populated your manager field in ADUC. Found on the users details page (click on a user)
Email is setup to use the users email client. Just plain safer this way (spammers, jokers...
Many thanks Zac, works perfectly. I have hacked it up to do the following.
1. Removed the web based email function, using it internally so users will use their email clients for communication.
2. Changed it to default to a listing of all employees on load, instead of a blank page telling them...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.