Jump to content
The British Coin Forum - Predecimal.com

SionGilbey

Newmismatist
  • Posts

    344
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by SionGilbey

  1. Hmm... Is there any similar way for Access?

    I can only attach pictures as objects that you have to click on and open in the default program where you use it.

    I'd rather have a mouseover or immidiate view.

    Anyone know how?

    You have an Access table (file) of pictures with an associated unique Coin ID for each picture. You also store that same unique ID against each coin in your main table. Finally, you establish a relationship between the two tables based on Coin ID, and simply set up a picture field that brings in the relevant picture based on the relationship. It sounds more complicated to explain than to set up.

    Oh, and isnt the large file size slowing down the program a RAM issue?

    Yes - the more RAM you have, the less the problem will manifest, but Excel itself probably has an overhead position where it will start to slow down on very large files, but I have absolutely no idea what that size is.

    I've sorted the Access problem out with Colin now so no need to worry.

    Your method sounds interesting though and I'll try it out when I have some time.

    Also, with Access you can store the images outside the database rather than integrating them therefore there isn't any of that problem.

  2. Very cool!

    Watch out for the size of your file though, every 2Mb pic you stick in will increase the file size by 2Mb, and if you've got 2000 coins...

    If you have a modern computer a 2mb pic on each of the 2000 makes only 2GB in files.

    Which is only the size of the smallest flash drive you can get these days.

    Computer hard drives are usually more than 100GB, mine being 240.

    Before the files got corrupted a month ago, I just converted the text in the box to a link to an image of each coin which I could call up when I wanted. That seemed to be simple enough to operate as it was one box, one coin. The above seems a tad complicated.

    I think this is supposed to be quicker and more aesthetically pleasing.

    Also it's more convenient if you are checking all the images of the same year coin for an error you've just read about you can just gently move the mouse down as opposed to opening an unholy amount of windows or tabs.

  3. I think most collectors now start off collecting anything and everything - I certainly did.

    I had best luck in Car Boot Sales (in summer when they have the best turnout, search the internet for your local ones), antiques and charity shops and eBay (If you only have cash you can buy preloaded credit cards in WHSmith for use on the Net).

  4. It's a German made brass Jeton isn't it? I don't quite know the significance of the double headed eagle (apart from the obvious fact that Victoria was related to most other European Royal familes).

    The double headed eagle with the shield and various pieces of treasure is the Russian coat of arms.

    Could it be Russian made?

    I am not knowledgeable about Jetons.

×
×
  • Create New...