Solved Stats increasing rapidly

[Kayleigh]

Hi
I'm not sure what the official name of this is so I'm not able to search for it but I'm sure there's a way to do it.
I'm looking to increase the stats on a form on open to the current figure very quickly from 1. I often see this effect on websites e.g. on Forbes it gives figure of number of readers.
Would appreciate any leads on this

 

[GPGeorge]

Hi
I'm not sure what the official name of this is so I'm not able to search for it but I'm sure there's a way to do it.
I'm looking to increase the stats on a form on open to the current figure very quickly from 1. I often see this effect on websites e.g. on Forbes it gives figure of number of readers.
Would appreciate any leads on this

Are you talking about a counter that shows how many readers have looked at a web page or something like that?

"Stats" is a generic word. Therefore we are at a loss until we know the specific thing you want to count or however it is being measured.

 

[The_Doc_Man]

There is an old rule: Access can never tell you anything you didn't tell it first, or at least tell it HOW to tell you.

If you want a form to show you some kind of statistics, that implies that you must make the measurement that leads to the stats in question.

If George's guess is correct, then the form "On_Open" or "On_Load" event must increment whatever it is that you are counting for that form. WHERE you store that info is up to you and there are a ton of places - but if this is to persist, then it has to be table-based. Memory-based in a global variable or in a TempVars object will reset each time you exit. Tables, however, won't.

Be a bit more specific and we might be able to give you a code snippet. But I think you can see from the responses that you WERE maybe just a little vague in your question. I'd give you a better answer but trying to keep up with my wife's decorating ideas has kind of blown out my mind-reading neurons.

 

[arnelgp]

are you talking of number of users of your db?
see this demo.

 

[Kayleigh]

To clarify the counts are actually of how many clients the business has and how many jobs done. This is simple data which will increase with each job entered on the DB.
I am after the method that increments the numbers from 1 to the current figure very quickly. Obviously this will be on the open or current event.

 

[Pat Hartman]

Use domain functions to "count" the information. Place the following expressions (change the table names if necessary) in the ControlSource of two controls on the form where you want to see the count.

=DCount("*","tblCustomers")

=DCount("*", "tblJobs")

 

[Kayleigh]

I know how to calculate it! I am just looking if it is possible to show the user the numbers increasing very rapidly until the current figure when they log in to the home screen?

 

[Mike Krailo]

Me.requery or me.recalc might be what your after.

What on God's green earth do you mean by numbers increasing rapidly? Statistics such as counts are calculated instantly.

WAIT, are you talking about animation of the numbers in a fancy way?

 

[arnelgp]

use Timer Event to Requery the Controls.

 

[Pat Hartman]

Just because you can do something, doesn't mean you should.

If you decide to do this and decide to use a Timer, make absolutely sure that you never, ever make design changes to the database while the timer is running. Best option is to have a way for YOU to turn off the timers when you want to make design changes. to any objects.

 

[Mike Krailo]

OP's asking about the animation effect of the number of readers on Forbes. It probably won't look exactly like on that web page, but why even do this? Get the functionality of your system working and your done. I'm with Pat on this one.

 

[GPGeorge]

Me too. That's a bit of flash that is "fun" is you visit a website once a day. In a production relational database application, your users will get tired of it pretty quickly. Unless this is exclusively for sales and marketing people who are interested in that kind of thing.....

 

[arnelgp]

some demo using timer event.

 

[Kayleigh]

Thanks @arnelgp

This is what they are after! Lets see how quickly they lose interest...

 

[MajP]

I did an example of this count up "dramatic effect" with a graphic to be even more obnoxious. Same idea of using the timer to animate.

Speedometer Dashboard

Hi All, I am wanting to add a dashboard form with multiple speedometers to display progress and project health. Is there an example that someone could share with me. Cheers Mick

www.access-programmers.co.uk

This one idea is the same for building progress meters.

 

[Mike Krailo]

This is what they are after! Lets see how quickly they lose interest...

I lost interest already. That's more annoying than those force advertisements that are forced on you before viewing the content of a video on YouTube.

 

[GPGeorge]

Thanks @arnelgp

This is what they are after! Lets see how quickly they lose interest...

Your users actually asked for that feature?

 

[Kayleigh]

@arnelgp is it possible to speed up the numbers - stats I'm talking about are at least 100k...

 

[arnelgp]

try this, is 100th part of the total record.