访问桌面组合框bug？ [英] Access desktop combobox bug?

问题描述

在本地驱动器上使用Office 365中的最新版本的桌面访问。 

Using the latest version of desktop Access in Office 365, on a local drive. 

我有一个绑定表单（属性为"Single form"），其中我在标题中放置了一个组合框，允许我转到选定的记录。我使用日期/时间字段作为唯一字段进行选择。 表格中的早期记录
它正在引用， 没有记录时间。 

I have a bound form (with the property of "Single form"), in which I placed a combo box in the header, to allow me to go to a selected record. I used the date/time field as the unique field to select from.  The earlier records in the table it is referencing,  did not record the time. 

去年夏天，我向数据库添加了一些新功能，并创建了此表新表。 其中一项增强功能包括为日期字段添加时间。 时间设置为24小时格式。 

Last Summer, I added some new features to the database and created this table new table.  One of the enhancements, included adding time to the date field.  The time is set to display in 24Hr format. 

原始数据库包括个人表和活动表，将许多活动与每个人联系起来。 创建此新表是为了将许多活动与事件相关联。 新表现在包含数百个事件
记录。 事件记录的日期/时间范围记录在两个日期字段中。 

The original database included an Individual table and an Activities table, associating many activities to each individual.  This new table was created to also associate the many activities to an event.  The new table now contains hundreds of event records.  The event record has a date/time range recorded in two date fields. 

我现在拥有与个人和事件相关的数千条活动记录。 现在大多数事件记录的时间都是0:00。 最近的记录包含实际时间。

I now have the thousands of activity records associated with both individuals and events.  The majority of the event records now have 0:00 as the time.  The more recent records contain actual times.

当我在组合框中选择时间为0:00的记录时，Access会按预期跳转到该记录。 但是，当我尝试选择包含0:00以外时间的事件记录时，Access会短暂地转到该记录，并立即将
返回到当前记录，当我执行请求时。 它拒绝使用日期字段中的实际时间转到任何记录。

When I select a record in the combo box that has 0:00 as the time, Access jumps to that record, as expected.  However, when I attempt to select an event record which contains a time other than 0:00, Access goes to that record briefly and instantly returns to the current record it was on, when I executed the request.  It refuses to go to any record with an actual time in the date field.

我使用组合框向导创建控件，使用第3个选项"转到所选记录"。在表中。 开始日期字段是主要排序字段，设置为降序。 当使用日期/时间作为参考字段时，Access似乎有一个与此功能相关的错误
。

I used the combo box wizard to create the control, using the 3rd option to "go to selected records" in the table.  The beginning date field is the primary sort field, set to Descending Order.  It would appear that Access has a bug related to this feature, when using date/time as the reference field.

推荐答案

你知道吗？您使用的是嵌入式宏还是VBA？

Do you know if you're using an Embedded Macro or VBA?

这篇关于访问桌面组合框bug？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！