我是这个论坛的新手，我正在寻找VBA代码或Macro， [英] I am new to this forum and I am looking for a VBA code or Macro,

问题描述

我需要在Access中插入一个文本框/ Combobox，用户输入一些ID，然后从具有所有状态的组合框中选择一个状态，那么应该有一个使用文本框中数据的代码，在combox中输入状态，然后获取一列中
项的计数。

I need to insert a text box/Combobox in Access that users enters some ID and then selects a state from a combo box that has all states, then there should be a code that uses the data in the textbox, states in the combox and then gets the count for an item in a column.

它的方式应该是提取的值是动态的，这意味着如果最终用户选择不同的状态和不同的ID，她/他可以得到一个新值。

It should be in a way that the value extracted to be dynamic, it means if the end user selects a different state and different ID, she/he could get a new value.

我在excel中做了这样的项目，因为这次我有很多行无法在excel中处理（因为我想验证源数据中提取的值和excel过滤器不会显示超过10000个唯一值，所以我已经变成了访问权限。

I did this kind of project in excel, since this time I have a lot of rows that can't be process in excel (because I want to verify the value extracted in source data and excel filter doesn't show more than 10000 unique values, so I have turned into access.

我正在寻找解决方案或VBA代码，感谢任何帮助，请考虑我是Access的新手，从插入组合框到插入代码的地方我需要一步一步...

I am looking for a solution or VBA Code, any help is appreciated, Please condsider that I am new in to Access and I need step by step from the time we insert a combo box till where we plug in the code...

GGGGGNNNNN

GGGGGNNNNN

推荐答案

您好，

您的问题不太清楚。您可以下载访问模板并学习它，这里也有很多学习资源：

Not very clear about your problem. You can download the access template and learn it and there are also a lot of learning resources here:

http://msdn.microsoft.com/en-us/office/aa905400

http://msdn.microsoft.com/en-us/office/aa905400

http://allenbrowne.com/ser-03.html

http://allenbrowne.com/ser-03.html

您也可以使用Access表单向导。

You can also use Access form wizard.

祝福，

这篇关于我是这个论坛的新手，我正在寻找VBA代码或Macro，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！