Sorting Form - Animated Sort Examples & Timer (1 Viewer)

Status
Not open for further replies.

BlueIshDan

☠
Local time
Today, 10:23
Joined
May 15, 2014
Messages
1,122
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: Sorts.png

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

Regards,
BlueIshDan :)
 
Last edited:

pr2-eugin

Super Moderator
Local time
Today, 13:23
Joined
Nov 30, 2011
Messages
8,494
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. :cool:
 

BlueIshDan

☠
Local time
Today, 10:23
Joined
May 15, 2014
Messages
1,122
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

☠
Local time
Today, 10:23
Joined
May 15, 2014
Messages
1,122
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

VIP From a land downunder
Local time
Tomorrow, 00:23
Joined
Jan 5, 2009
Messages
5,041
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

☠
Local time
Today, 10:23
Joined
May 15, 2014
Messages
1,122
Thank you very much for this guidance :) I will attach one for many versions.
 

BlueIshDan

☠
Local time
Today, 10:23
Joined
May 15, 2014
Messages
1,122
RainLover,

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

Regards,
BlueIshDan
 

RainLover

VIP From a land downunder
Local time
Tomorrow, 00:23
Joined
Jan 5, 2009
Messages
5,041
Thanks for the 2003 Version.

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

Also some more comments would be nice.

Thanks again
 

RainLover

VIP From a land downunder
Local time
Tomorrow, 00:23
Joined
Jan 5, 2009
Messages
5,041
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

☠
Local time
Today, 10:23
Joined
May 15, 2014
Messages
1,122
Reload, scrambles the sizes of the lines. Clicking sort, will sort them based on the selected sort style in the combo box.
 

BlueIshDan

☠
Local time
Today, 10:23
Joined
May 15, 2014
Messages
1,122
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

AWF VIP
Local time
Today, 09:23
Joined
Jun 21, 2011
Messages
5,901
Nice bit of code just not sure where or what it would apply to. But fun to watch... Kudos!
 

vbaInet

AWF VIP
Local time
Today, 13:23
Joined
Jan 22, 2010
Messages
26,374
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

☠
Local time
Today, 10:23
Joined
May 15, 2014
Messages
1,122
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.
 
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom