书签和刷新表单 [英] Bookmark and refresh form

问题描述

大家好


我提出了两个问题。

首先是书签/或突出显示表单中的特定记录。表单是连续的，记录来自查询结果。该表单中的记录之一将始终是表中最后添加的记录。表单以查询的排序顺序显示记录。我需要的是突出显示或标记该记录的特定字段（添加的最后一条记录），无论表单中记录的位置如何，都能让用户注意此记录。

秒当打开包含我想自动执行计算的记录并使用新结果更新其中一个字段并保存更新的记录时，问题采用相同的形式。

我已经提到表单显示查询结果。

有两个日期字段/控件和三个时间字段/控件。

计算需要根据日期和两个时间字段和时间需要根据计算perofrmed更新。

计算可以在加载表单后完成，并可以放置命令按钮来执行此操作。

请指导我如何实现这个目标。


谢谢大家

解决方案

要突出显示在特定记录中，您可以向表/查询添加字段，并将该记录标记为true，其余为false。然后，根据该字段进行条件格式化。

对于第二个问题，是否有任何理由不能运行更新查询？

Hi ChipR

很抱歉迟到的回复。我认为我对这个问题的解释并不清楚。我想解释一下，因为有了你的答案，我无法达到结果。我正在做的是通过表单向表中添加记录，然后单击该表单中的按钮，打开另一个表单，该表单是查询的结果，该表单包含很少的其他记录和最后添加的记录。但是记录已经按查询中的时间字段排序。所以我想把重点放在表格中最后添加的记录上。现在焦点始终在表格的第一个记录上。我一直在网上搜索书签和记录克隆的东西，但我不确定什么能解决问题。

请帮助

谢谢

< blockquote>我明白你的意思了。你不想突出显示记录，你只想选择它。查询中的时间字段是创建记录的时间，还是其他一些不相关的时间？您要将记录移动到记录集的最后一条记录，还是需要根据其他一些条件找到它？

Hi All

I have two issues to put forward.
First is bookmarking / or highlighting a particular record in a form. The form is continuous and the records are from a query result. One of the record in that form will be always the last added record from the table. The form display the records in a sort order from the query. What i need is to highlight or bookmark a particular field of that record (the last record added) whatever the position of the record in the form to get the user''s attention to this record.
Second issue is in the same form when it opens with the records i want to perform a calculation automatically and update one of the field with the new result and save the updated record.
I already mention that the form displayes query result.
There are two date fields/controls and three time fields/controls.
The calculation need to be based on the dates and two time fields and the time need to be updated as per the calculation perofrmed.
The calculation can be done after the form loaded and can place command button to perform this action.
Please guide me how to achieve this.

Thank you all

解决方案

To highlight a particular record, you can add a field to your table/query and mark that record as true and the rest false. Then, do conditional formatting based on that field.
For your second issue, is there any reason you can''t run an update query?

Hi ChipR
Sorry for the late reply. I think my explanation about the issue is not clear. I would like to explain because with your answer i am nowhere reaching for the result. What i am doing is adding records to a table through a form and on click of a button from that form it opens another form which is a result of a query and that form contains few other records and the last added record. But the records are in a sort order already by a time field from the query. So I want to get focus on the record which is added last in the table. Now the focus is always on the first record of the form. I been searching net about the bookmark and recordclone things but i am not sure what would solve the issue.
Please help
Thank you

I see what you mean. You don''t want to highlight the record, you just want to select it. Is the time field in the query the time the record was created, or some other unrelated time? Is the record you want to move to the last record of the recordset, or do you need to find it based on some other criteria?

这篇关于书签和刷新表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！