Batch linking pictures to Access

[Mondou]

I have about 5,000 Jpeg pictures that I am trying to link to an Access
database to create a catalog.
My database Table (tblPrice) contains STYLE# (Primary Key), DESCRIPTION
and PRICE.
My picture folder contains the pictures named after their STYLE#.
Instead of linking each picture one by one, I would like to importor
link the images by batch.

Since I am a newby with Access...but learning fast, could anyone show
me how to do this step by step.

I have read that I need to create a textfile containing the names of
the pictures (eg. 4270.jpg, 4271.jpg, ...). I have completed this and
the text file is in the PictureFolder. Since my picture folder will be
updated on a regular basis, I think that I am better off linking the
images than embedding them.

I thought of importing the text file into a new table (tblPictures)
with the following fields: STYLE# (Primary key) & PICTURE NAME (
STYLE#.jpg).

From here, I'm confused; How will the program know where to get the

picture files? ...how will Access know the path?

Secondly, could anyone tell me what VBA codes to use for this task?...

Thanks for any help

 

[Allen Browne]

Set the Picture property of the Image control in the Current event of the
form. Example (and workaround for a bug):
http://www.mvps.org/access/bugs/bugs0044.htm

Use a table to hold the ImagePath. If you set up a table like the one
outlined in this link:
http://allenbrowne.com/ser-18.html
you can create a record where the Variable is (say:
ImageFolder
and you can then read the folder with:
DLookup("[Value], "tblSys", "[Variable] = 'ImageFolder'")

 

[Mondou]

Thanks for your assistance Allen.

However, in order to workaround for a bug, they suggest to disable the
navigation buttons.

How then can we navigate through records without always having to go
through the Go To Menu ?

Thanks

 

[Allen Browne]

The nav buttons do not have to be disabled any longer than it takes to load
the image.

Stephen Lebans reported that there was a registry fix for this problem. I
can't recall the details, but I'm sure you will find it if you run a search
of the microsoft.public.access groups for his replies on this issue at
groups.google.com.

 

[Stephen Lebans]

Hi Allen,
the bug described in the article you pointed the OP to is a directly related
to a bug in the "Loading Image" dialog code. If you remove the dialog via
the registry modification then the original bug disappears completely. In
other words there is no longer any need to turn off the Navigation buttons.
Here is a recent post of mine on this subject.

The one thing you must do is turn of the Loading Image dialog. If you don't,
and quickly scroll through the records in Form view, or page quickly in
Print Preview, you run the risk of crashing Access. Use the Registry mod at
the Access MVP site:


Additionally, two issues in regards to the Registry modification pointed to
here http://www.mvps.org/access/api/api0038.htm


1) The Registry key MUST be "No" NOT "no" or "NO"


2) On systems with XP or on systems with more than one user account,
you must add/modify the key in both HKEY_CURRENT_USER and
HKEY_LOCAL_MACHINE.


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.