Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-29-2016, 07:32 AM   #1
NickDenyer
Newly Registered User
 
Join Date: May 2012
Posts: 57
Thanks: 33
Thanked 0 Times in 0 Posts
NickDenyer is on a distinguished road
Progress bar on form based on field data?

Hi all!

Wondered if somebody could help me...

I have 26 fields on a form that require manual data input. I want a progress bar at the top of the form to show the user how much % they have completed, as I want 100% completed data per record.

Can find plenty of threads on progress bars, but they all appear to be cmd button based, or based on loading.

Can anyone assist me please?

Thank you!

N

NickDenyer is offline   Reply With Quote
Old 01-29-2016, 07:49 AM   #2
RuralGuy
AWF VIP
 
RuralGuy's Avatar
 
Join Date: Jul 2005
Location: @ 8300' in the Colorado Rockies
Posts: 13,821
Thanks: 7
Thanked 311 Times in 301 Posts
RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice
Re: Progress bar on form based on field data?

What are you having problems with? Making the Progress Bar show the completion?
__________________
(RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, Win10 Pro
Please post back to this Forum so all may benefit.
Teaching is not filling a bucket but lighting a fire.
RuralGuy is offline   Reply With Quote
The Following User Says Thank You to RuralGuy For This Useful Post:
NickDenyer (02-17-2016)
Old 01-29-2016, 07:49 AM   #3
NickDenyer
Newly Registered User
 
Join Date: May 2012
Posts: 57
Thanks: 33
Thanked 0 Times in 0 Posts
NickDenyer is on a distinguished road
Re: Progress bar on form based on field data?

Hi RuralGuy,

All of it! Have no idea where to start! Any help would be greatly appreciated!

NickDenyer is offline   Reply With Quote
Old 01-29-2016, 07:51 AM   #4
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,334
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Progress bar on form based on field data?

just base it on the after update event for each question so the bar is refreshed every time the user completes a control.

The examples you found will show how to create a progress bar
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
NickDenyer (02-17-2016)
Old 01-29-2016, 07:51 AM   #5
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,306
Thanks: 13
Thanked 4,113 Times in 4,045 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Progress bar on form based on field data?

You can put x number of textboxes lined up on the form. Change the back color or make them visible based on the progress made. Do that from a function called from the after update event of each control. It counts the controls filled out and decides from that how many to affect. That can be done with a For/Next loop and numbered textboxes like "txtProgBar1", "txtProgBar2", etc. You refer to them in your loop like:

Me.("txtProgBar" & x)

where x is your loop counter.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
NickDenyer (02-17-2016)
Old 01-29-2016, 07:51 AM   #6
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,306
Thanks: 13
Thanked 4,113 Times in 4,045 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Progress bar on form based on field data?

Boy, who's the slow typist in this group?
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
NickDenyer (02-17-2016)
Old 01-29-2016, 07:52 AM   #7
NickDenyer
Newly Registered User
 
Join Date: May 2012
Posts: 57
Thanks: 33
Thanked 0 Times in 0 Posts
NickDenyer is on a distinguished road
Re: Progress bar on form based on field data?

Quote:
Originally Posted by pbaldy View Post
Boy, who's the slow typist in this group?
Haha guess it's an eager group! Thanks for the support everyone, will give a few things a try and see how they turn out!

If anyone else has some ideas the more the merrier!

Cheers!

NickDenyer is offline   Reply With Quote
Old 02-16-2016, 04:24 AM   #8
NickDenyer
Newly Registered User
 
Join Date: May 2012
Posts: 57
Thanks: 33
Thanked 0 Times in 0 Posts
NickDenyer is on a distinguished road
Re: Progress bar on form based on field data?

Hi again all!

So I've been reading up on progress bars but I'm still unsure...

I have added one to my form via activex, but am unsure of how the form interprets my 30+ fields as a whole. I thought about doing 30 labels and assigning each as hidden, and enabling them visible once data has been added to a field. But this will mean gaps in my progress bar as the first field might be entered last etc based on data that we have. Any thoughts? Can anyone explain this to me please?

thanks!
NickDenyer is offline   Reply With Quote
Old 02-16-2016, 07:01 AM   #9
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,306
Thanks: 13
Thanked 4,113 Times in 4,045 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Progress bar on form based on field data?

You wouldn't have gaps if you counted how many controls had been filled out and make that many labels visible.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
NickDenyer (02-16-2016)
Old 02-16-2016, 07:03 AM   #10
NickDenyer
Newly Registered User
 
Join Date: May 2012
Posts: 57
Thanks: 33
Thanked 0 Times in 0 Posts
NickDenyer is on a distinguished road
Re: Progress bar on form based on field data?

Quote:
Originally Posted by pbaldy View Post
You wouldn't have gaps if you counted how many controls had been filled out and make that many labels visible.
Thank you for getting back to me! Unfortunately I'm not as skilled as I feel this level of knowledge requires: How do I do what you have mentioned above?

Thank you!
NickDenyer is offline   Reply With Quote
Old 02-16-2016, 01:18 PM   #11
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,306
Thanks: 13
Thanked 4,113 Times in 4,045 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Progress bar on form based on field data?

Have you tried the For/Next loop mentioned in post 5?
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
NickDenyer (02-17-2016)
Old 02-16-2016, 01:30 PM   #12
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,239
Thanks: 93
Thanked 2,026 Times in 1,973 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Progress bar on form based on field data?

see this free video from Datapig
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
The Following 2 Users Say Thank You to jdraw For This Useful Post:
leonf (02-19-2016), NickDenyer (02-17-2016)
Old 02-17-2016, 12:52 AM   #13
NickDenyer
Newly Registered User
 
Join Date: May 2012
Posts: 57
Thanks: 33
Thanked 0 Times in 0 Posts
NickDenyer is on a distinguished road
Re: Progress bar on form based on field data?

Quote:
Originally Posted by pbaldy View Post
Have you tried the For/Next loop mentioned in post 5?
Thanks for the reply pbaldy - no I haven't, as I'm unsure what this is but I'll do some research thank you!
NickDenyer is offline   Reply With Quote
Old 02-17-2016, 12:54 AM   #14
NickDenyer
Newly Registered User
 
Join Date: May 2012
Posts: 57
Thanks: 33
Thanked 0 Times in 0 Posts
NickDenyer is on a distinguished road
Re: Progress bar on form based on field data?

Quote:
Originally Posted by jdraw View Post
see this free video from Datapig
Thanks for passing this on to me, jdraw. Problem is, like so many posts, this relies on a cmd button. What I'm looking to do is have a form with 30 fields, and as you add data to each field the progress bar fills up based on how much you have completed. But this video has gave me insight into the background working of the bar. I think I need to research 'loops' in access.

Thanks very much!
NickDenyer is offline   Reply With Quote
Old 02-18-2016, 11:53 AM   #15
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,306
Thanks: 13
Thanked 4,113 Times in 4,045 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Progress bar on form based on field data?

Regarding the button, I'd create a little function and call it from the after update event of the 30 controls.

__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
NickDenyer (02-19-2016)
Reply

Tags
data , field , form , progress bar

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Forcing Data Entry into Form Fields to progress Davrini Forms 4 09-09-2012 06:44 PM
help with nested if and open a certain form based on field data krowe Modules & VBA 4 02-24-2012 01:39 AM
Form that displays a count of data based on a drop down field MrArcanum Forms 1 12-08-2009 09:54 AM
progress bar based on date mcgraw Modules & VBA 1 11-25-2009 10:35 AM
Use table data based on form field selection skwilliams Modules & VBA 3 09-07-2004 10:02 AM




All times are GMT -8. The time now is 12:40 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World