Random Picker for Access by Crystal |
Post Reply |
Author | |
Crystal Long
Microsoft MVP Joined: 21 May 2012 Location: Colorado Status: Offline Points: 35 |
Post Options
Thanks(0)
Posted: 24 May 2012 at 9:15am |
uploads/84/DB_RandomPicker_Crystal_110602__ACCDB_TXT_PNGs.zip
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Have you ever wanted to be able to pick a random record? From ANY table or query? Now it is easy! All you need is ONE form: f_RANDOM_PICKER All the necessary code is behind this form. There is a sample table and a few sample queries so you can see how the Random Picker works -- you will use your own tables and queries once this form is in your working database. To bring the Random Picker into another database, all you have to do is: 1. import the f_RANDOM_PICKER form into your working database 2. compile and save database 3. open the f_RANDOM_PICKER form When the form opens, there is a combobox that shows the names of your tables and select queries. Choose whatever you want! Then click the "Pick a Winner" command button For more details and a listing of the code, visit: Random Picker Form ... import form into any Access database use combobox to choose table or query by Crystal http://www.AccessMVP.com/strive4peace/RandomPicker.htm written as an example for this video on picking a winner http://www.youtube.com/watch?v=ToSv1v1FY5A ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ contents of ZIP: 1. DB_RandomPicker_Crystal_110602.accdb database in Access 2007 format with the f_RANDOM_PICKER form, a sample table, and sample queries. The form is all you need to import into another database to run the Random Picker 2. ReadMe_RandomPicker~Crystal.txt information similar to what you are reading in this post 3. screen shots: s01_RandomPicker_startupForm.png s02_RandomPicker_Pick Table or Query_ Datasheet view.png s03_RandomPicker_PickaWinner_Record_selected_highlighted.png Feedback is appreciated, thank you Warm Regards, Crystal Microsoft MVP remote programming and training Access Basics by Crystal http://www.AccessMVP.com/strive4peace Free 100-page book that covers essentials in Access http://www.YouTube.com/LearnAccessByCrystal * (: have an awesome day :) * |
|
Warm Regards,
Crystal Microsoft MVP Remote Training & Programming Let's Connect and Build Together http://www.AccessMVP.com/strive4peace http://YouTube.com/LearnAccessByCrystal ~have an awesome day ~ |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |