表格中的编码格式 [英] Coditional Formatting in Form

问题描述

我有一个数据表单附加到查询，该查询在四个字段中搜索到期日期。用户输入日期（查询在每个字段的不同行上具有[输入到期日期]，因此用户仅输入一个日期）。在表单上我需要能够说明字段日期是否> Date（）和< =用户输入的日期返回特定颜色。我的问题是为用户输入日期编写表达式，因为它不是存储在我的表单中的字段。这可能吗？


谢谢，

I have a datasheet form attached to a query that is searching for Expiration dates in four fields. The user inputs a date (query has [Enter Expiration Date] on different rows for each field so the user only inputs one date). On the form I need to be able to say if the field date is > Date() and <= the user inputted date return a specific color. My issue is writing the expression for the user inputed date since it is not a field stored to my form. Is this possible?

Thanks,

推荐答案

字段日期在哪里？你是指？是否与表单绑定为文本框？


comteck

Where is the "field date" you are referring to? Is it tied to the form as a textbox?

comteck

因为您让用户在查询中根据条件格式输入此日期没有被存储为一个单独的实体。


我唯一可以建议的是，你将数据表作为另一种形式的子表单，让用户在其中输入一个未绑定的日期领域。然后，您可以将此字段的值设置为条件标准，而不是条目提示。


然后，您可以在单独存储时引用此值。

Because you have the user entering this date based on conditional formatting in the query it is not being stored as a separate entity.

The only thing I can suggest is that you make the datasheet a subform of another form on which you have the user enter a date into an unbound field. you can then set the value of this field as the conditional criteria instead of the Entry Prompts.

You can then reference this value as it is separately stored.

我有一个数据表格附加到一个查询，该查询在四个字段中搜索到期日期。用户输入日期（查询在每个字段的不同行上具有[输入到期日期]，因此用户仅输入一个日期）。在表单上我需要能够说明字段日期是否> Date（）和< =用户输入的日期返回特定颜色。我的问题是为用户输入日期编写表达式，因为它不是存储在我的表单中的字段。这可能吗？


谢谢，

I have a datasheet form attached to a query that is searching for Expiration dates in four fields. The user inputs a date (query has [Enter Expiration Date] on different rows for each field so the user only inputs one date). On the form I need to be able to say if the field date is > Date() and <= the user inputted date return a specific color. My issue is writing the expression for the user inputed date since it is not a field stored to my form. Is this possible?

Thanks,

因为你让用户根据查询中的条件格式输入这个日期，它不是作为一个单独的实体存储的。


我唯一可以建议你将数据表作为子表单您将用户在未绑定字段中输入日期的另一种形式。然后，您可以将此字段的值设置为条件标准而不是条目提示。


然后，您可以在单独存储时引用此值。

Because you have the user entering this date based on conditional formatting in the query it is not being stored as a separate entity.

The only thing I can suggest is that you make the datasheet a subform of another form on which you have the user enter a date into an unbound field. you can then set the value of this field as the conditional criteria instead of the Entry Prompts.

You can then reference this value as it is separately stored.

谢谢！


我这样做了，我认为它会起作用。我猜我需要一个Update After事件或类似的东西，以便在输入日期后更新子表单。我是新手，不知道如何开始。我应该使用更新后的属性[事件过程]还是需要在VBA中编写？我该怎么做？


谢谢！

Thank You!

I did that and I think it will work. I''m guessing I need an Update After event or something like that to have the subform update once the date is entered. I''m new at this and have no idea how to begin. Should I use the property After Update [Event Procedure] or do I need to write it in VBA? How do I do either?

Thanks!

这篇关于表格中的编码格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！