Access 2003 中包含可选项目的表格
我需要创建一个表单，用户可以在其中从表中选择一项。然后用户可以单击按钮，以便下一步使用所选行中的数据。我无法找到最佳解决方案。 首先，我不知道如何制作带有可选项目的此类视图/表格。其次，我不知道如何从选定的行收集数据。我对 MS Access 2003 和 VBA 完全陌生，也许有人已经解决了此类问题或知道如何执行此操作...非常感谢您的帮助
I need to create a form in which user can select one item from the table. Then user can click on button so data in selected row can be used in next step. I am unable to find optimal solution.
First, I don't know how to make such view/table with selectable items. Second, I don't know how to gather data from selected row. I am totally new in MS Access 2003 and VBA, maybe someone has already solved such issue or know how to do this... Thanks a lot for any help
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
最好从示例数据库和教程开始。 Northwind 示例数据库随 Access 2003 一起提供：http://support.microsoft.com/kb/824265，它的信息量很大，即使代码有时有点奇怪。距离你现在所处的位置来说，这是一个相当长的助跑。
It is probably best to start with a sample database and a tutorial. The Northwind Sample database ships with Access 2003 : http://support.microsoft.com/kb/824265, it is quite informative, even if the code is a little odd at times. It is quite a long run-up from where you are at the moment.
如果您是点击周围并解决问题的类型，我建议您首先转到“表单”选项卡，单击“新建”按钮，选择“表单向导”并选择一个表格。
选择要添加到新表单的所有列并完成向导。然后，右键单击它，单击“表单设计”，然后从那里进行编辑。
否则，也许你需要一本好书，因为你前面有一些曲线！
祝你好运！
If you are the click around and work it out type, I would suggest first that you go to the forms tab, click the new button, choose form wizard and select a table.
Select all columns to add to your new form and finish the wizard. Then, right click it, click Form Design, and edit from there.
Otherwise maybe you need a good book because you have a bit of a curve ahead!
Good luck!
好吧，过了一段时间我问我的同事他们是如何解决这个问题的。其实这只是一个小伎俩。您需要做的就是将数据加载到文本框中。因此，每次用户单击某行时，都会加载数据。然后，当他单击按钮继续下一步时，你就明白了！在文本框中很好。 :) 可以方便...
OK, after some time I asked my colleague how they solved this. In fact it's just a little trick. All you need to do is load data into textbox(es). So each time user clicks on some row, data are loaded. And then, when he clicks on button to proceed on next step, you got it! Nice in textbox(es). :) Can be handy...