Prevent user from modifying my form !

[nartla]

Hello,

I am working in an application VBA/Access which was developped by
another person, and I am supposed to modify it.

I created a new form for the app, but I recently noticed that if I do
a right-clic on the title bar of my form, a context menu appears
allowing the user the switch to "form create" mode, or to display the
form properties and allowing the user to modify them !!!

I want to prevent this menu from being available to the user, and not
let it being displayed in the case of a right clic on my form.

Can anybody tell me what is the way to solve this point ? I believe
there is some property I should set on the form to prevent this
context menu to appear, but I can't find which ...

Thank you for any help.

 

[Guest]

You should be distributing .mde to your users rather than .mdbs this
eliminates the possibility of them messing around with your code, form and
report design....

When you are ready to convert your mdb into an mde simply go
Tools - Database utilities-Make an mde file...

So you keep the mdb and whenever you make changes that you want them to have
access to, simply make a new mde and replace the one they were using with the
new one.

Nothing easier!

 

[nartla]

You should be distributing .mde to your users rather than .mdbs this
eliminates the possibility of them messing around with your code, form and
report design....

When you are ready to convert your mdb into an mde simply go
Tools - Database utilities-Make an mde file...

So you keep the mdb and whenever you make changes that you want them to have
access to, simply make a new mde and replace the one they were using withthe
new one.

Nothing easier!
--
Hope this helps,

Daniel P










- Afficher le texte des messages précédents -

Thank you.
I distribute indeed the MDE file (not the MDB), but in the MDB, I find
that the developper that created the application
succeeded in hiding this context menu, and I just wanted to know how I
could achieve the same.

 

[Guest]

Open the form in design view.
Goto the 'Other' Tab
Set the 'Shortcut Menu' option to No
save your changes
--
Hope this helps,

Daniel P

 

[nartla]

Open the form in design view.
Goto the 'Other' Tab
Set the 'Shortcut Menu' option to No
save your changes

This is exactly what I needed.
Thank you Daniel !

 

[nartla]

Open the form in design view.
Goto the 'Other' Tab
Set the 'Shortcut Menu' option to No
save your changes

Exactly what I wanted to do !
Thank you Daniel !