Urgent Help Please -- FORMs

[Giri Palakodeti]

Do we need to open a form in design view only for changes and saving the
forrm
thru VBA code?

DoCmd.OpenForm rs1("Form"), acDesign

' Make changes here ..set propery changes

DoCmd.Close acForm, strFormName, acSaveYes

 

[Maurice]

Yep, or manually make the changes but that's not what you're after. So your
setup will work.

hth

 

[Klatuu]

It is not necessary to open a form in design mode to make changes to form
object properties. You can do almost everything in form in form view.
There are two considerations. First, when you close the form, you want to
tell it not to save the changes:
Docmd.Close, Me.Name, acSaveNo

Second, you do not want to add controls to your form during runtime whether
you save the changes or not. Each form has a life time limit of 754
controls. That count is cumulative. That is, when you add a control, the
count increments by 1, but when you delete a control, the count does not
decrement. This means that in a very short period of time, you form be stop
working.

 

[Giri Palakodeti]

I was just resizing the controls. So all I want to do is change property
value and want to SAVE form. How can I achieve this?

 

[Klatuu]

DoCmd.Close acForm, strFormName, acSaveYes

 

[Giri Palakodeti]

I tried opening some Sub-forms in normal view but tsome of the forms expect
some initial value/INPUT value to open in normal view.
Those forms fail to open and the changes wont be applied to those forms ?

What is the work around for such cases?

 

[Klatuu]

The only thing I can think of is to open then on their own rather than as a
subform to make the changes.

What you are doing is rather unusual. What is it you are trying to
accomplish?

 

[Giri Palakodeti]

I know it is unusual. I had close to 1000 cosmetic changes done by X person.
I had a tool that picked up differences between source safe code and changes
done outside.
I uploaded into a table all the changes
Form name , Control Name, Property Name, Old Value , New Value.

I am trying to programatically change the Property values by looping.

I have issues while opening a Sub-Form in design view.

"This form or report is already being designed as a subform or subreport. To
open this form in Design view, select the subform or subreport and click
Subform in New Window on the View menu."

Any help.

 

[Klatuu]

The only way you can work around that problem is to be sure the main form is
not open at the same time.