Form to display motipal images on a form

[sheepboy68122]

Ok, it’s been awhile since I played with access.
Here is what I am trying to do. Please point me in the right direction

DB Info:
-I have a MySQL DB that I am pulling data from using MSAccess 2007(linked tables).
-The DB has a table that has a list of Image names that correlate to a known folder on the server.

Can do:
-I am able to pull the data from the DB and display the image from the Drive on the server in a single form with the image updating when you click to the next record.

Plan:
-I would like to be able to display the images in a Grid form….like in a 4 x 3 grid(or larger)
-Also would like to display in a Continuous form—not a priority and the answer for the Grid may answer this one as well.

Thanks for your help.

 

[Rokhi]

Try putting a number of images on your form in the pattern you want, with empty 'picture' properties, then use custom navigation buttons to move thru the recordset, picking up the image addresses from the required number of records each move, and populating the images' 'picture' properties.
e.g. The movenext button would iterate thru x number of records to populate all images on the form. Movelast would move to the end minus the number of images required and then iterate thru from there.
Or you could use a matrix of multiple image address fields per record and use the native navigation buttons

An alternative could be to use a bound OLE control. After creating the Bound Object frame bound to an OLE object field in your table, run the form and while in form view, choose insert/object and insert the image using an appropriate package as listed in the insert object dialogue. This would achieve the continuous form goal. You can choose linked or embedded mode.
You could still have multiple images on a page by using multiple image fields per record.

 

[sheepboy68122]

ok, that helped
thanks, i went with the move next botton. so now a 2nd questions....

is there a way to loop through a list of Image boxes to change a value?

example:
loop x < xyz
image1.property=blabla (---the image1 needs to be updated as well....image1, image2, image3....)
x=x+1
endloop