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 17, 2022Copper Contributor
Many thanks George_Hepworth for your answer>
Regarding filtering the (Completed) tasks, I didn't make any modification in that part, I think the Access, for some logic, does it by default. You may have a look on it, it is an access template. thanks again.
Regarding the autonumbering, (1) Dont worry 🙂 I will not do that and touch the ID.
(2) To be clear, when I open the Task List or generate a report, I just want, simply, to see a regular serial, that's it, not 1, 3, 4, 7 because I deleted (2, 5, 6).
If it is difficult to make it in the form view,m then at least in the report view.
thanks again.
George_Hepworth
May 17, 2022Silver Contributor
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-EsqMay 18, 2022Copper ContributorYour time and care are so much appreciated George. I followed your guidance and both issues worked.
Thank you so much bro 🙂- Muhammad-EsqMay 18, 2022Copper ContributorOne more thing, in the report view, I want to add vertical lines among the columns.