Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Long, Crystal
  New Posts New Posts RSS Feed - Random Picker for Access by Crystal
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)

Random Picker for Access by Crystal

 Post Reply Post Reply
Crystal Long View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 21 May 2012
Location: Colorado
Status: Offline
Points: 35
Post Options Post Options   Thanks (0) Thanks(0)   Quote Crystal Long Quote  Post ReplyReply Direct Link To This Post Topic: Random Picker for Access by Crystal
    Posted: 24 May 2012 at 9:15am

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

written as an example for this video on picking a winner

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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:

s02_RandomPicker_Pick Table or Query_ Datasheet view.png

Feedback is appreciated, thank you

Warm Regards,

Microsoft MVP
remote programming and training

Access Basics by Crystal
Free 100-page book that covers essentials in Access

   (: have an awesome day :)
Warm Regards,
Microsoft MVP
Remote Training & Programming
Let's Connect and Build Together
~have an awesome day ~
Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down