VBA -- Winner by Random DrawTo pick the next winner of an hour of free training, I wrote a program in VBA to determine a winner by random draw. I have created? a form you can download to pick a random record from any table or query. Download and get instructions here: http://www.AccessMVP.com/strive4peace/RandomPicker VBA stands for Visual Basic for Applications and is the coding language for Access. I quickly cover how the code was done, for the benefit of those who already program. This is NOT where I intend to start teaching you VBA ... so, if you are are new to coding, please don't get frustrated! ... think of it as dipping your toes into an ocean ... enjoy the cool feel of the water...whether you can swim or not! When I do teach you VBA, it will be introduced with simple concepts and build as we go along -- and I will keep it interesting for those of you on a higher level (smile) -- you will learn and you will get better. Congratulations to our new winner! Send me email to set up your free training. The next 'drawing' will be made from the first 50 to make nice comments ... actually from 2 to 51 since the first to comment already won :) ... and I'll get the range for the random number right this time (thanks, John) * have an awesome day :) ~~~ more Access Tutorials http://www.EverythingAccess.com/tutorials.asp ~ code pour embarquer la vidéo : >>> http://www.youtube.com/embed/ToSv1v1FY5A <<< |