I have a database with 1 table, the table is used to hold jpeg images. Each of the images has a category ie Cars, Trains, motobike etc etc. I have a query with a search criteia that asks me to choose a category ie[cars].
Now what I would like to do is display all the cars images on my form side by side. Does anyone know how I can do this or even if Access2k will let you do this?
I would appreciate any feedback whatsoever.
Just a thought but I have noticed the 'Kodak Image Thumbnail Control' from the Insert activex control menu, has anyone ever used this? it looks very similar to the Image control in VB that could be just what I am looking for???.
Well i build some thing like your wish, but used the filescollection, i think you can alter it easily for your sql selection.
here is the piece of the code :
Dim nI As Long
Dim nAantFiles As Long
Dim nFotTel As Long
On Error Resume Next
nFotTel = 0
nI = -1
Dim fs, f, f1, fc, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFolder(psMainPath & psFolder)
Set fc = f.files
nAantFiles = f.files.Count - 1
Me!TbAantBest = nAantFiles ' show the number of found files
For Each f1 In fc
nI = nI + 1
If nI = pWhereAmI Then
nFotTel = nFotTel + 1 ' Counter for the max number of image fields on the form
pWhereAmI = pWhereAmI + 1
Me("imgPic" & Trim(Str(nFotTel))).Picture = psMainPath & psFolder & f1.Name
Me("tbPicName" & Trim(Str(nFotTel))) = f1.Name
Me("tbPicNr" & Trim(Str(nFotTel))) = pWhereAmI - 1
If nFotTel = 16 Then ' max imagefields on the form = 16
Me!cmdVolgende.Caption = "Next row"
If nAantFiles + 1 = pWhereAmI Then
pWhereAmI = 1
For nI = nFotTel + 1 To 16 ' clear the not used imagefields on the form
Me("imgPic" & Trim(Str(nI))).Picture = ""
Me("tbPicName" & Trim(Str(nI))) = ""
Me("tbPicNr" & Trim(Str(nI))) = ""
Me!cmdVolgende.Caption = "Start"
Hi E, I have looked through the code but i cant make sense of it? what do the references imgPic, tbPicName and tbPicNr refer to? What kind of image control would I place on my form and what name would I give it? questions, questions??
I'm really struggling with this one, I just cant grasp your concept.
I appreciate the work you have done but my brain is acting a bit thick!
Any chance you could post me the form and code that you have wrote so that I will be able to understand it more???