don't have time to provide detailed help but can provide the following
to find your search in tekst your sql would be
Code:
SELECT *
FROM VossNow
WHERE tekst like "'*" & [Enter Search Term] & "*'"
you will then need to loop through this list to check image sizes.
This will be a second query using a public function to determine image size
see this link for how this might be done
https://stackoverflow.com/questions/32465445/microsoft-access-vba-determining-image-dimensions/32465724
assuming you called your function 'imageSize' and the first query is called qry1 it would look like this
Code:
SELECT *
FROM qry1
WHERE imageSize(1200,800,Filnamn)=true
you would do this on the filtered list because it could take some time so searching perhaps 50 images will be a lot quicker than searching 120k
This query would be the recordsource to your form - you would need to change [Enter Search Term] in the first query to reference the search control on your form.
the imageSize function would look something like
Code:
function imageSize(iwidth as integer, iheight as integer, iName as string) as boolean
dim fWidth as integer
dim fHeight as integer
'get imagesize per the link I provided, not clear what is exactly returned but you will probably need to break it down into width and height to populate fWidth and fHeight.
Code:
imageSize=fwidth<=iWidth and fHeight<=iHeight
end function
edit for some reason the editor has added code tags halfway through, treat both the above boxes as a single box
and then show all the pictures that match the search ?
your form would be continuous with an image control which would be populated with the path and filename
Sorry don't have time to go into more detail, but should get you started
Other things to consider on your search - is the language consistent or do you have to replace accented characters with alternatives?