如何向最终用户出示MS Access Form? [英] How to present a MS Access Form to the end user?

问题描述

我在MS Access中创建了一个表单.不幸的是，我不能publish to access services或创建package solution

I created a form in MS Access. Unfortunately I cannot publish to access services or make a package solution

我正在寻找一种用户友好的方式来向用户展示此表格.到目前为止，用户将打开ms访问文件，单击form并将其填写.

I am looking for a user friendly way to present this form to the user. So far the user will open the ms access file , click on the form and fill it out.

我想只提供一种形式. 我不希望用户看到所有表和结构. .我有什么办法可以将表格与表格，查询等列表分开?

I would like to have a way to provide the form ONLY. I do not want the user to see all the tables and the structure . . Is there any way i can separate the form from the tables, queries etc. list ?

我拆分了数据库，并给用户提供了fe副本，但是仍然很糟糕！所有这些面板和东西. MS Access是否可以解决此问题?

I split the database, and gave a fe copy to the user, but it still sucks! All those panels and stuff. Does MS Access has anything to address this issue ?

推荐答案

拆分数据库的问题和创建已编译accDE的问题与隐藏Access接口无关.

The issue(s) of splitting the database, and the issues of creating a compiled accDE are NOT ONE BIT RELATED to hiding the Access interface.

100％独立的问题和问题.

100% separate question and issue.

现在，毫无疑问，对于任何访问应用程序都应执行上述操作，但是上述隐藏隐藏访问接口的操作非常简单.

Now, without question the above should be done for any access application, but THE ABOVE HAS ZERO TO DO WITH hiding the access interface.

一旦隐藏了访问UI，那么您就可以考虑进行编译以使用户避免进入访问UI部分是一个好主意.

Once you get the access UI hidden, then you can consider the idea of compile to accDE a good idea to PREVENT users from getting into the access UI parts.

相同的分裂.您确实需要拆分.但是，再次拆分与隐藏accsss接口无关.

Same goes for splitting. You really need to split. However, AGAIN the splitting has NOTHING to do with hiding the accsss interface.

现在，让我们继续隐藏访问界面.

So now, lets get on to hiding the access interface.

要隐藏所有访问界面并仅显示表单，您需要在启动代码中添加一行(表单加载事件很好).

To hide all of the access interface and ONLY show the form, you need to add ONE LINE to your start up code (the forms on-load event is fine).

因此，在选项中指定要显示的表单.

So, specify the form you want to display in the options.

将这一行VBA代码添加到表单加载事件中.

Add this ONE LINE of VBA code to the forms on-load event.

DoCmd.ShowToolbar "Ribbon", acToolbarNo

您需要的其他设置是:

[x]显示导航窗格<-取消选中此框.

[x] Display Navigation Pane <-- uncheck this box.

[x]使用Access特殊键<-取消选中此框

[x] Use Access Special Keys <-- uncheck this box

设置访问权限以使用选项卡式界面，然后取消选中该框以显示选项卡.

Set access to use tabbed interface, and un-check the box to display tabs.

不得弹出表格.它可以是模型，但不能弹出.

The form MUST NOT be popup. It can be model, but NOT popup.

结果是您将仅看到表格.显示结果:

The result is you will ONLY see the form. This shows the result:

现在要记住要返回开发人员"模式，您必须退出，然后在启动过程中按住Shift键.当所有这些工作都完成后，您希望编译为accDE，并搜索一些有关如何在启动期间禁用Shift键以防止用户看到访问UI的答案.

Now keep in mind to get back to "developer" mode, you have to exit, and then hold down the shift key during startup. When you get all of this working, then you want to compile to an accDE, and search out some answers on how to disable the shift key during startup to prevent your users from seeing the access UI.

因此，您只需要一行代码即可实现此目标.剩下的只是在应用程序中选择正确的设置，以及启动时的那一行代码.

So you ONLY need one line of code to achieve this goal. The rest is just choosing the correct settings in your application, and that one line of code on startup.

这篇关于如何向最终用户出示MS Access Form?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！