在MS Access数据库上搜索表单 [英] Search forms on MS Access database
问题描述
大家好,
我有一个数据库,我已经创建了一个搜索表单。一切都很好唯一的问题是第一次打开表单时搜索不起作用,但之后就可以了。我一遍又一遍地看着代码,没有什么可以触发这个问题。你能想到我错过的东西。
谢谢
Wana
Hi all,
I have a database that I''ve created a search form. Everything works great the only problem is the first time when the form is opened the search doesn''t work, but after that it works. I''ve looked over and over at the code, there is nothing to trigger this problem. Can you guys think of something that I''m missing.
Thanks
Wana
推荐答案
你的意思是什么不起作用?它应该做什么,它没有做?
What do you mean it doesn''t work? What is it supposed to do that it''s not doing?
你的意思是什么它不起作用?它应该做什么,它没有做?
What do you mean it doesn''t work? What is it supposed to do that it''s not doing?
无论我在搜索屏幕上选择什么,都会显示整个数据。所以搜索不起作用。但如果我第二次使用相同的搜索条件,它的工作正常。例如,我第一次搜索所有342条记录时共有342条记录,但第二次使用相同的搜索条件显示正确的记录数量88.
感谢您的帮助
Wana
Hi,
No matter what I select on my search screen the whole data shows up. So the search doesn''t work. but if I use the same search criteria the second time it work right. For example I have 342 total records the first time with my search all 342 records shows up but second time with the same search criteria the correct amount of records 88 displays.
thanks for your help
Wana
您是否将代码放入表单的On Load事件中?
Did you put your code in the On Load event of the form?
这篇关于在MS Access数据库上搜索表单的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!