Properties' box pops up along w/ startup form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

When I open my dtabase now, the 'Properties' box pops up along w/ the form
that I have put in the 'Startup...' menu as the startup form. What setting
is there that causes this to happen so I can shut it off?

Thanks.
 
Pat Dools said:
Hello,

When I open my dtabase now, the 'Properties' box pops up along w/ the
form that I have put in the 'Startup...' menu as the startup form.
What setting is there that causes this to happen so I can shut it off?

Thanks.
Click to expand...

It's on the property sheet of each form, on the Other tab: "Allow
Design Changes". Change it from "All Views" to "Design View Only". If
you need it, I have a little code routine that does this for all forms
in the database.
 
Would love to see the code, Dirk!

Thanks!

Dirk Goldgar said:
It's on the property sheet of each form, on the Other tab: "Allow
Design Changes". Change it from "All Views" to "Design View Only". If
you need it, I have a little code routine that does this for all forms
in the database.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Pat Dools said:
Would love to see the code, Dirk!

Thanks!
Click to expand...

Here you are:

'----- start of code -----
Sub SetAllowDesignChanges(OnOrOff As Boolean)

Dim obj As AccessObject

For Each obj In CurrentProject.AllForms
DoCmd.OpenForm obj.Name, acDesign, , , , acHidden
Forms(obj.Name).AllowDesignChanges = OnOrOff
DoCmd.Close acForm, obj.Name, acSaveYes
Next obj

End Sub

'----- end of code -----

Paste it into a standard module, then run it like this to turn off the
run-time property sheet for all forms:

SetAllowDesignChanges False
 
Guys,

I ran into this problem on one of my forms. Gee - it's been driving me
crazy but is now resolved because of your comments. Many Thanks - Mike
 
Back
Top