Vlook up in visual basics [英] Vlook up in visual basics

问题描述

您好，

我想在视觉基础知识中使用vlook up with ms access in ms。我在ms访问中有三列数据。在VB studio中，我想生成我的答案，这取决于前两列的值。因此我放了两个组合框来选择值，并希望将它链接到三个文本框以获得我的答案。

有人可以请帮助

谢谢

Vik

Hello,
I want to use vlook up in visual basics with database in ms access. I have data in three columns in ms access. In VB studio, i want to generate my answer which depends on values of first two columns. Therefore I put two combo box to choose values and want to link it to three text box to get my answer.
Can someone please help
Thanks
Vik

推荐答案

此处没有解决方案，错误的工具，错误的应用程序。



VLookup是一个Excel函数，用于在Excel工作表上的表中进行搜索。其次，搜索仅在第一列中完成。（糟糕的翻译）。



VB的Vlookup仅在数组上工作。



对于Access，我不太了解您的详细信息。我只是认为你必须使用带有条件的过滤器的SQL请求。

No Solution here, wrong tool, wrong application.

VLookup is an Excel function to search in a table which is on an Excel worksheet. Secondarily, the search is done in the first column only.(oops bad translation).

VB's Vlookup is working on an array only.

For Access, I don't know enough to give you details. I just think you have to use an SQL request with filter containing your conditions.

这篇关于Vlook up in visual basics的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！