提醒日期在列表框中 [英] Reminder dates in listbox

问题描述

大家好，


我有这样的选择查询：

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | 换行 | 行号

解决方案

（19.1 KB，140 views）

Hi all,

I have a select query like this:

Expand|Select|Wrap|Line Numbers

解决方案

@tuxalot

I would like the dates that are within 5 days of expiring to show in red text.

Don''t think that this would be feasible. Why not simply have a 2nd List Box for this Function, or prompt the User for a specific amount of Days within an Expiration Date prior to populating the List Box?

I''m not sure that this is possible within a list box, but you could certainly open a continuous form (or a subform on the form) with this as the data set, and use conditional formatting on the expiration date control. A button on the form could be used to send email notices for multiple records, or a button on each record for individual ones. Lots of options.

A second listbox is an option - but prompting the user for a specified date might not. Some items may be put on the "tickler" for 30 days, others maybe only a few days. Depends on the issue at hand.

Not sure how to implement a second listbox. Perhaps you can point me in the right direction or provide examples?

I''ve attached a png for reference.

Thanks,

Tux

Attached Images

notes.jpg (19.1 KB, 140 views)

这篇关于提醒日期在列表框中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！