Duplicate Graphic based on Data Records

[maxamis4]

Hello everyone,

I am not sure if this is the right place to ask the question but I figured its a form related issue so why not give it a shot.

What I am trying to do is build a Business Process Application in Access. What I want to do is use a process arrow image to show the status of where the process stands. Now the problem I am having is that i have multiple processes that have different number of tasks involved in each process. Some processes has 12 tasks others have 20 tasks. This is where my problem starts, how can i leverage one image and make multiple copies of it representing each individual task. Visualization of where you stand in the process pretty much. Anyone have any suggestions on how to do this in a form?

[Rabbit]

I wouldn't use copies of it, I would just move the image around by setting its top and left property to the correct location.

[zmbd]

Ok,

IMHO: this is overly complicated. In my lab the staff much prefers a simple list that clearly states the task at hand.

Do you want one form that shows the same image over and over again for each process...
For example say you have a Process that has 10 tasks:

                     Form Title
-----------------------------------------------------
Current Process
-----------------------------------------------------
   [img1]    [img1]    [img1]    [img1]    [img1]

   [img1]    [img1]    [img1]    [img1]    [img1]

and when your assigned employee closes out, say three of them you would have?

                     Form Title
-----------------------------------------------------
Current Process
-----------------------------------------------------
   [img1]    [img1]    [img1]    [img1]    [img1]

   [img1]    [img1]

Or would you prefer a piechart which could be filled in to match the percentage of the process tasks completed....
Add a chart to a form or report Use a cross-tab query to group in the process and return a count of the closed records and total records. You can then calculate the percentage etc...
Or a bar chart...


{edit} Rabbit has a good idea too !

[maxamis4]

The problem is that I am not looking to have just one image. I want the user to see where he or she is in the process and be able to look back and reference completed items in the past process.

I am attaching a ppt. so you can see what i mean.

[zmbd]

You Might be able to do this with conditional formating.
Change the appearance of a control by using conditional formatting (v2007)
Red, green, blue, etc...

[maxamis4]

Thanks for the response. I have not issues with the properties of the arrows, I am very well versed in that. My concern is the number of tasks. I may have one process with 12 tasks (require 12 arrows) versus another process where I have 5 tasks. My question is how to dynamically create Tasks (Arrows) based on the different processes? Does that makes sense.

[Rabbit]

That depends on your table design. In a normalized design, each task will be its own record. In which case you just put a textbox over an arrow graphic and use a continuous form.

[maxamis4]

How would that work on a horizontal process. I thought about using continuous form. But that only applies vertically and doesn't provide the aesthetic view that i am looking.