Form with image related to a combobox selection

[Richard1980]

Hello, I need your help on this item.
I have a table (tblCountries) with world countries and their respective flags. The tblCountries.Flag is an attachment field type. I have another table (tblAirports) where there is a combobox for selecting airport country. I would like to display in the form (frmAirports) the flag for the country selected by the combobox. The flag shown must obviously come from the tblCountries.Flag field.
How do that?
Thanks, bye

Riccardo

 

[John Big Booty]

Perhaps the attached sample will give you some pointers.

Be sure to copy the DB and the folder "Flags to the same location.

 

[Richard1980]

Hello John,
thanks for your reply. It is an interesting sample, but I am looking for something better. However, it can be the starting point for something more advanced... Bye.

 

[vbaInet]

Can you explain to us what you mean by "better and more advanced" in this context?

 

[Richard1980]

Yes, for sure. In the John's sample there is for every Japan region/prefecture its own flag name (XYZ.png) written in the main table using a text type field. Then the query takes every name to build the local machine address where are stored all flags.
Now, due to a large number of countries (close to 200) in my DB, it is quite expensive in terms of time writing the name of all flags in a table.
Any suggestions from you, Access gurus?

 

[vbaInet]

So how do you intend mapping to the country's flag if you don't have a table containing this map?

 

[Richard1980]

I don't know...

 

[vbaInet]

Well with these kind of things there's got to be some Admin tasks involved. You will need to create a mapping table or if you have the images in your db already and each image is identifiable with a meaningful name then it can be done.

 

[John Big Booty]

I don't know...

Perhaps the Data entry fairy

Seriously though, you probably only need the Country name, and so long as the country flag file name matches the country name in in your table and they all have a consistent file extension you can simply append that in the code that is building the file path.

 

[John Big Booty]

...alternately you could use an append query to create the record with the file extension on it. There are so many ways to reduce the amount of KP work you need to do if you sit and look for a solution rather than becoming fixated on the problem

 

[vbaInet]

Perhaps the Data entry fairy

Or perhaps a tool that can scan images and identify which country's flag it belongs to.

 

[Richard1980]

Ok, I have been able to store the file name for every country flag. Now I have a table with country names, flags and filenames. So, next step is to use John's sample to get the image for the airport country. All flags are (for now) stored within the database, not in an external folder (as for John's one) but let's try and see what happens. Thanks for your suggestions. Bye.

Riccardo

 

[vbaInet]

Whichever way you choose to do it, have a look at the following link too:

http://office.microsoft.com/en-us/access-help/store-images-in-a-database-HP005280225.aspx

So yes you can still display the image if it's saved in the db but what John advised is the way to go.