ACCESS FEED: Re: [MS_AccessPros] free download -- RandomPicker Updated (pick random record from any table or query)

Kamis, 02 Juni 2011

Re: [MS_AccessPros] free download -- RandomPicker Updated (pick random record from any table or query)

Hi Jim,

Thanks, Jim. You didn't miss anything, I did. I normally save a record before moving to another one ... but this code is behind an unbound form. The Dirty property is only applicable to forms that have data. I have removed the Dirty statement and added a lot more comments. Uploaded a new version :

DB_RandomPicker_Crystal_110602__ACCDB_TXT_PNGs.zip
http://groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/DB_RandomPicker_Crystal_110602__ACCDB_TXT_PNGs.zip

for more information :
http://www.AccessMVP.com/strive4peace/RandomPicker

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Wed, 6/1/11, Jim Wagner wrote:

> Date: Wednesday, June 1, 2011, 1:28 PM
> Crystal,
>
> I did as the directions said, but I get an error 2455 You
> entered an expression
> that has an invalid reference to the property Dirty.
>
> Did I miss something?
>
> Jim Wagner
> ________________________________
>
>
>
>
>
> ________________________________
> From: strive4peace <strive4peace2008>

>
>
> Hi All,
>
> Have you ever wanted to be able to pick a random record?
> Now it is easy! All you need is ONE form: f_RANDOM_PICKER.
> All the necessary
> code is behind the form.
>
> To download the database from MS_Access_Professionals, go
> to
> >> Files >> Crystal >>
> DB_RandomPicker_...
>
> here is a direct link:
> http://groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/DB_RandomPicker_Crystal_110416_630p__ACCDB.zip
>
>
> If you have a database you want to choose a random record
> from:
> 1. import the f_RANDOM_PICKER form
> 2. compile and save database
> 3. open the 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
>
>
> The database file is in 2007 format. If you have a
> lower version of Access, the
> code and more details are on my website:
>
> Random Picker Form
> ... import form into any Access database
> use combobox to choose table or query
> by Crystal
> http://www.AccessMVP.com/strive4peace/RandomPicker
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>