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: 28 Mar 2024 at 9:58am Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com
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 ~
|
|