Loading ...
Sorry, an error occurred while loading the content.
 

Re: [woodandbrass] How to keep track of your collection

Expand Messages
  • Larry S. Pierce
    As far as entering the data, it would. But as far as displaying, ordering, and using the data, it would not. Each row in Excell is very much the same as a
    Message 1 of 11 , Feb 12, 2013
      As far as entering the data, it would. But as far as displaying,
      ordering, and using the data, it would not. Each row in Excell is very
      much the same as a data record in Access. In fact, you can translate
      back and forth between Excell and Access in that way.

      Here are the things that I use Access for that Excell cannot do:

      -display a photo or photos of the object while looking at its data
      -look at only Anthony (or any other manufacturer) cameras
      -view stereocards on the computer in stereo
      -for each collection item, by entering a short acronym, to have the
      entire company name and address and other company data instantly
      associated with it, because company data is stored in another table
      (e.g., all I enter is "ao" and the computer knows that it is American
      Optical Co., Scovill Mfg. Co. proprietors, address, founding date,
      ending date, etc.)
      -(related to the last one) always have a company name (camera model
      name, any other repetitively entered data) be the same each time, rather
      than how you thought to enter it that day (Excell's autofill feature
      helps with this)
      -produce canned lists, e.g., "cameras not photographed yet", or "cameras
      made prior to 1900", or "Scovill cameras made prior to 1900", or
      "cameras without a lens (or an original case)" (to look for potential
      matches if I am buying a lens or a camera-less case).

      Currently, my collection database only links two tables: a "collection
      items" table to a "manufacturer" table. I was going to link in a
      "models" table to "collection items" which would bring in the beginning
      and ending dates when each model was made, but it would only be
      worthwhile if I had lots of the same model (like a Leica collection
      maybe) so I abandoned it.

      If you have an Excell spread sheet that contains your data, import it
      into Access. Then choose <new form> and choose the form wizard to make
      a form from the resulting table. Done. The rest is making it look like
      you want (or adding in the Manufacturer's table for repetitive entries).



      On 2/12/2013 4:10 AM, John Rushton wrote:
      > Hi Larry, Charles and All,
      >
      > Would Microsoft Excel be equally good for making a camera inventory? This
      > would get around another learning curve for MS Access.
      >
      > Best Wishes,
      > John
      >
      > ________________
      >
      > -----Original Message-----
      > From: woodandbrass@yahoogroups.com
      > <mailto:woodandbrass%40yahoogroups.com>
      > [mailto:woodandbrass@yahoogroups.com
      > <mailto:woodandbrass%40yahoogroups.com>] On
      > Behalf Of Larry S. Pierce
      > Sent: 12 February 2013 03:43
      > To: woodandbrass@yahoogroups.com <mailto:woodandbrass%40yahoogroups.com>
      > Subject: Re: [woodandbrass] How to keep track of your collection [1
      > Attachment]
      >
      > I also use a custom MSAccess database. It is not very difficult to learn
      > enough to make up a database and form. Attached is my screenshot.
      > Cameras, catalogs, other accessories get tracked. The other half of the
      > story is having tie-on tags or markings on each piece so that items that
      > have a history together stay forever linked. For instance, the camera
      > pictured in my example would have six pieces marked: the case, the camera
      > body, the lensboard, the plateholder, the clip-off back, and the ground
      > glass frame that pulls out of the clip-off back.
      >
      > On 2/10/2013 9:48 AM, Rob Niederman wrote:
      > > I use a database program such as Microsoft Access. It's a bit more
      > > work to set up, but you can do data sorts & searches, price value
      > > totals, and so forth. Here is a screenshot of my entry template for
      > > cameras (that's all I track); but you can also add links to pictures
      > > and adapt it for anything acquired. - Rob
      > >
      > > *From:*J. Charles [mailto:steamer369@...
      > <mailto:steamer369%40yahoo.com>]
      > > *Sent:* Saturday, February 09, 2013 11:37 PM
      > > *To:* woodandbrass@yahoogroups.com
      > <mailto:woodandbrass%40yahoogroups.com>
      > > *Subject:* [woodandbrass] How to keep track of your collection
      > >
      > > Hi All,
      > > As my collection keeps growing, I need help finding an efficient way
      > > of keeping track of my purchases, pictures, references before I forget
      > > or mix it all!
      > >
      > > How are you guys doing it? Is there a good software out there for wood
      > > and brass addict? Any suggestions welcome.
      > >
      > > Charles C
      > > Phoenix, AZ
      > >
      > >
      >
      > ------------------------------------
      >
      > Yahoo! Groups Links
      >
      > -----
      > No virus found in this message.
      > Checked by AVG - www.avg.com
      > Version: 2013.0.2897 / Virus Database: 2639/6098 - Release Date: 02/11/13
      >
      >
    • J. Charles Chapuis
      Thank you all for your replies. I am looking for something like Larry s screen shot, definitively with a picture and if possible 3 to 4 pics? I guess, I ll
      Message 2 of 11 , Feb 12, 2013
        Thank you all for your replies. I am looking for something like Larry's screen shot, definitively with a picture and if possible 3 to 4 pics?
        I guess, I'll have to learn Access, but I meanwhile I'll better use Excel to keep the information at one place. 
        Charles


        From: Larry S. Pierce <mathew_brady@...>
        To: woodandbrass@yahoogroups.com
        Sent: Tuesday, February 12, 2013 11:04 AM
        Subject: Re: [woodandbrass] How to keep track of your collection

        As far as entering the data, it would.  But as far as displaying,
        ordering, and using the data, it would not.  Each row in Excell is very
        much the same as a data record in Access.  In fact, you can translate
        back and forth between Excell and Access in that way.

        Here are the things that I use Access for that Excell cannot do:

        -display a photo or photos of the object while looking at its data
        -look at only Anthony (or any other manufacturer) cameras
        -view stereocards on the computer in stereo
        -for each collection item, by entering a short acronym, to have the
        entire company name and address and other company data instantly
        associated with it, because company data is stored in another table
        (e.g., all I enter is "ao" and the computer knows that it is American
        Optical Co., Scovill Mfg. Co. proprietors, address, founding date,
        ending date, etc.)
        -(related to the last one) always have a company name (camera model
        name, any other repetitively entered data) be the same each time, rather
        than how you thought to enter it that day (Excell's autofill feature
        helps with this)
        -produce canned lists, e.g., "cameras not photographed yet", or "cameras
        made prior to 1900", or "Scovill cameras made prior to 1900", or
        "cameras without a lens (or an original case)" (to look for potential
        matches if I am buying a lens or a camera-less case).

        Currently, my collection database only links two tables: a "collection
        items" table to a "manufacturer" table.  I was going to link in a
        "models" table to "collection items" which would bring in the beginning
        and ending dates when each model was made, but it would only be
        worthwhile if I had lots of the same model (like a Leica collection
        maybe) so I abandoned it.

        If you have an Excell spread sheet that contains your data, import it
        into Access.  Then choose <new form> and choose the form wizard to make
        a form from the resulting table.  Done.  The rest is making it look like
        you want (or adding in the Manufacturer's table for repetitive entries).



        On 2/12/2013 4:10 AM, John Rushton wrote:
        > Hi Larry, Charles and All,
        >
        > Would Microsoft Excel be equally good for making a camera inventory? This
        > would get around another learning curve for MS Access.
        >
        > Best Wishes,
        > John
        >
        > ________________
        >
        > -----Original Message-----
        > From: woodandbrass@yahoogroups.com
        > <mailto:woodandbrass%40yahoogroups.com>
        > [mailto:woodandbrass@yahoogroups.com
        > <mailto:woodandbrass%40yahoogroups.com>] On
        > Behalf Of Larry S. Pierce
        > Sent: 12 February 2013 03:43
        > To: woodandbrass@yahoogroups.com <mailto:woodandbrass%40yahoogroups.com>
        > Subject: Re: [woodandbrass] How to keep track of your collection [1
        > Attachment]
        >
        > I also use a custom MSAccess database. It is not very difficult to learn
        > enough to make up a database and form. Attached is my screenshot.
        > Cameras, catalogs, other accessories get tracked. The other half of the
        > story is having tie-on tags or markings on each piece so that items that
        > have a history together stay forever linked. For instance, the camera
        > pictured in my example would have six pieces marked: the case, the camera
        > body, the lensboard, the plateholder, the clip-off back, and the ground
        > glass frame that pulls out of the clip-off back.
        >
        > On 2/10/2013 9:48 AM, Rob Niederman wrote:
        >  > I use a database program such as Microsoft Access. It's a bit more
        >  > work to set up, but you can do data sorts & searches, price value
        >  > totals, and so forth. Here is a screenshot of my entry template for
        >  > cameras (that's all I track); but you can also add links to pictures
        >  > and adapt it for anything acquired. - Rob
        >  >
        >  > *From:*J. Charles [mailto:steamer369@...
        > <mailto:steamer369%40yahoo.com>]
        >  > *Sent:* Saturday, February 09, 2013 11:37 PM
        >  > *To:* woodandbrass@yahoogroups.com
        > <mailto:woodandbrass%40yahoogroups.com>
        >  > *Subject:* [woodandbrass] How to keep track of your collection
        >  >
        >  > Hi All,
        >  > As my collection keeps growing, I need help finding an efficient way
        >  > of keeping track of my purchases, pictures, references before I forget
        >  > or mix it all!
        >  >
        >  > How are you guys doing it? Is there a good software out there for wood
        >  > and brass addict? Any suggestions welcome.
        >  >
        >  > Charles C
        >  > Phoenix, AZ
        >  >
        >  >
        >
        > ------------------------------------
        >
        > Yahoo! Groups Links
        >
        > -----
        > No virus found in this message.
        > Checked by AVG - www.avg.com
        > Version: 2013.0.2897 / Virus Database: 2639/6098 - Release Date: 02/11/13
        >
        >


        ------------------------------------

        Yahoo! Groups Links

        <*> To visit your group on the web, go to:
            http://groups.yahoo.com/group/woodandbrass/

        <*> Your email settings:
            Individual Email | Traditional

        <*> To change settings online go to:
            http://groups.yahoo.com/group/woodandbrass/join
            (Yahoo! ID required)

        <*> To change settings via email:
            woodandbrass-digest@yahoogroups.com
            woodandbrass-fullfeatured@yahoogroups.com

        <*> To unsubscribe from this group, send an email to:
            woodandbrass-unsubscribe@yahoogroups.com

        <*> Your use of Yahoo! Groups is subject to:
            http://docs.yahoo.com/info/terms/



      • Marcel Safier
        Only months ago, we noted the passing of Fred Friedman of New Jersey. Now I had the sad duty to let group members know of the passing of Eric Evans on
        Message 3 of 11 , Oct 29, 2016
          Only months ago, we noted the passing of Fred Friedman of New Jersey. Now I had the sad duty to let group members know of the passing of Eric Evans on Wednesday, 26 October. Eric lived in Sheffield, Yorkshire and assembled one of the largest collection of branded British wood and brass cameras, totaling over 300.  Eric continued to derive great pleasure from new finds, especially if it was a maker he didn't have an example by. He was always a gracious host and happy to let you handle and photograph his treasures as he pointed out salient features. I visited him 4 times in the last few years, every time my travels took me the UK. Darrin Hill wrote a nice bio on the Facebook Wood and Brass group that I copy here: "Eric was someone who wouldn't perhaps be particularly popular in America, he lead his life based on very firmly held socialist principles. He always put others first. He was a true gentleman and it was rare for anyone to feel the full force of his formidable intellect, instead he would gently encourage in the right direction. He was a lifelong Socialist and worked tirelessly to promote the common good. He started life the son of a Yorkshire miner who died early from an industrial disease and was the first in our family to receive higher education. He was an athlete when younger and briefly ( almost accidentally ) played professional rugby league) .after a career educating kids he became a journalist using his photographic skills to illustrate road test reports on motor caravans and spent the last 30 years or so of his leisure time restoring and collecting old cameras. Apart from his abiding belief in the inherent goodness of human nature his other great quality as a fine person was his unremitting loyalty to his family and to his wife Maureen who he adored absolutely until her death some years ago. He was possessed of an astonishing memory and intellect and it is fair to say the camera world has lost an undoubted expert on early English wood and brass."

          Vale my friend.

          Cheers!

          Marcel
          --
          Marcel Safier
          Brisbane, Australia

        • Michael Pritchard
          So sorry to hear of Eric s passing. Dr Michael Pritchard www.mpritchard.com
          Message 4 of 11 , Oct 30, 2016

            So sorry to hear of Eric’s passing.

             

            Dr Michael Pritchard

            www.mpritchard.com

            www.britishphotohistory.ning.com

             

             

             

            From: woodandbrass@yahoogroups.com [mailto:woodandbrass@yahoogroups.com]
            Sent: 30 October 2016 06:44
            To: woodandbrass@yahoogroups.com
            Subject: [woodandbrass] Eric Evans - RIP

             

             

            Only months ago, we noted the passing of Fred Friedman of New Jersey. Now I had the sad duty to let group members know of the passing of Eric Evans on Wednesday, 26 October. Eric lived in Sheffield, Yorkshire and assembled one of the largest collection of branded British wood and brass cameras, totaling over 300.  Eric continued to derive great pleasure from new finds, especially if it was a maker he didn't have an example by. He was always a gracious host and happy to let you handle and photograph his treasures as he pointed out salient features. I visited him 4 times in the last few years, every time my travels took me the UK. Darrin Hill wrote a nice bio on the Facebook Wood and Brass group that I copy here: "Eric was someone who wouldn't perhaps be particularly popular in America, he lead his life based on very firmly held socialist principles. He always put others first. He was a true gentleman and it was rare for anyone to feel the full force of his formidable intellect, instead he would gently encourage in the right direction. He was a lifelong Socialist and worked tirelessly to promote the common good. He started life the son of a Yorkshire miner who died early from an industrial disease and was the first in our family to receive higher education. He was an athlete when younger and briefly ( almost accidentally ) played professional rugby league) .after a career educating kids he became a journalist using his photographic skills to illustrate road test reports on motor caravans and spent the last 30 years or so of his leisure time restoring and collecting old cameras. Apart from his abiding belief in the inherent goodness of human nature his other great quality as a fine person was his unremitting loyalty to his family and to his wife Maureen who he adored absolutely until her death some years ago. He was possessed of an astonishing memory and intellect and it is fair to say the camera world has lost an undoubted expert on early English wood and brass."

            Vale my friend.

            Cheers!

            Marcel
            --
            Marcel Safier
            Brisbane, Australia


             


            This email has been scanned by Netintelligence
            http://www.netintelligence.com/email


          Your message has been successfully submitted and would be delivered to recipients shortly.