Resetting Right-Click functionality - Microsoft Access / VBA

RLN

RE: Access 2003

I wanted to turn off right clicking on forms so users couldn't go into
design mode and change stuff.
I have a special "programmer s' form that, when a password is put in,
enables F11 so I can go modify objects in the container.

Now I cannot even right click in the container.

I tried looping through the forms and resetting the shortcut menu
property to "Yes". This did not work and I still cannot right-click on
my forms or the DB container.

Does anyone have an example of code that would reset this property
across all forms and the container as well?

Here is the code I have so far that does not work correctly:

Dim frm As Form
For Each frm In Forms
Debug.Print frm.Name
frm.ShortcutMen u = True 'allow right clicking on all forms
Next frm

thnx...
*** Sent via Developersdex http://www.developersdex.com ***

Jun 27 '08 #1

Subscribe Reply

1491

Tom van Stiphout

On Fri, 06 Jun 2008 12:33:28 -0500, RLN <no*******@devd ex.comwrote:

Couldn't you simply ship an MDE to your users?
-Tom.

>
RE: Access 2003

I wanted to turn off right clicking on forms so users couldn't go into
design mode and change stuff.
I have a special "programmer s' form that, when a password is put in,
enables F11 so I can go modify objects in the container.

Now I cannot even right click in the container.

I tried looping through the forms and resetting the shortcut menu
property to "Yes". This did not work and I still cannot right-click on
my forms or the DB container.

Does anyone have an example of code that would reset this property
across all forms and the container as well?

Here is the code I have so far that does not work correctly:

Dim frm As Form
For Each frm In Forms
Debug.Print frm.Name
frm.ShortcutMen u = True 'allow right clicking on all forms
Next frm

thnx...
*** Sent via Developersdex http://www.developersdex.com ***

Jun 27 '08 #2

RLN

Yes, I could do an MDE. I was just trying to see if there was a way to
hide the "dangerous menus" form the users, then restore them once the
app had closed.

*** Sent via Developersdex http://www.developersdex.com ***

Jun 27 '08 #3

Similar topics

2268

resetting browser?

by: The Plankmeister | last post by:

Hi... I'm getting to grips with custom error handling, and am wondering if it is possible to somehow reset all the content already sent to the browser, and send some new stuff in its place. For example, if I'm looping through a database, and I've already written 10 records to the browser, and then an error occurs, is it possible to send a command to the browser that makes it drop everything it's received thus far, and then just have...

PHP

18778

HTTP/1.1 New Session Failed & sessions resetting

by: riprod | last post by:

Someone in the IIS newsgroup suggest I post this here, so sorry in advance for the cross posting. I have a Win 2003 SP1 with IIS 6 and host about 40 websites, most of them useing ASP/VB with access databases. The server is a Dell Dual 2.4Ghz XEON with 512Mb Ram. Every few days I get the error 'HTTP/1.1 New Session Failed' and the server stops showing the sites. It comes right after a bit and then the error comes back. I

ASP / Active Server Pages

1716

Time & Billing Database, Resetting index???????

by: Frantic3d | last post by:

I just started using Access' Template file "Time & Billing Database" Well among other items I need to change the biggest right now is resetting the Client, Employee, Project ID #'s to start at 1. Is there a simple fix for this? TIA Neil

Microsoft Access / VBA

1817

Resetting the Form

by: DeveloperPDX | last post by:

I am creating a page and I need to add a reset button (like you would with HTML forms). Is there any way to do this other than resetting individual controls? Basically I need to page to return to the state after the OnLoad event

C# / C Sharp

1764

Session resetting

by: No One | last post by:

This seems to be related to the ViewState error that is now starting to plague ASP.Net apps. When the Application Pool is recycled, the Session seems to be getting reset. When this is done, session information is lost and my app forgets what rules a user has. I'd rather not recode to read this from the database for every page, but I wonder if I have no other choice. Anyone else notice the Session resetting?

ASP.NET

1224

"Resetting" a form

by: Randall Arnold | last post by:

I have a CSV processing program that instantiates Excel and performs various operations. I want the ability to reset the main form for running another data set with defaults selected. Right now I am one-by-one restoring every control to its initial state, but it occurred to me that if I could unload and reload the main form (from another module) that I could quickly and cleanly accomplish the same thing... right? But how would I do this...

Visual Basic .NET

949

Infragistic resetting licensing

by: Newbie5555 | last post by:

I'm having problem with my current webmaster. Iooking at changing. Current webmaster says he and only he can do the resetting licensing on the controls we use. Is that true? I can't get a stranght answer out of anyone. I know he uses Infragistic2 7ver. controls. Licensing is only done on the creation side not the user side on webdesign. right? Please help. Thanks

General

1216

resetting one particular field in all rows

by: hsriat | last post by:

I have a grid table in the front end (PHP on server side), and the master admin can sort data in that grid according to his own wish and save that new sorted order. Once the master admin sorts the data, all the users view data in that order only. And only the master admin has the right to sort and change order. What I'm doing is, I have an index field (not primary), according to which the data is displayed in ascending order. When the master...

MySQL Database

1695

Resetting GET query values

by: Vince Morgan | last post by:

Hi all, I have a POST form that also includes some anchors/links. If a user clicks a link, that link remains set so that pressing the submit button later not only sends the appropriate POST value, but also passes the previous link value. What I would dearly love to do is remove the query string after dealing with the passed value so that it isn't pased again when the submit button is susequently pressed. Would form.reset() be the right...

Javascript

1536

resetting to ALL

by: geraldjr30 | last post by:

hi, i managed to reset the $_GET to $_POST passed from previous page, but for some reason when i type in a in the form it resets back to all. i do not want this to happen... can someone look at my code and tell me how to prevent this? <html> <STYLE type="text/css"> TD{font-family:ARIAL;font-size:11px;color:#666666;}

PHP

9705

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10320

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10308

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7609

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6846

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5513

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4288

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3806

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2981

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General