如何在MS Access Form中的表中显示记录数据 [英] How to display record data in a table in MS Access Form

问题描述

我正在使用Office上的表格进行工作.我注意到没有很多可用的控件，但是我需要在诸如结构(而不​​是列表框或组合框)的表中显示数据.请问我该如何完成?

I am working in Offiice Access on a form. I notice that there are not a lot of controls available to use but I have a requirement to display data in a table like structure(not listbox or combobox). How can I accomplish this please?

推荐答案

实际上，Access中真正重要的功能之一就是我们所说的延续表格.连续表单只是一种可以在其中放置所需控件的表单，魔术部分是这些控件将为每一行细节一遍又一遍地重复-结果是一个网格，我敢说一个最强大的网格控件中的一个可用-它可以通过VBA完全编程.

Actually, one of the truly great features in Access is what we call a continues form. A continues form is simply a form in which you can place any kind of control you want, the magic trick part is those controls will repeat over and over for you for each row of detail - the result is a grid, and I dare say one of the most powerfull grid controls avaialble - it is fully programable with VBA.

这样的设置不仅为您提供了我们IT行业有史以来最好的网格控件之一，而且对于您而言，创建这种奇迹也几乎没有什么工作.

Not only does such a setup give you one of the best grid controls that our IT industry has ever seen, but it is very little work on your part to create this marvels.

因此，您可以放置​​图片，按钮，复选框甚至组合框.它们都将重复为您提供网格.

So you can drop pictures, even buttons, check boxes and even combo boxes. They will all repeat as a grid for you.

这是在Access中创建的简单屏幕:

So here is an easy screen to create in Access:

还有其他一些想法.请注意，其中一些是Access Web表单，但所有外观都可用于客户端表单或Web表单.

And here are a few more ideas. Note that some of these are Access web forms, but all of the look + feel is available for client forms or web forms.

因此请记住，可以在浏览器中运行的新的完整Web效果表单，甚至仅客户端表单也可以使用这些新的效果，例如阴影，悬停效果等.

So keep in mind that the new full web effects forms that can run in a browser, or even client only forms can use these new effects such as shadow, hover effect etc.

和这个:

和

由于我放入了富文本控件并将其绑定到函数，因此上述内容非常酷.结果是一列，以红色显示两行之间的差异.那有多酷?

The above is VERY cool since I dropped in a rich text control and bound it to a function. the result is a column that displays the diffenrce between the two rows in Red. How cool is that?

以上所有示例都是我们在Access中所称的Continue表单，并且构建起来非常简单，并且所有上述示例都是100％仅使用Access表单构建的，包括带有阴影的按钮的图形.

All of the examples above are what we call a continues form in Access and were built with very little effort and all of the above examples are 100% built only using Access forms, including the graphics for the buttons with shadows.

这篇关于如何在MS Access Form中的表中显示记录数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！