• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

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?
0
justina
Asked:
justina
  • 2
  • 2
  • 2
1 Solution
 
shanesuebsahakarnCommented:
You can create a custom shortcut menu without the option and set the form's Shortcut Menu property to the one you've just created. Alternatively, click Tools->Startup and untick Allow Default Shortcut Menus (but this will remove all right-click shortcuts).
0
 
justinaAuthor Commented:
Never mind, I found the answer by myself...

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...

0
 
1WilliamCommented:
How about converting it to an MDE?  Be sure to make a back up first!
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
justinaAuthor Commented:
You were faster and also brought up few other options, so you will be rewarded. =)

Thanx!
0
 
shanesuebsahakarnCommented:
Thanks :-)
0
 
1WilliamCommented:
Man!  I'll never catch up in points!

'The slow code never catches the worm'
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now