What's new
British Ordnance Collectors Network

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Recording

A

archmoco

Well-Known Member
I was wonder if any member use a computer based programme to record and make notes of their cartridge collections? To date i've used Excel to record headstamps but would like something a bit better, or at least some type of spreadsheet to add photos and notes into? Any one got any ideas?

Regards
Archmoco
 
I wrote a Access database years ago that I still use today, even though it is written in Access 2000. It is very simple but allows for photos to be included and has a search function by calibre, manufacturer and load. It is a little biased towards British military as the headstamp entry allows a Broad Arrow to be inserted and all the British mark numbers and L numbers are preloaded but it would not need much work to turn it into a generic database.

I also use the French headstamp dawing program which is excellent and costs 100 IIRC.

Not sure how to save a page in Access and then load it here as an example so cannot show you.

Regards
tonyE
 
You might consider looking at some of the more basic "asset management" software around. (There are some freeware and shareware examples). These will allow you record your collection with text and graphics/images and provide a catalogue or stock list if required.
 
records

I use an excell spread sheet but dont take it to the full extent possible as I think (and maybe a excel wizzard will confirm) that you can store references to files ie photos in cells that when clicked go straight to that photo. 2pr
 
2pounder said:
I use an excell spread sheet but dont take it to the full extent possible as I think (and maybe a excel wizzard will confirm) that you can store references to files ie photos in cells that when clicked go straight to that photo. 2pr
Click to expand...

I have toyed with Excel in the past and think that this is probably the way forward. I am in the process of teaching myself how to use it so will update if I have any joy with the picture thumbs.
 
I have used Hyperlinking to click and jump instanty to linked files. You will find your Hyperlink Icon under Insert at the top of your Excell spreed sheet. Create a folder for your photos and place that within another folder where your excell spread sheet is stored.

Hope that is of help,

Cheers,
BOUGAINVILLE


2pounder said:
I use an excell spread sheet but dont take it to the full extent possible as I think (and maybe a excel wizzard will confirm) that you can store references to files ie photos in cells that when clicked go straight to that photo. 2pr
Click to expand...
 
Thanks guys, I've started an Excel spreadsheet and i'm going to play around with it over the next week or two and see how it turns out, i'll also try and hyper link photos of the headstamps and rounds, after all they say a picture is worth a thousand words!
 
TonyE said:
I wrote a Access database years ago that I still use today, even though it is written in Access 2000. It is very simple but allows for photos to be included and has a search function by calibre, manufacturer and load. It is a little biased towards British military as the headstamp entry allows a Broad Arrow to be inserted and all the British mark numbers and L numbers are preloaded but it would not need much work to turn it into a generic database.

I also use the French headstamp dawing program which is excellent and costs 100 IIRC.

Not sure how to save a page in Access and then load it here as an example so cannot show you.

Regards
tonyE
Click to expand...

First open your program and get it to display what you would like to show. You can then press and hold the 'Ctl' button and press the 'Print Screen' button (this is normally next to 'F12'). This loads the screen data into the system clipboard. Next you need to open a picture editor, create a new picture and paste the clipboard contents into it (use 'Paste' from the 'Edit' menu). You can now save this picture and upload it.
 
Many thanks Harvey, that is great!

So now I know how to do it, here is a screen image of my Access program.

Regards
TonyE
 

Attachments

  • Image2.jpg
    Image2.jpg
    78.4 KB · Views: 32
Now that is exactly what i'm looking for.... I must check my computers at home (or see what we have in work), Access 2000 that's a Microsoft Office Programme?
 
Last edited:
Access

Yes, Access comes with Microsoft Office Professional, but it is now much improved and I think the latest version is Access 2010, the previous one being Access 2007. My old version will still run on it though.

As I said, I wrote mine for my British military collection so the drop-down menus are all set up for that with British ordnance factories, British mark and "L" numbers etc. The various Firearms Act Sections (Sec.5 (1a)b etc.) are also there.

The entries can also be viewed on a "browse" screen (below) and the button on the far right on each line expands that entry into the full page of info for that round.

Regards
TonyE
 

Attachments

  • Image1.jpg
    Image1.jpg
    103.1 KB · Views: 22
Hi Tony, that program looks really good is there one available like that anywhere to download, i have access 2003 and can list all my ammo but need to include a pic but can't work that out yet.
Cheers
Andy
 
Another handy program

Another program worth having is FS Capture. This is screen capture software, so whatever is on the screen can be captured and saved.

If you download the portable version, it can be run from a USB stick without installing it on any computer.

Pete
 
Andysarmoury said:
Hi Tony, that program looks really good is there one available like that anywhere to download, i have access 2003 and can list all my ammo but need to include a pic but can't work that out yet.
Cheers
Andy
Click to expand...

Not as far as I know, I wrote that about eight or nine years ago and have used it ever since. It does all I need, and I wrote a search facility so that I can find individual items quickly by calibre, manufacturer or load, or any combination of those.

I was writing quite a lot of Access applications back then but am a bit rusty now. Also, Access has changed quite a lot in the newer versions.

Regards
TonyE
 
And a good job you made of it, it looks good i will have to keep at it i wont let it beat me dam computers why can't they make things simpler:tinysmile_shy_t:
Andy
 
You must log in or register to reply here.
Top