"Alex" <al********@hotmail.com> wrote in message
news:49**************************@posting.google.c om...
"TC" <a@b.c.d> wrote in message news:<1062324812.57709@teuthos>... "Alex" <al********@hotmail.com> wrote in message
news:49**************************@posting.google.c om... "Art" <t@msn.com> wrote in message
news:<3f***********************@newscene.com>... > Microsoft Project works with Access Automation.
> Art
>
> "Alex" <al********@hotmail.com> wrote in message
> news:49**************************@posting.google.c om...
> > I am looking for a dll or ocx that I can use with Access to create
> > time charts. Could anyone point me in the right direction please.
> > Alex
Thanks for that. I was hoping to have something built in to my
application and I do not need all the complex functionality of MS
Project. I just need simple Gant charts.
Alec
Gantt charts aren't simple! They may *look* simple, but they are based
on a significant number of obscurely-interrelated task attributes: duration,
resource(s), optional lead/lag times, optional fixed start/end dates, %
commitment, etc. etc.
I think automating Project would be the way to go.
HTH,
TC
All I want is a simple horizontal bar chart that I can program from
Access. If the user had Project they wouldn't need my application
(assuming they could work out how to use it). My use is for a specific
application that allows start and end dates to be entered. Everything
works fine but I would like to add a graphical display. I know there
are OCXs that do this I was just wondering if anyone had experience of
any of them.
Could you do something using textboxes & adjusting their width at runtime?
For example, say you had two textboxes txt1 and txt2, one above the other,
running across the width of the form. Code like the following would make the
second one red, and 1/3 the length of the first one:
me![txt2].backcolor = rgb(255,0,0)
me![txt2].width = me![txt1].width / 3
With suitable calculations to determine the # and length of each box,
perhaps that would work?
HTH,
TC
