Hello,
In Access 2010/2007, how do you prevent users from flipping into design view from the ribbon? I do not want to hide the entire ribbon (DoCmd.ShowToolb ar "Ribbon", acToolbarNo) or even the "View" part of the "Home" tab because users like being able to flip between Form View and Datasheet View in the forms. It turns out that on our network, if a user inadvertantly clicks Design View, then the database becomes locked to new users until the person who clicked design view closes and reopens the database.
On another website, someone recommended a CustomUI editor, though I don't know where that is for Access 2010, and if it involves an Office 2010 library reference, I'm not sure if it'll work since another office we work with is still using Access 2003 (example: I had to reference Microsoft Excel 11.0 Objects and not the new 14.0 ones when adding excel functionality to our database, they couldn't open it when it referenced 14.0 objects).
I am not sure if I can disable design view with DoCmd.ShowToolb ar, and I know for sure Access 2010 doesn't disable ribbon stuff with CommandBars(i) (I did a for loop through every CommandBar and set enabled to false and the ribbon was unaffected).
Please let me know if you know how to disable design view from the ribbon.
Thanks in advance!
4  31374 
You can go to 'Customize Quick Access toolbar' and then go to 'More Commands' -'Current Database' - then under Ribbon and Toolbar options you can deselect "Allow full menu" and/or "Allow Default Shortcut Menus"
Hope this helps...
Make ACCDE format database can simply remains necessary functions but disable the design view button.
In Access 2010, click File --> Save & Publish, from the screen it shows, the "Save Database As" should be highlighted, then look for "Make ACCDE" on the right.
Make sure you keep the ACCDB database to yourself for modify / update / upgrade purposes, and split the database into Front end and back end, this ensure data stored will not disappear when you replace a newer ACCDE file.
Narender,
Thanks for your reply. I disabled the option "Allow full menus", and though it did get rid of the design view shortcut, it also got rid of the form view and datasheet view toggling which I would like to keep. I did see there were some dropdowns for [Ribbon Name], [Menu Bar], and [Shortcut Menu Bar] in that same options section, are there things I could type into these boxes to just remove the design view from the view toggler?
colintis,
My database is already split into a FE and BE, all tables reside in the BE database. As for making the database an ACCDE, I've seen numerous threads and articles saying not to do it because it is much slower than the MDB format. Not only that but we still have Access 2003 users so the older format is necessary.
Unless there are any other ideas the database will have to remain as is. Thanks for the help though.
just wondering,...Ca n you please explain reason why you want user to flip between form view and datasheet view.. may be someone can guide you alternate for that.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: NB |
last post by:
Hi
Is there any way to call up the query design view from code?
In my compiled-as-MDE app everything is hidden from end users.
However, I want advanced user to have access to the query design view
so they can create, run and export their own query.
Another question is: can they be prevented from saving those
on-the-fly queries?
|
by: Ray |
last post by:
Stop me if you've heard this, but I am running Access 2002 and all of
a sudden, if I design a particular form (it's been working fine for
ages), Access crashes rather than open it in design view.
Interestingly, it doesn't crash if I run the app and open it in form
view! Just if I attempt to design it.
If I compact/repair, it allows me to design the form once. On any
subsequent attempts to view in design mode, though, it crashes before...
|
by: keni |
last post by:
One method of disabling Design View is to create an MDE database.
Without going into details, this won't work in my situation. What I
need is just a snippet of VBA code that will disable the design view of
my Employees form so the data entry people cannot enter design view and
modify it. I know very little about VBA, but surely there must be some
simple code like:
Sub
Designview.form = 0
End sub
|
by: Lars Netzel |
last post by:
Hello,
Making your own WebCustomControl, how you do disable properties in the
design view?
For example my WebCustomControl does not use text, so the default property
Font is missleading when it's editable. I want to disable that Property in
Design view.
Any hints?
|
by: denuk2003 |
last post by:
Hi Everybody
I have a 2003 application that I am trying to run under 2007, The code
seems to work OK but the Ribbon is a big problem. It just takes up too
much space away from the application.
Does anyone know a quick and easy way to code a 'minimize' of the
Access 2007 Ribbon when the application starts so that the user cannot
restore the Ribbon or use any part of it?
| | |
by: marcnz |
last post by:
Hi,
I am working for a company which as a MS SQL backend and Access as front end. We update automatically each access db on the user local machine when a new feature has become available.
We have to stay with MDB for several reasons, so please avoid telling me "you have to convert to MDE"... It is not an option.
We need to allow our users to have the right-click so they can export the reports to pdf or other format.
We need to remove...
|
by: existential.philosophy |
last post by:
This is a new problem for me: I have some queries that open very
slowly in design view.
My benchmark query takes about 20 minutes to open in design view. That
same query takes about 20 minutes to open in datasheet view. As an
experiment, I deleted all rows in all tables; after that, the query
took only seconds to open in both design view and datasheet view. From
these facts, I conclude that Access is evaluating the query when I go
to...
|
by: dileshw |
last post by:
Hi,
I am making a database amd i dont want users seeing the stuff thats happening in the background. So i would like to hide everything so that ONLY I can see it. Doing some reading online (and asking friends) I learnt of a few things i can do:
1- right now i have hidden the design view using tools->startup (and unchecking all boxes). But if someone knows a bit of access they can get into the design view by using SHIFT+open. I read online...
|
by: Hansens |
last post by:
Hi,
I'm fairly new to using access and my VB skills are very limited. I built a form that had unbound text boxes that act as parameters in the queries that provide the form with field values. The "parameters" are in the header. I used "where" statements to do this. Everything was working fine until this morning. I now have access asking for a parameter value in place of the value provided by the where statements. This happens when I attempt...
|
by: eneyardi |
last post by:
How to disable design view or right click and then how to bring it back? coz i want users not to change or modified the program.
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |
