记录选择器 [英] record selector

问题描述

我有一个日历在文本框中输入日期。我想要做的是让那个日期搜索具有相同日期的记录，如果它找到它去那个记录。如果它没有在任何记录中找到该日期，则开始该日期的新记录。请帮忙:)


谢谢

I have a calendar entering a date into a text box. what i want to do is have that date search for a record with the same date and if it finds it go to that record. if it does not find that date in any records then start a new record with that date. please help :)

thanks

推荐答案

如果您使用的是2007，那么当您使用时会弹出自动小日历在设置为日期的文本框中，选择日期时不会触发更新事件。所以，只需制作一个查找即可。或去按钮，用户可以在输入日期后点击。


然后在Button_Click（）中执行

If you are using 2007, the automatic little calendar that pops up when you are in a text box set as date doesn''t trigger an update event when a date is selected. So just make a "Find" or "Go" button the user can click after they enter a date.

Then in Button_Click() do

展开 | 选择 | Wrap | 行号

我正在使用Access 2003

saddly i am on Access 2003

这没关系，它的工作原理相同。您有一个模块，当您单击右键时，为您制作日历？这只意味着您可以在该按钮的代码末尾或使用新按钮触发此代码。我假设您的表单基于您想要移动的记录集，这意味着您可能在表单的页眉或页脚中有文本框。是吗？

That''s ok, it works the same way. You have a module that makes a calendar for you when you click the button right? That just means that you can trigger this code at the end of that button''s code, or with a new button. I''m assuming that your form is based on the recordset you want to move around in, which would mean you probably have the text box in the form''s header or footer. Is that right?

这篇关于记录选择器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！