使用记录集从列表更新表 [英] update table from list using recordsets
问题描述
你好，
*访问2007
* VBA的小经验
我会尽力使这个我可以。
问题
我有一个数据库，其中包含客户及其计算机的信息。
我正在尝试将子表单链接到每台计算机
子表单在一个框中显示整个软件标题列表。
方框2显示我已经安装了哪些标题。
我想选择在方框2中列出的每台机器上安装的标题。
例如
Matts Computer安装了AVG，安装了Office 2007和Foxit。
当我回到Matts计算机记录时，我想看看哪些标题已经安装并且可以随时轻松更新。
方框1显示所有软件标题并过滤掉
（已安装AVG，安装了Office 2007和Foxit。）
框2显示已经安装了哪些标题[3]
（已安装AVG，已安装Office 2007和Foxit。）
从框1我可以选择，多选标题和更新BOX 2.
请帮助
谢谢
Gcoaster
Hello,
* Access 2007
* Little Experience with VBA
I will try and make this as clear as I can.
ISSUE
I have a database that has information for Clients and their Computers.
I am trying to make a subform linked to each Computer
The Subform shows me the entire list of software titles in one box.
Box 2 shows me which titles have been installed.
I would like to pick which title(s) that are installed on each machine listed in box 2.
For instance
Matts Computer has AVG installed, Office 2007 installed and Foxit.
when I go back to Matts Computer Record, I would like to see which titles have been installed and easily update on the fly.
Box 1 showing all software titles and filtering out
( AVG installed, Office 2007 installed and Foxit. )
Box 2 showing which titles are already installed [3]
( AVG installed, Office 2007 installed and Foxit. )
From Box 1 I can select, multiselect titles and update BOX 2.
Please help
thank you
Gcoaster
推荐答案
您需要创建一个VBA函数来遍历记录集。以下教程为您提供了基础知识，即使它与您的情况不同。 使用两个记录集的基本DAO记录集循环
You need to create a VBA function to loop through a recordset. The following tutorial gives you the basics even though it''s not like your situation. Basic DAO recordset loop using two recordsets
I我想我明白了
I think I understand.
Hello Rabbit，
看过你的一些帖子，你是高手！很酷..
这是我走了多远。从左到右不起作用。请帮助
谢谢
Hello Rabbit,
Have read some of your posts, you are a master! cool..
this is how far i have gotten. left to right is not working. please help
thank you
这篇关于使用记录集从列表更新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
