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


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down