Sorting Form - Animated Sort Examples & Timer

[BlueIshDan]

Access Database 2010: View attachment Sorter.zip
Access Database 2002-2003: View attachment Sorter.mdb

The attached access database above contains a form which allows the user to select a type of sort and display a visual example of how the sort works.

The sorts available in this form are as follows:
- QSort
- Bubble
- Shell

To further the users education on sorts, this form allows the user to randomize the values being sorted. Different patterns in values are sorted faster and slower by certain sorts.

Here is an image of the form:

Hope this can be of some education for anyone trying to learn sorts!

Regards,
BlueIshDan

 

[pr2-eugin]

That is quiet impressive ! I will probably study the code. Just for future references, these sort of files/examples could go into the Sample Databases/Code Repository section of the Forum. Many might be helped by that.

I only have a few suggestions for you

1. If you could describe briefly about what the file is (in this case, what sorting is and where it could be implemented),
2. What it does (this one is self explanatory - sorts and visual effects),
3. Maybe show a bit of code (mainly on how to call functions),
4. Check for compatibility before posting (this file needs a DLL which pops up as missing reference TIME).

If you post it here, it might be forgotten/missed. Kudos on the effort.

 

[BlueIshDan]

Whoops sorry for posting it in the wrong area . I just started yesterday.
Thank you for the tips! I will be sure to post it in the right area.

Have you figured out which reference was missing?

Regards,
BlueIshDan

 

[BlueIshDan]

Oh dear lol. I believe that reference was from windows xp(when i designed this form a few months back) I will fix it, thanks!

 

[RainLover]

Whoops sorry for posting it in the wrong area . I just started yesterday.
Thank you for the tips! I will be sure to post it in the right area.

Have you figured out which reference was missing?

Regards,
BlueIshDan

May I suggest that you let people know what version the Database is in. eg 2010.

I would also suggest using an older version if you can. 2003 is best. The reason is that not everyone has the later versions and they are not overly compatible with each other.

 

[BlueIshDan]

Thank you very much for this guidance I will attach one for many versions.

 

[BlueIshDan]

RainLover,

A 2002-2003 version of the sorter has been tested and added
Thank you again for this kind reminder

Regards,
BlueIshDan

 

[RainLover]

Thanks for the 2003 Version.

I did notice the lack of use of "Option Explicit"

Also some more comments would be nice.

Thanks again

 

[BlueIshDan]

For my knowledge:
Did it work alright for you?

 

[RainLover]

Dan

I am not sure what is supposed to happen but when I hit Reload or Sort then the horizontal lines change.

I would assume that this is for some special application. Hence my suggestion for comments would again help.

 

[BlueIshDan]

Reload, scrambles the sizes of the lines. Clicking sort, will sort them based on the selected sort style in the combo box.

 

[BlueIshDan]

Clicking the reload button randomizes the the sizes of the lines.
Clicking the sort button sorts the lines based on the selected sort style.
You can select a sort style in the combo box.

 

[GinaWhipp]

Nice bit of code just not sure where or what it would apply to. But fun to watch... Kudos!

 

[vbaInet]

I've only just realised the links in your sig.

Nice little animation going on there. I haven't really looked at the code but I'm guessing you're implementing the Q Sort and Bubble Sort algorithms in VBA? One of these algorithms is useful for sorting arrays and dictionary objects.

 

[BlueIshDan]

This application simply visually displays the order of which the selected Sorting Method follows. They line size randomizing is for the affect of different data values in different orders.

It is for people who are learning about sorting.