closign form properties window during runtime

  • Thread starter Thread starter Keith G Hicks
  • Start date Start date
K

Keith G Hicks

In Access 2000 (and beyond) MS came up with this not so cool idea to have
the form properties window available while a form is running (not just
during design). So once in a while when I send an update of a project to a
client I forget to close the properties window and then when they open up
the application to run it they get the properties window. It confuses
clients. So is there a way to make sure this doesn't show up ever during run
time or can I close it down in code when the program is running in the
production environment? Any ideas here?

Thanks,

:) Keith
 
Agreed that this is a very silly feature, but you can turn it off by setting
the Allow Design Changes property to "Design View Only".

It's the last item on the Other tab of the Properties box for the properties
of the Form.

You might consider setting up a default form that has the properties and
code you want so that you don't accidentally leave this thing set. Example:
http://members.iinet.net.au/~allenbrowne/ser-43.html

There are several other properties that should be turned off in the new
versions also for databases, tables, and fields:
http://members.iinet.net.au/~allenbrowne/bug-09.html
 
cool. thanks. i wrote some code to change that in all my forms in an mdb.
here it is in case anyone wants it:


Private Sub cmdAllowOnlyDesignViewChangesInForms_Click()

Dim db As Database
Set db = CurrentDb

Dim ctr As Container
Dim frm As Form
Dim doc As Document

Set ctr = db.Containers!Forms
For Each doc In ctr.Documents
If doc.Name <> Me.Name Then
DoCmd.OpenForm doc.Name, acDesign, , , , acHidden
Set frm = Forms(doc.Name)
If frm.AllowDesignChanges Then
frm.AllowDesignChanges = False
DoCmd.Close acForm, doc.Name, acSaveYes
Else
DoCmd.Close acForm, doc.Name
End If
End If
Next doc

MsgBox "All done!"

End Sub
 
Back
Top