brief view of order status

[Guest]

Hi All,

We have an order management software made in access. Our orders have a poor
visibility of their status. When we get an orders there are certain tasks we
have to do in order to complete the “shipmentâ€. There are about 20 such tasks
which should be completed. Sometimes a new task may be inserted or deleted as
per the requirement of that particular order.

The problem is that the data is scattered all-over the database (it is
entered on different forms). I wish we could have a brief view (if possible
graphical view) of such tasks and its current status.

I wish to know if anyone has faced similar kinds of requirements. How they
designed such forms. Is there any good example of that?

Any clue would be highly appreciated.

Regards
Avir

 

[Guest]

Hi Avir,

I think I'd try using a form to display the order information, and a pair of
multi-select list boxes to display tasks that need to be done and completed
tasks. This should not be too difficult if you have a properly normalized
database. You will likely need a boolean (Yes/No) datatype in a linking table
that links a task table to an orders table; this boolean field would indicate
if the task has been completed. For tracking purposes, you could also add a
Date/Time field to this linking table to capture when the task was completed,
and perhaps even another field to capture who completed the task.

The queries that feed the listboxes would filter based on the status of the
boolean field. For example, if the name of the field was blnTaskCompleted, a
listbox on the right-hand side would include all tasks where blnTaskCompleted
= 0, and the left-side listbox would include all tasks where blnTaskCompleted
<>0. The action of moving a task from one listbox to the other would also
need to set the value of the blnTaskCompleted field appropriately.

For a tutorial on using a paired multi-select list box, see Helen Feddema's
archive # 72: http://www.helenfeddema.com/access.htm

(Well, I think it is # 72, if memory serves me correctly, but her page seems
to be temporarily unavailable, so I cannot verify this right now).


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi All,

We have an order management software made in access. Our orders have a poor
visibility of their status. When we get an orders there are certain tasks we
have to do in order to complete the “shipmentâ€. There are about 20 such tasks
which should be completed. Sometimes a new task may be inserted or deleted as
per the requirement of that particular order.

The problem is that the data is scattered all-over the database (it is
entered on different forms). I wish we could have a brief view (if possible
graphical view) of such tasks and its current status.

I wish to know if anyone has faced similar kinds of requirements. How they
designed such forms. Is there any good example of that?

Any clue would be highly appreciated.

Regards
Avir