EAE said:
I am wondering if you can create subtasks in the task
column in this template. if so how? I am trying to use
this database as a replacement for MS Project wich i
am not happy with.
I hope you have very modest expectations. Microsoft Project is the result
of tens of thousands of programmer hours over many years, and is a tool for
managing projects. The Access template is nowhere near as function-rich. In
a "previous incarnation" supporting mainframe project management software,
it was often clear that the users' expectations were the major hurdle.
I can remember once coming to the aid of the programmer responsible for the
project management software at a client, meeting with the rugged tough-guy
long experience project manager who didn't appreciate that he couldn't yell
at the p.m. software and make it say that the impossible could be
accomplished, as he could, and apparently did, with his subordinates. He
might define a task as requiring ten person-weeks, assign 5 people, and then
set a mandatory finish date one week after start -- and then call the
programmer telling her that the software was no good.
I haven't used the Project template, but as a start, please tell us what
version of Access are you using, where specifically did you get the
template, what specifically are you trying to accomplish, how are you going
about it, what do you expect, and where is the Access template-based
application not meeting your expectations.
You do, by the way, understand that the templates are only planned to be a
starting point for your own database application, don't you? You shouldn't
expect that an Access template, with a few options, is going to generate
something in the class of Microsoft Project. Well, I suppose you could
expect it, but if you do, you are likely to be sadly disappointed. Also
there is a vast amount of published information on Microsoft Project and
other manufacturer's project management software, and virtually none on the
Access Project template.
Larry Linson
Microsoft Office Access MVP
