Question Linking Jpeg Images to access: Selecting 2 from multiple images stored on network

[smig]

yes you are crazy LOL

I had no time to look in Chris' demo, and I guess it is a code to read the image names. so I'll try to go into the interface I think you should build guessing you will have to look at each couple of images, and make sure they are in the correct order.

as you said in some situations you will have more then 2 images for an item, so don't forget to have fields for these extra images in your table, based on your guess for the maximium number of images per item.

let's say for the example you have a maximum number of 5 images per an item.
create a form with a place for 5 images, and these buttons:
Next - this will be also be used to save the record
swap - to swap between the two images
add - to load new image into slots 3-5
remove - to remove an image from a slot

hwo this will work:
every next.click will move to the next record and read the next 2 images and show them on the form.
for most cases you will have only to use this button. only looking briefley at the images, saving and moving to the next item. this should be very fast.
add.click will add the next image (and increase the counter by 1) to the next free slot.
remove.click will remove the last image (and decrease the counter by 1) from the last used slot.
swap.click will swap between the images in the table and on the form.


one warning:
Access is not very good in saving resources and they are leaking out rather fast. you might have to restart your machine couple of times a day

 

[ChrisO]

G’day Stacey.

This one’s a little better.

New attachment.

Regards,
Chris.

 

[ChrisO]

G’day Stacey.

Well, I sent it to a friend for testing because he’s good a breaking things and…he broke it.

New attachment.

Regards,
Chris.

 

[geekygal]

Good morning!

This is looking great! Images are loading correctly! I'm off to work today so won't be around here for another 8 or 9 hours.... But I'll check in when I get home!

Stacey

 

[ChrisO]

G’day Stacey.

Version 5 is attached.

Regards,
Chris.

 

[geekygal]

Good morning. Well I am good at breaking things too. I got the following error:

Error in Module: frmInventory
Procedure ScanForFiles()
----------------
Error Number 3315
Error Description: Field 'tblInventory.FilePrefix' cannot be a zero-length string


Thanks!

Stacey

 

[ChrisO]

G’day Stacey.

Most likely the files in that folder do not have a prefix and are probably names like 1234.JPG.

Please post a typical file name from that folder.

Then try this new version, version 6, and if that works I’ll remove the need for a file prefix in version 7.

Regards,
Chris.

 

[geekygal]

Whoops, sorry about that. I was testing it out quickly this morning and was running it on a different computer than I have been using (and was lazy and did not want to wait for this computer to turn on). Sorry about that.

This one works great. Attachment with my results.

Thanks!

Stacey

 

[geekygal]

I just went and ran the same program on the computer that I used this morning (when I thought that I broke it). You were right, the images on this computer are stored in a different format. They are in a four digit number only, no words or underscores. This folder I used started with an even inventory # not an odd number.

Thanks again!

Stacey

 

[ChrisO]

OK, but I think I’ll remove the file prefix because it doesn’t seem to do much, except to take up space, and I’m trying to conserve space because there will be 500,000 entries.

If you find any other ‘screwy’ file name, please let me know.

Regards,
Chris.

 

[ChrisO]

On second thoughts, there will only be around 1000 entries so I’ll leave the file prefix as it is because it better describes the actual file name.
I’ll still cleanup version 6 and post it as version 7.

 

[jdraw]

G’day Stacey.

Most likely the files in that folder do not have a prefix and are probably names like 1234.JPG.

Please post a typical file name from that folder.

Then try this new version, version 6, and if that works I’ll remove the need for a file prefix in version 7.

Regards,
Chris.

Hey Chris,
I'm still following this.
I tried your version 5 and had no issues. All of my photos have a DSCF prefix.

I just tried your version 6 and am having issues. Now I realize you are doing a front and back image. I have tried using the same Folders as withversion5 and only get a few images loaded. Out of 12 jpgs, only 2 get loaded???
I have also had an issue where I name an Inventory, Select a Folder, and when I click Load Inventory it says "No Inventory Selected"???
I also tried loading a folder that I used in earlier versions, including 5, the folder has 55 jpgs. All seems to work fine except there are no images displayed???

I realize your working on Steacy's issue, but having a database of photo info that you could tag with different parameters, then search is of interest to me.

Also, are there other fields that Steacy wants to search, record etc for final use? I could see things like location, season, general content (scenery, people, buildings, landmarks etc), year/date, event....

 

[ChrisO]

OK Stacey, version 7 is attached.

Please let me know of any problems.

Regards,
Chris.

 

[geekygal]

Hey Chris,
I
Also, are there other fields that Steacy wants to search, record etc for final use? I could see things like location, season, general content (scenery, people, buildings, landmarks etc), year/date, event....

I do have several different fields that I will be associating to each image. The images are only a small part of the form that I will be using. I already have the access tables set up to record various card grading characteristics, location, category, published year, publisher, post mark information, in addition to the information written on the card.

Off to test the latest version..

Stacey

 

[geekygal]

Just tested it out. Looks Great!

Stacey

 

[Simon_MT]

I know I'm a late starter to this discussion however the best method for handling images is the Inventory Record becomes part of the the Image file name. The advantage is that you look at your images directory and you can easily identify the images.

Even if you have more than one image the distinguishing feature of the image is its inventory number.

I have used over 16,500 images on a multi-user multi-site environment and image identification was the key.

Simon

 

[geekygal]

I know I'm a late starter to this discussion however the best method for handling images is the Inventory Record becomes part of the the Image file name. The advantage is that you look at your images directory and you can easily identify the images.

Even if you have more than one image the distinguishing feature of the image is its inventory number.

I have used over 16,500 images on a multi-user multi-site environment and image identification was the key.

Simon

The only issue that i could see is that most of my inventory items will have two images.

Stacey

 

[ChrisO]

Jdraw.

I’m doing it his way because of the quantity of images Stacey will have and because of the consistency of her image names.

Her images are being scanned in from one machine that will produce consistent names. I know some of the file name formats but probably not all at this stage, it’s still work in progress.

I don’t want to store a file path to all the images because 1 file path could easily be 60 characters and if Unicode then 120 bytes. That would mean 120 Mb of image paths and the vast majority of that would be totally redundant. So I’m attempting to calculate the image path and file name to save space. But that calculation requires very consistent file names which Stacey has…or will have.

So this database is not a general purpose database for storing paths and file names.
It’s a special database built around the quantity and consistency of the files Stacy has.

If you are in need of a general purpose database, for storing image information, then you should be able to find one on the www and modify it for your special needs.

Regards,
Chris.

 

[geekygal]

Chris -

This project is for the cards that have yet to be scanned. So they can be named anything that I want at this point. They can be named/organized however will help this program work most efficiently. Although we have scanned in 100,000 cards so far, those are inventory items that we needed to count and document for IRS purposes, but we realistically will not touch for many years and may end up selling in big lots.

Just wanted to make sure you were aware that I am flexible in this

Stacey

 

[ChrisO]

Stacey.

You might like to confirm that all images in the same directory will have the same file prefix and only differ is their serial number which will always be 4 digits preceding the .JPG.

So, as it stands, an image file name can be Blah Blah BlahXXXX.JPG with or without spaces in the Blah Blah Blah and all images in the same directory will have the same Blah Blah Blah prefix.

Regards,
Chris.