If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sales Funnel
I am trying to create a form for forcasting. I want to, try to anyway, have
a picture of a funnel that changes as the sale moves through the sales process. Does anyone have any ideas? |
#2
|
|||
|
|||
Sales Funnel
Put several pictures of funnels showing variace levels of full on your form.
Put all of them exactly in the same place so they overlay each other. Make all Their Visible properties = No. Then when you want to show a certain level of fullness, make that control visible and the others hidden. -- Dave Hargis, Microsoft Access MVP "alfiajamel" wrote: I am trying to create a form for forcasting. I want to, try to anyway, have a picture of a funnel that changes as the sale moves through the sales process. Does anyone have any ideas? |
#3
|
|||
|
|||
Sales Funnel
Thanks! If I make that Visible properties=no, what kind of coding would i
use to show the correct funnel picture "Klatuu" wrote: Put several pictures of funnels showing variace levels of full on your form. Put all of them exactly in the same place so they overlay each other. Make all Their Visible properties = No. Then when you want to show a certain level of fullness, make that control visible and the others hidden. -- Dave Hargis, Microsoft Access MVP "alfiajamel" wrote: I am trying to create a form for forcasting. I want to, try to anyway, have a picture of a funnel that changes as the sale moves through the sales process. Does anyone have any ideas? |
#4
|
|||
|
|||
Sales Funnel
Let's say you have 6 funnels named funnel1, funnel2...funnel6.
Then when you want to show say funnel 4, I would thing a sub you can call with the number you want to show would be like: Private Sub ShowFunnel(FunnelNumber As Long) Dim ctl As Control For each ctl in Me.Controls If Left(ctl.Name, 6) = "Funnel" Then If Clng(Right(ctl.Name,1) = FunnelNumber Then ctl.Visible = True Else ctl.Visible = False End If End If Next ctl End Sub Note this is untested "air" code and may need some debugging. -- Dave Hargis, Microsoft Access MVP "alfiajamel" wrote: Thanks! If I make that Visible properties=no, what kind of coding would i use to show the correct funnel picture "Klatuu" wrote: Put several pictures of funnels showing variace levels of full on your form. Put all of them exactly in the same place so they overlay each other. Make all Their Visible properties = No. Then when you want to show a certain level of fullness, make that control visible and the others hidden. -- Dave Hargis, Microsoft Access MVP "alfiajamel" wrote: I am trying to create a form for forcasting. I want to, try to anyway, have a picture of a funnel that changes as the sale moves through the sales process. Does anyone have any ideas? |
#5
|
|||
|
|||
Sales Funnel
I will try that! Thank you so much!
"Klatuu" wrote: Let's say you have 6 funnels named funnel1, funnel2...funnel6. Then when you want to show say funnel 4, I would thing a sub you can call with the number you want to show would be like: Private Sub ShowFunnel(FunnelNumber As Long) Dim ctl As Control For each ctl in Me.Controls If Left(ctl.Name, 6) = "Funnel" Then If Clng(Right(ctl.Name,1) = FunnelNumber Then ctl.Visible = True Else ctl.Visible = False End If End If Next ctl End Sub Note this is untested "air" code and may need some debugging. -- Dave Hargis, Microsoft Access MVP "alfiajamel" wrote: Thanks! If I make that Visible properties=no, what kind of coding would i use to show the correct funnel picture "Klatuu" wrote: Put several pictures of funnels showing variace levels of full on your form. Put all of them exactly in the same place so they overlay each other. Make all Their Visible properties = No. Then when you want to show a certain level of fullness, make that control visible and the others hidden. -- Dave Hargis, Microsoft Access MVP "alfiajamel" wrote: I am trying to create a form for forcasting. I want to, try to anyway, have a picture of a funnel that changes as the sale moves through the sales process. Does anyone have any ideas? |
Thread Tools | |
Display Modes | |
|
|