Images

[Guest]

I've read some of the responses here regarding how to get images into your
database, or more specifically, how to refer to them.

My problem is a little different. The referrals so far all require that you
enter the filename of the picture for each record.

I am downloading a zip file that contains a comma delimted database and
seperate jpg files. The record data in the database is keyed off of a
non-recurring number. For example 1234567. The pictures are named
1234567.jpg and so on. So each picture can be associated with each data
record.

I want to be able to import he data file and leave the pictures where they
are. I prefer not to have to go through the database and put in the
reference path to each picture for each record. Is there a way to bring up
the pictures without entering the path name on each record? Can the path
name be created in a query and assigned off of the record index?

This is not a static database. These records are imported in quantity, a
report operation is performed, and then the records would be discarded.
Thanks.

 

[Arvin Meyer]

There is a free demo database on my website, that does exactly what you
want. You can probably just import most of it into your application:

http://www.datastrat.com/Download/Picture2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Arvin,

Thanks for the response. The Picture2K mdb should be helpful in getting
where I want to be. I'm a bit of a novice with Access so there are parts of
your code that just sort of go over my head. I can work through that line by
line and probably learn a few new things.

I am downloading two pieces of information from a real estate server. The
first is the csv file containing all the data. It is sorted on a number that
matches the file name (without extension) of the assoicated picture. The
pictures are downloaded as separate files in the same zip file. I extract
the files and then import the csv file to a table. That gets all the data
in. I was having trouble getting pictures to show up by relating them to the
appririate record.

Thanks again.