Run-time error '2100' - Help Please

  • Thread starter Thread starter NFL
  • Start date Start date
N

NFL

I'm using Duane Hookom's daily schedule calendar as a template and am having
a heck of a time fixing the run-time error 2100 msg. The change I made was I
added 3 more doctors to the list. and adjusted the ReportColumn field width
to allow all 6 names to appear on the report. The report works, but would
not go beyond the 5th page (or calendar day) and that is where the run-time
error 2100 shows up.

I did notice that if I remove (omit) the error code, the report would print
fine and the textbox would not grow.

' Me.Patient.Height = DateDiff("n", Me.StartTime, Me.EndTime) * lngOneMinute

Thank you for your help!
 
Can I assume you are running the report "rptAppointByDoctor" where the
display is for a single day and multiple doctors? If so, are some days/pages
displaying ok and the error occurs when you hit a particular date?

Have you looked at the records for the page that cause the error? I expect
you have a start or end time that is unusually early or late.
 
You are correct and that fixed the problem.

One last question on this topic. I would like to use the
"rptAppointWeekly" report and came up with a same error (Run-time error 2100)
and the error shows up on this line .....

Me.Patient.Left = DateDiff("d", Me.WeekOf, Me.SchedDate) * 2160

When I omit that line, all of the appointments will appear on the far left
screen and overlap the time chart. I used the same tables and didn't change
anything to them. How can I make the appointments line up with the dates?

Thank you!
 
Do you have any "appointments" on Sunday or Saturday?
Do you have any appointments that would be rendered below the bottom of the
report section? What happens if you increase the height of the detail and
group sections to a couple inches taller?
 
Thank you again for pointing me out in the right direction! I removed the
weekends from the schedule and it works great now.
 
Back
Top