创建一个动态列表框，根据用户输入进行更新 [英] Create a dynamic listbox which gets updated on the basis of user input

问题描述

我正在开发一个基于访问的小型应用程序。我已将前端文件与后端数据库分开，两者都在访问中。


现在问题是我不想创建一个动态列表，它根据文本框中的用户输入进行更新。我尝试过使用链接表和DAO记录集，但是效果太慢了。如果后端和前端在同一个访问文件中，那么这个问题就不会出现了。


任何人都可以指导我。

非常感谢您的努力.....


Rits

Hi,

I am developing a small access based application. I have separated the Front end file from backend database, both of them in access.

Now the problem is i do not get the idea to create a dynamic list which gets updated on the basis of user input in a text box. I have tried using a linked table and DAO recordset, however that works too slow. Incase if the back-end and fron-end are in the same access file then this problem doesn''t arise.

Could anyone please guide me.

Thanks very much for your efforts.....

Rits

推荐答案

其他所有内容您的应用程序是否像在执行文件拆分之前一样工作？我问，因为你似乎确定列表框问题与拆分数据库有关，这可能是也可能不是。


你能发布你用于代码的代码吗？列表框更新？谢谢。


Pat

Does everything else in your application work as it did prior to doing the file split? I ask because you seem certain that the list box problem is tied to splitting the database, which may or may not be the case.

Can you post the code that you are using for the list box update? Thanks.

Pat

查看前端/后端（FE / BE），但是你说你已经尝试过链表，它们太慢了。由于它们与同一介质中的单个Access数据库非常相似，我发现这很难理解。


如果您将后端数据库移动到不太局部的地方作为一部分你的分裂然后显然这是一个存储你的数据库的问题，而不是它是否分裂。


这很难知道因为有关于你在问题中的问题没有太多细节。

Check out Front-End / Back-End (FE/BE), but you say you''ve tried linked tables and they''re too slow. As they would be pretty similar to a single Access database in the same medium I find this hard to understand.

If you''re moving your Back End database to somewhere less local as part of your split then clearly this is an issue of where to store your database rather than whether or not it''s split.

It''s hard to know as there''s not really much detail about your problem in the question.

你好NeoPa，


我得到了你想要的建议。如果问题仍然存在，我会尝试你建议的所有方法，如果问题仍然存在，我会回来。


非常感谢您提前做出这样的反应。


问候，

Rits

Hi NeoPa,

I got what you are trying to suggest. I will try all the ways you have suggested and will come back in case if the issues persists.

Thanks very much for such an early response.

Regards,
Rits

这篇关于创建一个动态列表框，根据用户输入进行更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！