本文介绍了VBA,访问自动填写表格的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嘿,我正在尝试为正在使用的数据库编写一些VBA.
问题出在这里:
我有一个组合框,选择该组合框将自动填充其后的其余记录.
只需向正确的方向轻推即可!
详细信息:
组合框:CustomerID
需要自动填充的记录:
姓氏
姓
地址
邮政编码
电话
传真
电子邮件
谢谢.
-Sonos
Hey, i''m trying to code some VBA for a database i''m working on.
Here''s the problem:
I''ve got a combo box, which when selected will auto fill in the rest of the records following it.
Just need a nudge in the right direction!
Details:
Combo box: CustomerID
Records which need to auto fill:
Forename
Surname
Address
Postcode
Telephone
Fax
Email
Thanks.
-Sonos
推荐答案
- http://www.trigonblue.com/AccessLookup.htm [ ^ ]
- [ ^ ]
- http://www .ehow.com/how_12375_look-values-one.html [ ^ ]
- http://www.fabalou.com/Access /General/lookup_tables_lut.asp [ ^ ]
- http://www.trigonblue.com/AccessLookup.htm[^]
- http://www.articlesbase.com/databases-articles/using-a-lookup-table-in-microsoft-access-979261.html[^]
- http://www.ehow.com/how_12375_look-values-one.html[^]
- http://www.fabalou.com/Access/General/lookup_tables_lut.asp[^]
我希望这能朝着正确的方向前进.
-MRB
I hope this nudges you in the right direction.
-MRB
这篇关于VBA,访问自动填写表格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!