Forms

[sree]

Is there any way to restrict the form through password not to enter into design view and make changes ?

 

[boblarson]

An easier way is to just create an MDE (or ACCDE if on 2007) as nobody can go into design view on forms, reports, macros, or modules there.

 

[sree]

I tried to create accde in 2007, but shows the message like "unable to create .accede, .mde, or .ade file".
So what to do ?

help me

Thanks

 

[boblarson]

I tried to create accde in 2007, but shows the message like "unable to create .accede, .mde, or .ade file".
So what to do ?

help me

Thanks

Sounds like you need to do a "Compile" first do remove any errors. Go to the VBA window and then up to DEBUG > COMPILE and select that. Fix any errors until when you do that it just does it and gives you no error messages.