justina
asked on
How to remove "Design view"-option from Form's Pop-up menu?
Hi there,
If user is viewing a form and right cliks on it, Access will open an 'pop-up menu' (I don't know what is it called in English version) with options:
-Design View
-Datasheet View
-Filter by Form
-Filter or Sort
-Show All Records
-Cut
-Copy
-Paste
Now I want to get rid of that "Design View" option. From form's design view I can set Allow Filtering to 'no' and that greys out filtering options. I just can't figure out how to get rid of that "design view". I have tried deleting all CommandBars and everything and all I got was all other ComBars were deleted, except that one. By deleting that option I wan't to prevent user access to form design view and from there into the query builder. I'm running Access 97.
Any ideas anyone?
If user is viewing a form and right cliks on it, Access will open an 'pop-up menu' (I don't know what is it called in English version) with options:
-Design View
-Datasheet View
-Filter by Form
-Filter or Sort
-Show All Records
-Cut
-Copy
-Paste
Now I want to get rid of that "Design View" option. From form's design view I can set Allow Filtering to 'no' and that greys out filtering options. I just can't figure out how to get rid of that "design view". I have tried deleting all CommandBars and everything and all I got was all other ComBars were deleted, except that one. By deleting that option I wan't to prevent user access to form design view and from there into the query builder. I'm running Access 97.
Any ideas anyone?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How about converting it to an MDE? Be sure to make a back up first!
ASKER
You were faster and also brought up few other options, so you will be rewarded. =)
Thanx!
Thanx!
Thanks :-)
Man! I'll never catch up in points!
'The slow code never catches the worm'
'The slow code never catches the worm'
ASKER
From form properties, select "Quick menu" (or something similar in english) and set it to "No".
And I have worked 2 hours to find that out...