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

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Random Picker for Access by Crystal

 Post Reply Post Reply
Author
Message
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
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 ~
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.