How to identify if form goes to designer mode?

[petko]

Hi,

I'd like to identify if the user switches a form to a design mode. The form where I want to do this is a password [FONT=&quot]inquiry [/FONT]and I'd like to [FONT=&quot]handle [/FONT]somehow this scenario from code. But I don't know how to catch it.

Any idea would be appreciated

Peter

 

[Isskint]

You can use the CurrentView property to determine a forms display state. The 'trick' is the event trigger to check the state. The On Deactivate is one option, as is a timed event. The problem is detecting the state whilst it is in design view. You could use code in another form (timed trigger).

Simplest solution though is creating an MDE or ACCDE - this disables design view

 

[jdraw]

I agree with Isskint --if there is a concern that a user may go into design mode and make changes, then use the MDE/ACCDE as Isskint advises.

If you make a MDE/ACCDE, then keep a copy of your mdb/accdb in a safe, protected place. You need the mdb/accdb version if you ever want to make changes to that mde/accde.

Good luck.

 

[petko]

Thanks jdraw, ACCDE format is nice, that solves my problem...
As I don't have any experience with it, I'd like to know if it is possible achive that the user could not see, or at least not delete objects from the object list (opened by F11)

Thanks

Peter

 

[jdraw]

Do a little reading/research(google/bing) on ACCDE.
Protect the ACCDB from which you create the ACCDE

With the ACCDE, the user should not be able to access/modify code, and should not be able to get to design mode.
That said, if you have queries/procedures that DELETE objects, those queries and procedures can be run/executed. But that is part of your logic.

Just want to make sure you
Protect the ACCDB from which you create the ACCDE