I am just getting into slide shooting and after getting quite a few rolls piled up, it is apparent that I will need a filing system. I like to project but I want to keep the slides in archival plastic sheets which I already have. I am also creating a database in MS Access for keeping track of the slides. My question is regarding assigning unique numbers to each slide. How do all of you APUGers do this with your slides and/or negatives? I do not want to sort my slides by subject, so that is out of the question. I see no reason not to just store by the roll...I just want to consider all the factors before committing to a scheme.
My current thought is:
S1-0001-01
S for slide (or N for neg), 1 for format (1=35mm, 2=4x5, etc), 0001 as a roll ID, 01 for frame number.
1) are you planning on limiting yourself to just 9999 rolls - 4 digits might do that;
2) dates are very useful;
3) while you may not want to sort by subject, you may appreciate having the ability to record some subject information in the database.
I would strongly recommend that you use a system that provides date and subject information noted on or with the slide in a way that insures that, if you are the person who has the slide, you will at least have that information without recourse to any other source.
I will have to agree that dates are a good thing to add. I do sort by subject for the most part. Just makes it easier to find. However, I shoot a good deal of slides and I follow a rule of ruthlessly editing. So out of 36 exposures I might only have 1/2 that I am willing to file as keepers so that really makes my sorting and storage a lot easier. Negatives is another issue but I still don't file all of them. Once you start to get a large amount of keepers in your files having some subject info will help.
__________________
"There is something about the mystery
of what is on a roll of film that keeps
me shooting, none of that digital
instant gratification for me."
I agree that a date will be a good thing to add. I still do not wish to file by subject; it does not really suit my shooting style. Someday I may want to do that, but now it would be more of a hassle than it's worth. I will record detailed subject information, film information, etc. in the database. Keep the suggestions coming!
Thanks,
Nick
Sponsored Ad. (Subscribers to APUG
have the option to remove this ad.)
Nick, I have maybe 20,000 Kodachromes from the past 55 years filed in your system without the indicator for type and format. A catalog briefly describing each roll lets me find any particular slide if it's still in the right order. Computerizing the catalog would speed searching up. When I stopped shooting slides the month and year were lab printed on the slide mount.
Yes, slides are still stamped with the month and date. It is true that the ID number given to each slide really doesn't need to contain any information about the slide except what's necessary to find it.
__________________ Kodachrome
They give us those nice bright colors
They give us the greens of summers
Makes you think all the world's a sunny day, oh yeah.
-Paul Simon
I do this with Filemaker Pro (much easier to use, but you already have Access). I have hundreds of records, and several books of negs, all B&W, 3 formats.
The thing to remember is that since it is a database, you can search at any time by any attribute (field), so it doesn't matter how they are organized in physical books, since you can sort and find any way you want in the dbase.
You just have to be sure to have enough searching fields, as suggested by others in the thread.
I start out with one record being a roll of film, then as individual frames emerge as important images, those frames become their own record, copying the first (roll) record, and adding the frame number, etc.
I would do at least date, type of film, subject (specific, like rock, sister Jane, etc.) and general (like nature, family, etc).
I have development info (very specific) and even printing "recipes", including burn and dodge info.
It seems like a lot of work, but it's much faster than looking for negs. I also have a check box for stuff that needs to be printed, so I can do a quick search for these before a darkroom session.
I do this with Filemaker Pro (much easier to use, but you already have Access). I have hundreds of records, and several books of negs, all B&W, 3 formats.
The thing to remember is that since it is a database, you can search at any time by any attribute (field), so it doesn't matter how they are organized in physical books, since you can sort and find any way you want in the dbase.
You just have to be sure to have enough searching fields, as suggested by others in the thread.
I start out with one record being a roll of film, then as individual frames emerge as important images, those frames become their own record, copying the first (roll) record, and adding the frame number, etc.
I would do at least date, type of film, subject (specific, like rock, sister Jane, etc.) and general (like nature, family, etc).
I have development info (very specific) and even printing "recipes", including burn and dodge info.
It seems like a lot of work, but it's much faster than looking for negs. I also have a check box for stuff that needs to be printed, so I can do a quick search for these before a darkroom session.
Thanks for sharing your experience. Access isn't the easiest program to use for this but I work with dbases daily so it's no biggie.
Surely every photog on here must have a system...at least I hope so! Keep the suggestions coming. :-)
In this modern world DBs can contain non-textural records as well. As I scan my every film/dia the thumbnails are an excelent item to put it into the DB. Gives you pictorial feedback immediately. (I really don't know Access is capable storing these pictures... there are DBs who can acomodate).
Hans.
Slide Filing/Numbering 
- 4 digits might do that;
Linear Mode
