Forum Discussion
Muhammad-Esq
May 17, 2022Copper Contributor
Filter & Auto number in Tasks Management Template
Hi all, I have two problems: 1. Completed Tasks: - I use a DB based on Task Management template. - When I open the form (Tasks List) it doesn't show the "Completed" tasks. How can I mak...
- May 17, 2022
You can determine how filtering is done in the Tasks List form by examining its recordsource. It probably has a criteria that excludes completed tasks. That might be something like "WHERE Status<>"Complete" or "WHERE Status <> 4" where 4 is the ID for status of Complete. That's the most likely situation. You can modify it if you prefer to see all tasks, or you can add a option to see all tasks, or only open tasks.
If the task numbers will vary between reports, i.e. you want the sequence only to represent the current set of tasks, there is a way to create a sequence number on the fly when the report or form opens.
Muhammad-Esq
May 18, 2022Copper Contributor
Your time and care are so much appreciated George. I followed your guidance and both issues worked.
Thank you so much bro 🙂
Thank you so much bro 🙂
Muhammad-Esq
May 18, 2022Copper Contributor
One more thing, in the report view, I want to add vertical lines among the columns.