Thumbnail as OLE objects in database

[johanhjalmarsso]

Solution to a thumbnail viewer

Hi!

I want to display 8 thumbnail images at a time per form of records that matched a search critera in a form. But it seems like a form is suppose only to have one record at a time? I want to have a "next 8 thumbs"-button so it gets easy to browse the pictures.

I'm very thankful if you could help me with this! Please give me some advice.

Thanks!

Best regards
Johan

 

[aqif]

Use subform?

How about if you use subform?

I presume that images are bound to records. Create Search text box in parent form and then display search results with their images in subform.

Regards
Aqif

 

[johanhjalmarsso]

That could work! A thumbnail is bound to a record, yes.

I now have a query (qrySearch) that reads the parent form and get all the search criterias from form combos. But how can I assign that search result to some sort of array? And then pick them out one by one by a index number.

Something like this:
Dim arr As Array
arr = Query(qrySearch)
subform1=arr(i)
subform2=arr(i+1)
subform3=arr(i+2)

Hope you guys understand what i mean...


Thanks a lot anyway!

 

[johanhjalmarsso]

How about if you use subform?

I presume that images are bound to records. Create Search text box in parent form and then display search results with their images in subform.

Regards
Aqif

The images is just a text-field with the filename in my database for the records.

I should use OLEBound-object to display the images?

I now use a subform that got the "continuous"-property, that works
for everything but the images. How should I do to show the images too?

Please respond. Thanks!

Johan

 

[johanhjalmarsso]

Hi!

Do you guys think the database will get small in size if i have like 200 records and each one of them have a 4 kb thumbnail as OLE object?

I know that putting big images in OLE objects gets very big but a small thumbnail is ok and doesn't increase the size of the .mdb so much? (130x98 pixels)