Gant chart

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Alex

    Gant chart

    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
  • Art

    #2
    Re: Gant chart

    Microsoft Project works with Access Automation.
    Art

    "Alex" <alecjames1@hot mail.com> wrote in message
    news:4995a98d.0 308301247.472f2 dc2@posting.goo gle.com...[color=blue]
    > 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[/color]


    Comment

    • Alex

      #3
      Re: Gant chart

      "Art" <t@msn.com> wrote in message news:<3f512c80$ 0$54314$45beb82 8@newscene.com> ...[color=blue]
      > Microsoft Project works with Access Automation.
      > Art
      >
      > "Alex" <alecjames1@hot mail.com> wrote in message
      > news:4995a98d.0 308301247.472f2 dc2@posting.goo gle.com...[color=green]
      > > 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[/color][/color]

      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

      Comment

      • TC

        #4
        Re: Gant chart


        "Alex" <alecjames1@hot mail.com> wrote in message
        news:4995a98d.0 308310023.7b84e e01@posting.goo gle.com...[color=blue]
        > "Art" <t@msn.com> wrote in message[/color]
        news:<3f512c80$ 0$54314$45beb82 8@newscene.com> ...[color=blue][color=green]
        > > Microsoft Project works with Access Automation.
        > > Art
        > >
        > > "Alex" <alecjames1@hot mail.com> wrote in message
        > > news:4995a98d.0 308301247.472f2 dc2@posting.goo gle.com...[color=darkred]
        > > > 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[/color][/color]
        >
        > 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[/color]

        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



        Comment

        • Klaus Oberdalhoff [MVP]

          #5
          Re: Gant chart

          Hi,
          [color=blue]
          > All I want is a simple horizontal bar chart that I can program from
          > Access.[/color]

          you may look at this sample



          sorry, but all comments are german

          --
          mfg

          Klaus Oberdalhoff [MVP]

          Comment

          • TC

            #6
            Re: Gant chart


            "Klaus Oberdalhoff [MVP]" <kobd@gmx.de> wrote in message
            news:bito1f$6s3 $02$1@news.t-online.com...[color=blue]
            > sorry, but all comments are german[/color]


            As opposed to germane :-)

            TC



            Comment

            • TC

              #7
              Re: Gant chart


              "Alex" <alecjames1@hot mail.com> wrote in message
              news:4995a98d.0 308311057.432eb 8dc@posting.goo gle.com...[color=blue]
              > "TC" <a@b.c.d> wrote in message news:<106232481 2.57709@teuthos >...[color=green]
              > > "Alex" <alecjames1@hot mail.com> wrote in message
              > > news:4995a98d.0 308310023.7b84e e01@posting.goo gle.com...[color=darkred]
              > > > "Art" <t@msn.com> wrote in message[/color]
              > > news:<3f512c80$ 0$54314$45beb82 8@newscene.com> ...[color=darkred]
              > > > > Microsoft Project works with Access Automation.
              > > > > Art
              > > > >
              > > > > "Alex" <alecjames1@hot mail.com> wrote in message
              > > > > news:4995a98d.0 308301247.472f2 dc2@posting.goo gle.com...
              > > > > > 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[/color]
              > >
              > > Gantt charts aren't simple! They may *look* simple, but they are based[/color][/color]
              on a[color=blue][color=green]
              > > 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[/color]
              >
              > 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.[/color]


              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



              Comment

              Working...