473,320 Members | 1,948 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Duplicate Graphic based on Data Records

maxamis4
295 Expert 100+
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?
Jul 15 '13 #1
7 998
Rabbit
12,516 Expert Mod 8TB
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.
Jul 15 '13 #2
zmbd
5,501 Expert Mod 4TB
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:
Expand|Select|Wrap|Line Numbers
  1.                      Form Title
  2. -----------------------------------------------------
  3. Current Process
  4. -----------------------------------------------------
  5.    [img1]    [img1]    [img1]    [img1]    [img1]
  6.  
  7.    [img1]    [img1]    [img1]    [img1]    [img1]
  8.  
  9.  

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

Expand|Select|Wrap|Line Numbers
  1.                      Form Title
  2. -----------------------------------------------------
  3. Current Process
  4. -----------------------------------------------------
  5.    [img1]    [img1]    [img1]    [img1]    [img1]
  6.  
  7.    [img1]    [img1]
  8.  
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 !
Jul 15 '13 #3
maxamis4
295 Expert 100+
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.
Attached Files
File Type: pptx Process_Example.pptx (49.3 KB, 281 views)
Jul 15 '13 #4
zmbd
5,501 Expert Mod 4TB
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...
Jul 15 '13 #5
maxamis4
295 Expert 100+
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.
Jul 15 '13 #6
Rabbit
12,516 Expert Mod 8TB
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.
Jul 15 '13 #7
maxamis4
295 Expert 100+
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.
Jul 15 '13 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Java script Dude | last post by:
Some programmers prefer to stay with native level data structures such as string arrays instead of using Object based data structures such as ArrayList. From and efficiency point of view. Are...
1
by: Eric | last post by:
Hi, Can the English version of Sql Server (or other DBMSs) store data/records in other languages (e.g. French, Chinese, etc.) or do you have to use the French version of Sql Server to store...
1
by: Mark Jerde | last post by:
Googling and GoogleGrouping for "XML Byte Data Records" and similar bring back millions of hits about character sets. ;-) Is XML appropriate for specifying and validating byte-oriented data? ...
3
by: Jason | last post by:
I am trying to filter records in a primary form based on records in related tables. The data in the related tables is being displayed in the primary form through subforms. To be more specific, I...
2
by: A P | last post by:
Hi! I am using Web Matrix in learning ASP.Net and I am only using MS Access as my database. What namespace and Connection that I may use to handle this? As stated on the ASP.Net...
5
by: Will | last post by:
- I know enough ASP and Access to be dangerous :) - I need to put up a data base on our web server with 3 related tables. - They will be accessed by a limited number of people. - Each user will...
2
by: Harry Haller | last post by:
I want to duplicate the form data, edit it to remove some items (such as __EVENTTARGET, __EVENTVALIDATION, etc) and save it to a log. How can I make a duplicate (editable) copy of the Form...
4
by: mcca0081 | last post by:
hi - i'm trying to delete one of the duplicate records based on the most current date. here's the code for my access 2000 db. any help would be appreciated!!! - thank you kindly Sub...
1
by: VinArt | last post by:
MS Acc 2003, XP Thank you in advance for any help. I have tables called "Makeup" and "Lines". Each makeup can have multiple lines. Goal is to create a new "makeup" with identical "lines"...
4
by: ravir81 | last post by:
Hi, I am currently working on excel validation using Perl. I am new to Excel validation but not for Perl. I have a question regarding one of the validation. Could anyone please tell me how to get...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.