Hi,
I was wondering if there was any way to disable certain menu items and
toolbar icons at runtime using VBA? Particularly the delete icon on the
tool bar and the delete option under edit. I want to force any record
deletes to be performed through the database rather then allow deletes from
the menu and toolbar options. If this is not possible is there a way to
restrict table views without using the security features? There are several
users of this database. Most of them use it with Access runtime, which
doesn't allow table views. However, there are some users that have full
versions of access and they have been able to delete records by viewing the
tables. I am using Access 2000.
Thanks in advance for any help offered.
Nathan Bloom
3  2866 
You can disable a large number of menu and toolbar items by removing the
"Allow Full Menus" checkbox under Tools - Startup.
There are also a number of ways of hiding the database window, starting with
that option on Tools - Startup.
But if your users have been instructed NOT to delete records in the tables,
and persist in doing so, it looks as if your problem is as much an HR
problem as it is a programming one.
HTH
- Turtle
"Nathan Bloom" <na*******@eart hlink.net> wrote in message
news:yC******** *********@newsr ead2.news.pas.e arthlink.net... Hi,
I was wondering if there was any way to disable certain menu items and
toolbar icons at runtime using VBA? Particularly the delete icon on the
tool bar and the delete option under edit. I want to force any record
deletes to be performed through the database rather then allow deletes
from the menu and toolbar options. If this is not possible is there a way to
restrict table views without using the security features? There are
several users of this database. Most of them use it with Access runtime, which
doesn't allow table views. However, there are some users that have full
versions of access and they have been able to delete records by viewing
the tables. I am using Access 2000.
Thanks in advance for any help offered.
Nathan Bloom
Try prefixing all of your table names with "Usys" and make sure that you
have disallowed "Show system objects" in Tools|Options. All that remains is
the fiddly little detail of changing all references to the tables everywhere
in your application. Actually not too bad if you have SpeedFerret or Find
and Replace.
HTH
--
-Larry-
--
"MacDermott " <ma********@nos pam.com> wrote in message
news:NO******** *********@newsr ead3.news.atl.e arthlink.net... You can disable a large number of menu and toolbar items by removing the
"Allow Full Menus" checkbox under Tools - Startup.
There are also a number of ways of hiding the database window, starting
with that option on Tools - Startup.
But if your users have been instructed NOT to delete records in the
tables, and persist in doing so, it looks as if your problem is as much an HR
problem as it is a programming one.
HTH
- Turtle
"Nathan Bloom" <na*******@eart hlink.net> wrote in message
news:yC******** *********@newsr ead2.news.pas.e arthlink.net... Hi,
I was wondering if there was any way to disable certain menu items and
toolbar icons at runtime using VBA? Particularly the delete icon on the
tool bar and the delete option under edit. I want to force any record
deletes to be performed through the database rather then allow deletes
from the menu and toolbar options. If this is not possible is there a way to
restrict table views without using the security features? There are
several users of this database. Most of them use it with Access runtime, which
doesn't allow table views. However, there are some users that have full
versions of access and they have been able to delete records by viewing
the tables. I am using Access 2000.
Thanks in advance for any help offered.
Nathan Bloom
Just setup your applctont to hide all of the ms-access interface.
Try downloading a sample (and simple) mdb of mine at: http://www.attcanada.net/~kallal.msn...s/DownLoad.htm
Grab the 3rd one in the above list.
Try running it...you will see how it hides all of the ms-access interface.
It takes no code, and takes no security to do this..but only a few settings
in the tools->startup. I would suggest you do this also.
The above example of course would be converted to a mde, and also the
shift-key by-pass would be set..but other then that..for both regular
users..and runtime users...this example as a mde would be very much locked
up.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com http://www.attcanada.net/~kallal.msn This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Abraham Khalil |
last post by:
With all the Menu items, toolbar items and popup items that can total to
about 50-75 choices in a gui design, what the 'easiest' way to map the
action names with the class to call.
Like to use the Command design pattern to do this generically:
Somehow get the "action string" and map it to a "command class".
Is this possible with Command, Reflection etc?
Somehow:
|
by: JesusFreak |
last post by:
From: us_traveller@yahoo.com (JesusFreak)
Newsgroups: microsoft.public.scripting.jscript
Subject: toolbar script problem
NNTP-Posting-Host: 192.92.126.136
Recently, I downloaded the following beautiful script
"http://javascript.internet.com/navigation/toolbar-menu.html". It
works like a charm. I made my webpage in frames, where the nav-frame
shows the menubar, so whenever I click a link in the menubar, it opens
in the frame below. But...
|
by: PC User |
last post by:
I'm creating a shortcut menu to popup over my richtext box. Its a form
with a listbox of menu items with associated richtext activex (rtf)
editing commands. I found a way to transfer a value from the popup
menu to the form, but now I have one more step to take. The value
being transferred is a public function from a module. I need to find a
way to execute the function to edit the text in the richtext field.
Download the test database from...
|
by: cefrancke |
last post by:
I cant seem to find a straight answer on the following.
I want to programmatically hide all menus except a basic custom report
menu (during report preview) and right click pop-up A-Z sorting on
datasheets (for subforms).
I would like to do this on startup of the application.
To be clear:
|
by: Dino Buljubasic |
last post by:
Hi,
I have a toolbar with several buttons on it, one of which is set up to
be as a DropDown button. I also have a context menu with menu items
assigend to it so when I click that button, my context menu shows up.
I have 2 questions:
1) how do I find out which menu item was clicked so I can use my
Select Case statement to perform appropriate actions depending on menu
| | |
by: Wayne |
last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom
menu bar designer. Is it in the beta? Maybe I'm blind. The question
that comes to mind is: Will custom menu bars be the same height as they
were in previous versions or will they be the "ribbon" style that takes
up a huge portion of the screen?
Also when I use Access 2007 to open an Access 2003 database that has
custom menu bars they display as they did in Access...
|
by: Neil |
last post by:
I have a form that has its own custom menu bar in Access 2000. I'd like to
make a copy of the menu bar and use it with another form. How can I do this?
Thanks.
|
by: =?Utf-8?B?bWFib25k?= |
last post by:
Hi
I want to loop through the menu items (including sub menus) of a toolbar.
I'm using this at present
Dim mnu As ToolStripMenuItem
For Each mnu In Me.MenuStrip1.Items
'do something to menu item
Next
But it only gives me the top level menu items and not the ones that branch
|
by: PW |
last post by:
Hi,
What is one and does Access 2003 have one? Or how would I create one?
I would like the user to be able to right-click on a form or a control
on a form and have a menu that offers to go to a reservation, client,
activity, etc.... maybe even print something.
Thanks,
-paulw
|
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...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
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();...
|
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...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
