Restriced Access

B

Brian Stebbins

Hello all,

This may be a better post for project server newsgroup, but the replies
here tend to appear much faster and are easier to understand for me in this
one. So if you can aid me I'd appreciate it, if not, I'll try the server
group later... but I don't want to cross post and waste people's time.
Here's the background... I work for the engineering dept. in my company.
We have "release dates" for sections. The tasks tracked through my project
files are called sections... it's a small broken down portion of the
over-all job. First the section gets released to the print room and is
assigned a "release date" for that. The prints are made, and then sent to
purchasing so the parts can be ordered. ANOTHER "release date" is then
tracked for the same section. So now we have a "released to Print room" and
a "released to Purchasing". Currently all this is put into our Data General
and tracked there. In my MS Project file we track the sections being
released to print room, but once it's there it's very difficult for me to
get the "released to purchasing" date for each of thousands of "sections".
We wish to start tracking both "release dates" in Project, however, it's
difficult for us to get correct dates after it's left engineering.
Here's my request/ desired information. ONE person enters all the
"released to purchasing" dates into our Data General, and between ourselves
(in engineering) and herself (in data entry) we've agreed the best way to
track these dates would be to just have her enter those dates into Project
when she enters them into the Data General. However, we do not know how to
set it up so she can ONLY change that field in the file. I am wondering if
there is either a MS Project solution or a Project Server solution to this.
We only want her to have access to input the date into that ONE field and
change the "Released to purchasing" column from an (No) to a (Yes). I have
NO IDEA how to make it so she can only affect those 2 fields and not affect
the others. I don't even know if it's possible through server or project.
(We'd also prefer to limit what she sees, there is information she shouldn't
be privy to... however, that's not that important... we'd be happy if we
could just do the first part and limit her edit access) Please advise, and
BTW we're running 2003 for both server and project.
Thanks and keep up all the great work!!

-Brian Stebbins
Glasstech Inc.
 
R

Rod Gill

Hi,

no way to limit data entry in Project, but sounds like a good case for some
VBA macro work. Ideally to allow updating your data general and project
server all from the same text file or similar? Saves double-entry.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.project-systems.co.nz/
Email rodg AT project-systems DOT co DOT nz
 
B

Brian Stebbins

Thanks for the brain food Rod, I'll talk to our VBA guru and process for a
while... but I'll let you all know how we get along.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top