![]() ![]() This can be used almost anywhere, and only requires a few extra lines of code, and three additional objects on a Form. Obviously you have put a lot of thought into creating a customizable display for any possible application.įor my tastes though, (and please don't take this as a knock against your Progress Meter), it does seem to overly complexify what can be a very simple addition to any form that runs through a series of values.Īttached is a very simple Form, demonstrating the Progress Bar I use on my forms. ![]() It can be used for anything where the total number of items to be processed is known, and there is a method of counting the items as they are dealt with.įirst, very impressive! I, too, like to include progress meters when Access is doing something with a series of records or values (or even sorting, for that matter). The Progress Meter is not restricted to counting records. Then we loop round reading each record and increment a counter and display whatever information is required about the record. Then we set the titles, speed & colours required. I am not going to go into the code because it is reasonably obvious from the sample database.īriefly, you need to get the total of the number if items to be shown (Often RecordCount) Here is a sample Db for the above database The Progress Meter needs to know how many records it has to process (Often found by moving to the end or a RecordSet and retrieving the RecordCount) and how many records have been processed.īelow is a picture of a sample Db to show the parameters that can be enterd:. In this example we go from Red to Green, obviously the 5 titles, and the detailed information displayed. The parameters that can be changed are the start and end colour of the bar. There are a number of parameters that need setting up, obviously more than on the standard Access Progress bar. This last line (subject to the words fitting on it) shows the English word and (hopefully) the Mongolian equivalent. The third line informs us that there are 463 words to translate and on the forth line we find that 308 words have been translated (67%) as seen on the bottom line. ![]() Second line a bit more information that it is translating from English to Mongolian. The top line tells us what it is doing - in this case translating. In addition, while you are waiting for the process to complete, it’s nice to have something pretty to look at. However, I feel that this is frequently not seen, and gives very little information about what the progress actually is. The usual technique is to show the status bar moving on at the bottom of the screen. Frequently with Access databases a process takes a certain amount of time to complete, such as updating a large number of records, or reading information from the internet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |