Imaging Seminar - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Imaging Seminar

Tim Schmidt

5 years ago

Before I purchase your Access Imagining Seminar, could you tell me does it show you how to randomly rotate a picture in a form. That would be in record number 1 show picture joe.jpg and next time you bring up record 1 show bill.jpg, randomly displaying a different picture when you bring up a record or add a record.

Thanks,
Tim Schmidt

Adam Schwanz @Reply

5 years ago

I'm not sure what's shown in the access imaging seminar, I'm not sure if there's another way to do this but I would do it with the Rnd function and an if statement in the on current event. (may be beyond your current understanding, if so I'll let Rick chime in other ideas :P)

This is the Rnd Function, dimmed as a varaiable
Dim X As Integer
X = Int ((MaxNumber - LowestNumber + 1) * LowestNumber + 0)

Then you can say If X = 1 Then set the picture to this file location, if X = 2 then set the picture to this file location etc.

	Richard Rost @Reply 5 years ago
The seminar doesn't cover it, but it's certainly possible. Give me some context. Why do you want to do this? It might make a cool add-on for my Images TechHelp video.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View