Hi,
I would like to disable user from going to design view. I have a macro call showRibbon but I don't want to run it because it will hide all ribbon, then in my continuous form, user can't select the record and select deletes record from home button.
Can anybody point me out on how to hide all these ribbon and allow user to delete record in continuous form?
Best regards,
Sophanna
You could add buttons to your form that would perform the necessary task of deleting the record or anything else you need.
Note that just because you hide the ribbon bar, doesn't mean that the user can't still get into design view. For example, in Access 2010, the keyboard shortcut of Ctl+Enter will open the selected form, report, table, macro, or module in design view. Your best bet would be to distribute your front end as an .accde or .mde depending on what version of Access you are running. This disables all design changes for the users. You would then have a master file that would allow you to make changes to the design and then republish when updates are needed.
9 6579
You could add buttons to your form that would perform the necessary task of deleting the record or anything else you need.
Note that just because you hide the ribbon bar, doesn't mean that the user can't still get into design view. For example, in Access 2010, the keyboard shortcut of Ctl+Enter will open the selected form, report, table, macro, or module in design view. Your best bet would be to distribute your front end as an .accde or .mde depending on what version of Access you are running. This disables all design changes for the users. You would then have a master file that would allow you to make changes to the design and then republish when updates are needed.
Hi Seth Schrock ,
Thanks for your reply. Your idea solved my problem. May I ask is it true that accde format is slower than accdc? Is it possible for user to convert it to accdc file?
I don't have any experience working in a .accde file to know if it is slower, but I do know that it is used regularly by people as the version that is published to the end user.
As far as being able to convert it back to a .accdb file, there may be conversion tools available, but I don't know of any. I just tested it to see if just renaming it to have the .accdb file extension would change it (this does work to convert from .accdr to .accdb) and it still keeps its "locked" status. Code can't be viewed, design view is disabled, etc. even though I renamed it to .accdb.
You can't convert from accde to accdb. You need to keep a copy of the original accdb so you can make changes to that and create a new version of the accde to distribute each time.
@Seth Schrock and @Rabbit thanks for your reply.
Hi,
I face a problem that after save my access as accde file format, then when I ctrl+enter on form, I can't access to it. But in navigation pane, I can choose option to show table and when I click ctrl+enter on it, I can go to table and change its definition.
Can anybody tell me how to disable user to change table definition?
Sophanna
zmbd 5,501
Expert Mod 4TB
sophannaly
Unfourtunately, the best you can do is to hide the toolbar/navigation/etc... try to trap the F11 and disable special keys.
There is no other way that I know of to keep the users out of the tables even in an accde file.
It might work to split your table into a backend file and then password protect the backend so that users can't access the file directly. Then import the table into your .accde file. You can't edit anything other than the data in linked table (you can view it though) so this might work.
@zmbd Thanks for your confirmation that in .accde file user still can change table definition.
@Seth Thanks for your idea. I will give a try.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: David Deacon |
last post by:
Hi i was given the following advise,below my OriginalQuestion
I am a little new to ADOX can you direct me to the following
Do i place the code behind a button on a form?
Or do i place it in the...
|
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...
|
by: oneeye |
last post by:
Hello All,
I have designed and built a web control that loads a user control at run
time. The question I have is, can I Load the user control in design view?
Any Ideas or code snippets would be...
|
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...
|
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...
|
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...
|
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...
|
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: jbrumbau |
last post by:
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.ShowToolbar "Ribbon", acToolbarNo) or even the...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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,...
|
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...
|
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...
|
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...
| |