Just a quickie...

[kdm3]

Hi all,

I have a trivial question, but one which has been perplexing me for half an hour now. I have the requirement to create a lot of controls dynamically - basically I'm creating a gannt chart using Rectangles. I realised, quite logically, that the form to which I am writing must be in Design Mode. Hence the question is... How does one go about changing the view of an open form to design view, add some extra controls, and then move back to form view?

 

[Mile-O]

It's all in the DoCmd.OpenForm method. Check the arguments that can apply to this method.

 

[kdm3]

Thanks, I looked through the argumnts of the DCmd.OpenForm method as you suggested. But a question, is it possible to change the form view while a form is open, since the DCmd.OpenForm would tend to point toward having to close the form view of the form, open it again in design view do the necessary messing and close the design view, then open it again in form view - a lot of effort. Ideally I'd like to just change from form view to design view and back again without the need to close the form? Is this possible?

 

[Mile-O]

DoCmd.OpenForm Me.Name, acDesign

This works for me.

 

[Mile-O]

Wouldn't using a Chart be a smarter option for making a Gantt chart?

 

[kdm3]

My bad, as you said the DoCmd.OpenForm method works fine, I guess I tried to create a problem that doesn't exist.
In response to the second point, alas I am using an older version of access, and it doesn't have pivotcharts. Plus I found that it isn't all that difficult to create gannt charts.
The gannt chart is really a little add-on anyway, just to make the info more easy to understand - pictures are much easier to get your head round than text and numbers!?