By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Gant chart

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Art
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

Nov 12 '05 #2

P: n/a
"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
Nov 12 '05 #3

P: n/a
TC

"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

Nov 12 '05 #4

P: n/a
Hi,
All I want is a simple horizontal bar chart that I can program from
Access.


you may look at this sample

http://www.access-cd.de/tipps/3.zip

sorry, but all comments are german

--
mfg

Klaus Oberdalhoff [MVP]

Nov 12 '05 #5

P: n/a
TC

"Klaus Oberdalhoff [MVP]" <ko**@gmx.de> wrote in message
news:bi*************@news.t-online.com...
sorry, but all comments are german

As opposed to germane :-)

TC

Nov 12 '05 #6

P: n/a
TC

"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

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.