Undesirable Form's Property behaviour

[Hermawih]

I am not sure if this happen to you.

We did one experimentation

1. Create a new database in Ms Access 2002/2003-named it db1.mdb
2. Create a new form name it form1
3. Create mde for that db1.mdb and named it db1.mde
4. Close db1.mdb and open up db1.mde
4. Set the startup property for db1.mde if you like
5. Close db1.mde
6. Open db1.mdb
7. Open form1 and that form property
8. Close db1.mdb
9. Open db1.mde and open form1.

You will see that the form property which was opened by db1.mdb is still
opened in db1.mde. This should not be the behaviour that we want, Although
you can not change any property in mde format.

we want to try to solve this by using Access.Application.setOption to set
access property but have not find the property we are looking for.

Please comment if there is any update to fix this or if your Access
2002/2003 does not behave like mine.

Thanks

 

[Arvin Meyer [MVP]]

Before you make the mde you need to fix each form property. The last
property on the "Other" tab of the property sheet is: "Allow Design Changes"
by default, it is set to "All Views" (stupid, I know). You need to change it
to "Design View Only".
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Hermawih]

Hi Arvin
Yes, that is the one that I need.
Thank you.
--
Hermawih
http://www.bocsoft.net

Before you make the mde you need to fix each form property. The last
property on the "Other" tab of the property sheet is: "Allow Design Changes"
by default, it is set to "All Views" (stupid, I know). You need to change it
to "Design View Only".
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access