Help with Images on Continuous Form

[pattrickcolin]

I have a continuous Form displaying stamp images.


The stamp images are stored outside of the database.
This works well, using the Form Query [imagepath]: "C:\Users\User\Documents\sync\colins Stamp Images" & [2 CountryID] & "" & [4a Prefix] & [4b Number] & [4c Suffix] & ".jpg"

Q how can I list all the Stamps that have no images, e.g. listed within the database but have no image.

I am a self taught beginner and realise that a VBA command (which I know very little about) may work. Something like Path=DIR([imagepath]).

How do I set up command on a Continuous Form showing [path] of records with images and blank for records with no images.

[orange]

see this link for more info

[ranman256]

I don't think you can. The picture must be loaded into the form image control via code,loadPicture.
this works just fine for a single record form, but there's no event to run it for all records in a continuous form.

[orange]

Haven't tried this but conceptually--

if you have stamps and a link to the external storage where an image is available, and you have that working.
Could you have a default image (even No Image Exists) for those stamps with no "real" image? I found this quickly online.



I downloaded his sample database in the article. Then added a record for the record where no real image exists. Added NotAvailable.jpg

[pattrickcolin]

Used suggestion https://www.experts-exchange.com/art...ous-forms.html from 'orange' moderator. Without using code I can see individual images on my Continuous Form.
There is approx 1000 records associated with a single country and 831 images. This leaves 169 records with blank record. I need to produce a list of these blank records.

[orange]

Select * from tblImages
where isNull(imagePath)

[pattrickcolin]

Please help as I am self taught and know very little about VBA

I have added a box (called ISNULL) to my Continuous Form
Added this

Private Sub isnull_Enter()
Select * from tblImages
where isnull(imagepath)
End Sub

and nothing comes up on Continuous Form for records with or without images

[orange]

The sql I provided in the previous post was a general approach to
Selecting all the records in your table that did NOT have an image.

It was in response to your

This leaves 169 records with blank record. I need to produce a list of these blank records.

It is NOT vba, and is not something you need to build vba or procedure for.

[pattrickcolin]

The sql I provided in the previous post was a general approach to
Selecting all the records in your table that did NOT have an image.

It was in response to your


It is NOT vba, and is not something you need to build vba or procedure for.

It is how do I select all records in my table that did NOT have an image, is the question I am trying to resolve.
I can see visually that there are no images. But how do I code this? So I can Print it out?

[orange]

What is the table in your database that stores Image info?
What are the fields in that table?

[pattrickcolin]

What is the table in your database that stores Image info?
What are the fields in that table?

I have 279,000 images stored in folders.
The images are NOT part of the Database.
I create an [imagepath] to these images and then these are displayed, as a Continuous form
The imagepath is "C:\Users\User\Documents\sync\colins Stamp Images" & [2 CountryID] & "" & [4a Prefix] & [4b Number] & [4c Suffix] & ".jpg"
The [2 CountryID] represents the folder where it will find the stamp. There are over 1,000 Folders
The [4a Prefix] + [4b Number] + [4b Suffix] represents the file name of the Image.
So using a ‘Query Form’ I make up this [imagepath]
In the instances that there are no image for this postage stamp the program runs and displays a BLANK Record. (
I need to list these blank records.
It is how I create this list is my problem.
So can I create a unbound box on the continuous form to show these Blanks?
A suggestion made to me was to use this ‘Unbound Box contents’ equal to a DIR() search to see if a file exists.
It would log the File Name or the default would be a Blank Field.
It is how to convert “C:\Users\User\Documents\sync\colins Stamp Images" & [2 CountryID] & "" & [4a Prefix] & [4b Number] & [4c Suffix] & ".jpg"
into the VBA command DIR(“[Imagepath]”) Any suggestions?

However any suggestions on how to make the list of Blank Images would be welcomed.

[orange]

The images are NOT part of the Database.

Yes I'm aware the images are stored in the file system.
What is the structure/design of your table?
What field identifies a record?
What field holds the ImagePath info?

[pattrickcolin]

I have a table called 'Varieties' which contains 602,000 individual records appertaining to Postage Stamps.
Within this table 'Varieties' I have a number of fields with 4 main fields:-
[2 CountryID] field held as a number
[4a Prefix] field as text string
[4b Number] field held as a number
and [4c Suffix] field as text string
plus other fields for denomination, Description, Year issue, Colour, etc etc etc.

All of the four main fields collectively identify a record.

The [imagePath] is made up (using the above fields) as a Query
e.g.
Imagepath ="C:\Users\User\Documents\sync\colins Stamp Images" & [2 CountryID] & "" & [4a Prefix] & [4b Number] & [4c Suffix] & ".jpg"
My Continuous Form refers to this Query and the image appears on the screen.
So there are 602,000 records all referring to different Postage Stamps from around the world.
There are 279,000 images being held in over 1000 folders which represent the different countries.

Thank you for looking into my problem. Hope this helps.

[orange]

So your table identifies 602,000 records --(stamps).
And you know you have 279,000 images.

How do you know the number of images?
Do you get any of that info from your table? If so, please tell us how.

What I'm trying to find out is how do you know which records have an image, and which records do not have images.

[pattrickcolin]

The image count is just a total count of the number of image files.
Counted with a photographic program
I cannot get this info from the Access Database.
The only way I know which records have an image and which records do not have images, is visually.
I generate the Form Query and either I see an image in Continuous Forms or I don't.