| | |
|
|
|
Properties Window |
|---|
| message from PeterM on 18 May 2004 |
I'm running Access 2003 with a Access 2000 formatted
database.
Because of things I cannot control, all forms displayed
in the database must be modal...which is fine. However,
I cannot find anywhere in any documentation where you can
dismiss, or close the Properties window when opening a
form. I have people running all different versions of
Access and cannot use an MDE file so I create a copy of
the database and set the startup options not to display
the database panel. That way only the forms are
displayed. However, when a form is opened, that stupid
Properties window opens up and it cannot be closed
because the form is always opened as modal.
How can I (using VBA code in the Open event) close the
properties window?
|
| Allen Browne replied to PeterM on 19 May 2004 |
Peter, you can set the Properties window so it only displays in Design view.
Open your form. Open the Properties box.
On the Other tab, the last item is Allow Design Changes.
You cannot set this property while the form is in use, but if you have lots
of forms, you could loop through each AccessObject in
CurrentProject.AllForms to get their names, OpenForm each in design view
(Hidden), and set the AllowDesignChanges to False.
If you have multiple users with different versions, hopefully you have split
the database (Tools | Database Utilities | Database Splitter), so that each
user can have their own local front end in their own version.
|
| Fred Boer replied to PeterM on 18 May 2004 |
I am sure you can use VBA to do this, but have you tried setting the "Allow
Design Changes" to "Design View Only" in the property settings for your
forms? I believe that this will prevent the display of properties sheets in
form view.
HTH
Fred Boer
"PeterM" <anonymous@discussions.microsoft.com> wrote in message
news:ee4901c43d45$b5e814a0$a601280a@phx.gbl...
|
| Graham R Seach replied to PeterM on 19 May 2004 |
Peter,
In the Properties dialog for each form, select the [Other] tab. Then set the
[Allow Design Changes] property to 'Design View Only'.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
"PeterM" <anonymous@discussions.microsoft.com> wrote in message
news:ee4901c43d45$b5e814a0$a601280a@phx.gbl...
|
|
Archived message: Properties Window (MS Access Error Message)
