Progress bar on form based on field data? (1 Viewer)

NickDenyer · Jan 29, 2016

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

RuralGuy · Jan 29, 2016

What are you having problems with? Making the Progress Bar show the completion?

NickDenyer · Jan 29, 2016

Hi RuralGuy,

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

CJ_London · Jan 29, 2016

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

pbaldy · Jan 29, 2016

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.

pbaldy · Jan 29, 2016

Boy, who's the slow typist in this group?

NickDenyer · Jan 29, 2016

pbaldy said:
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 · Feb 16, 2016

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!

pbaldy · Feb 16, 2016

You wouldn't have gaps if you counted how many controls had been filled out and make that many labels visible.

NickDenyer · Feb 16, 2016

pbaldy said:
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!

pbaldy · Feb 16, 2016

Have you tried the For/Next loop mentioned in post 5?

jdraw · Feb 16, 2016

see this free video from Datapig

NickDenyer · Feb 17, 2016

pbaldy said:
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 · Feb 17, 2016

jdraw said:
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!

pbaldy · Feb 18, 2016

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

NickDenyer · Feb 19, 2016

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

Thanks for your response, pbaldy. Have I got no choice then regarding a button? As I'd really rather not have a cmd button. I was hoping that as each field has data entered then the bar would progress, which is where the afterupdate comes into play. I'm pretty stuck with this whole issue as its way above my access capabilities.

Any further info would be greatly appreciated!

Thanks!

RuralGuy · Feb 19, 2016

I don't think pbaldy has suggested a button anywhere Nick. I'm a bit puzzled by your last post.

NickDenyer · Feb 19, 2016

RuralGuy said:
I don't think pbaldy has suggested a button anywhere Nick. I'm a bit puzzled by your last post.

Thanks for the reply, RuralGuy. Must be my mistake then, just pbaldy had put 'regarding the button' but I've obviously misread.

Sorry!

RuralGuy · Feb 19, 2016

He was suggesting you create a function that bumps the progress meter and call it from the AfterUpdate event of each control the user is completing. No button involved.

NickDenyer · Feb 19, 2016

RuralGuy said:
He was suggesting you create a function that bumps the progress meter and call it from the AfterUpdate event of each control the user is completing. No button involved.

Ah I see ok my apologies for the misunderstanding!

Progress bar on form based on field data? (1 Viewer)

Registered User.

AWF VIP

Registered User.

Super Moderator

Wino Moderator

Wino Moderator

Registered User.

Registered User.

Wino Moderator

Registered User.

Wino Moderator

Super Moderator

Registered User.

Registered User.

Wino Moderator

Registered User.

AWF VIP

Registered User.

AWF VIP

Registered User.

Similar threads

Users who are viewing this thread