Gantt style chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is the Gantt Style chart avalible inside of Access 2003? if so how is this
carried out to generat a report or produce a chart on a form.


I hope you can assist me...
 
Hi Duane, how do i make that example calendar report (rptAppointWeekly) work
for a 7 day per page?

regards,

Colin
 
You would need to modify this line of code in the On Format event of the
detail section. The WeekOf column returns the Sunday date of the week so a
Monday record sets the Left property of the text box to 1*2160.
Me.Patient.Left = DateDiff("d", Me.WeekOf, Me.SchedDate) * 2160
You may need to add 1 to this expression and reduce the 2160 to about 1500.
Try:
Me.Patient.Left = (DateDiff("d", Me.WeekOf, Me.SchedDate)-1) * 1500
 
I've been trying to make use of this example to create a schedule very
similar to this. I seem to be having some difficulty deducing the full
extent of the layout though. I see, by process of playing around with
varying values, how the Detail_Format subroutine places and sizes the
various appointments. Initially, the 2160 value placed some of my
"Events" outside of the report size range, so I changed those around
until I didn't get the error.For clarification, I'm creating a patient
schedule who may have different appointments throughout a given day
with different doctors so; essentially a reversal of the example
layout.

Once I changed that value, I got the first page of the report to
display correctly. However, I'm getting a mysterious type mismatch when
trying to get to any subsequent pages. One thing that I dropped, and
can't seem to ascertain the explicit need for, was the relationship to
a table containing ReportColumn records for each doctor (patient in my
case). Initially this was due to the inability for me to ascribe a
different column for a variable number of patients. I'm starting to
suspect I missed something that this is being used to define.

Any suggestions on how to adapt this example for use with a variable
number of individual schedules and clarifications on my
misunderstandings of the way this is working are most welcome.
 
Ok, the provided example is great for a 9-5 day but is it possible to allow
it to run with data that will operate over a 24hr preiod? i now require a
gantt chart to display machine avalibility to can span over days, can this be
done?


Colin
 
Ok, next thing that i need to be able to do is have a Gantt Chart that can
operate with time that span overnight or over many days showing machine
avalibility.

the previous example provided was a 9-5 working day, i need to modifly this
code to run over 24hrs, can this be done?


regards

Colin
 

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

Back
Top