By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,368 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

any ideas?

P: n/a
I need to create a db, my idea is to create a combobox where the user
would select an item, ie (style of wine, - there would be about 10
different types) when selected I would some how use the random
function to select a picture (.jpg) and display it. The tblpictures
has an id as well as a link to the directory with the pictures. Has
anyone none anything similar to this?
Sep 14 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
>use the random function to select a picture

You mean selecting a random picture or
bringing the related picture to the combo selection ?
Sep 15 '08 #2

P: n/a
On Sep 15, 2:53*pm, "rum...@hotmail.com" <rum...@hotmail.comwrote:
use the random function to select a picture

You mean selecting a random picture or
bringing the related picture to the combo selection ?
using a random function to select a picture - the picture has an
autonumber id on it, just not sure how to use the random function;
I've done some reading as to what other have done w/the function and
it seems like they are searching for the top % or #; I would like to
code for select 3 random autonumber. Coding to be done from a combo /
list box
Sep 16 '08 #3

P: n/a
Look at the video on:

http://www.bluemoosetech.com/microso...osoft%20Access

John

<te*********@gmail.comschreef in bericht
news:c0**********************************@a70g2000 hsh.googlegroups.com...
On Sep 15, 2:53 pm, "rum...@hotmail.com" <rum...@hotmail.comwrote:
use the random function to select a picture

You mean selecting a random picture or
bringing the related picture to the combo selection ?
using a random function to select a picture - the picture has an
autonumber id on it, just not sure how to use the random function;
I've done some reading as to what other have done w/the function and
it seems like they are searching for the top % or #; I would like to
code for select 3 random autonumber. Coding to be done from a combo /
list box
Sep 16 '08 #4

P: n/a
Haven't done such work but
why not creating a query and bind it to your image on your combo's
change event ?
Pls check below how clearly Nikos Yannacopoulos explains if you have
already not done so.

http://groups.google.com/group/micro...+random+record

rgds

Sep 16 '08 #5

P: n/a
<ru****@hotmail.comschreef in bericht
news:78**********************************@y38g2000 hsy.googlegroups.com...
Haven't done such work but
why not creating a query and bind it to your image on your combo's
change event ?
Pls check below how clearly Nikos Yannacopoulos explains if you have
already not done so.

http://groups.google.com/group/micro...+random+record
This is not really random. Every time you start the mdb the first query will
result in the same number. See the video.

John
Sep 16 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.