Print Page | Close Window

Random Picker for Access by Crystal

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Long, Crystal
Forum Description: Access Basics is designed for those of you with a thirst to understand the fundamentals of Access with programming in mind ... whether you realize it or not.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=586
Printed Date: 17 Dec 2017 at 5:03am


Topic: Random Picker for Access by Crystal
Posted By: Crystal Long
Subject: Random Picker for Access by Crystal
Date Posted: 24 May 2012 at 9:15am
uploads/84/DB_RandomPicker_Crystal_110602__ACCDB_TXT_PNGs.zip - 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 - 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 - 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 - http://www.AccessMVP.com/strive4peace
Free 100-page book that covers essentials in Access

http://www.YouTube.com/LearnAccessByCrystal - 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 ~



Print Page | Close Window