Hi Guys,
I'm trying to create a Gantt chart view to a database I made to keep track of projects in our company. My goal is to make something like this Guy did:
https://www.youtube.com/watch?v=5ROcHYyl1yw . I started with drawing the calendar you see in the right part of the screen in that video. I decided to create it on the fly with VBA on a subform. There's 1 problem (at least for now there's 1): form/report can only have width of about 22 inches. This allow me only to have about 60 days schedule to view (assuming I've given about 0,7 inch for a single-day cell). This is way too little. Moreover, that guy in that video worked it around somehow - he has at least 1-year schedule view in the subform. How did he manage to achieve that?
I thought the only way was to make cells way smaller, let's say 0,1 inch, and then zoom the subform in somehow on the runtime. I discovered, though, that you can't really zoom forms. I changed form for report, because you can display it in preview mode, which allows zooming. This works, but report in preview mode is just very clumsy solution, it doesn't suit my needs. There's got to be better solution! Is there any activeX control that guy used instead of subform?
Robert