Has anyone written a MS Access Stamp Collector Database?

News items. General trends, new issues, new policies etc. **Whatever** you like. WORLDWIDE. Start a new thread on your question. Please do not discuss ebay in THIS forum as we have a separate and popular Forum for that discussion.

Moderator: Volunteer Moderator Team

Post Reply
User avatar
DaveC1979
Well on the way to 25 post Senior Member
Well on the way to 25 post Senior Member
Posts: 15
Joined: 23 Apr 2020 02:39
Location: Liverpool, UK

Has anyone written a MS Access Stamp Collector Database?

Post by DaveC1979 »

Hello all,

Has anyone actually written an MS Access Database in which to catalogue your collection?

My idea is to have it set by set and to be able to pull a report off the database to show me what my collection would be "worth" according to the likes of Stanley Gibbons etc in the case of loss of the collection for the likes of an insurance claim or general interest?

Regards
David
www.b787register.co.uk - The worlds number one Dreamliner Catalogue!

User avatar
The Pom
I was online for Post Number 4 MILLION!
I was online for Post Number 4 MILLION!
Posts: 12048
Joined: 02 May 2007 08:08
Location: Great Britain

Re: Creating my own MSAccess Database

Post by The Pom »

Stamp cataloguing software has been much discussed over the years.

This Board search for "Access" links to a number of threads that may offer some help.

http://www.stampboards.com/search.php?keywords=Access&terms= ... mit=Search
Always on the lookout for Australian pre decimal First Day Covers.

User avatar
RobRoyH
WINNER! Stampboards Poster Of The Month
WINNER! Stampboards Poster Of The Month
Posts: 8506
Joined: 19 May 2011 13:12
Location: Mansfield, Texas USA
Contact:

Re: Creating my own MSAccess Database

Post by RobRoyH »

I would be happy to send you the template for mine.

I have been using it since 2007 and it currently has over 107,000 records. Included is a defined total value report.

It is set up for singles but you could certainly use it as you describe, or add / delete / change any fields you want.

MS-Access all built by myself, used constantly and modified many times over the years. Send me a board emAil if you want it.
"You say grace before meals. All right. But I say grace… before I dip the pen in the ink."
G. K. Chesterton

User avatar
DaveC1979
Well on the way to 25 post Senior Member
Well on the way to 25 post Senior Member
Posts: 15
Joined: 23 Apr 2020 02:39
Location: Liverpool, UK

Re: Creating my own MSAccess Database

Post by DaveC1979 »

Hi rob, I would be very interested in seeing it

my email is david at b787register.co.uk
www.b787register.co.uk - The worlds number one Dreamliner Catalogue!

User avatar
RobRoyH
WINNER! Stampboards Poster Of The Month
WINNER! Stampboards Poster Of The Month
Posts: 8506
Joined: 19 May 2011 13:12
Location: Mansfield, Texas USA
Contact:

Re: Creating my own MSAccess Database

Post by RobRoyH »

File is sent.
"You say grace before meals. All right. But I say grace… before I dip the pen in the ink."
G. K. Chesterton

User avatar
Catweazle
2500 Stampboards Post - Senior Guru
2500 Stampboards Post - Senior Guru
Posts: 3854
Joined: 15 Nov 2009 21:18
Location: Geelong, Victoria, Australia
Contact:

Re: Creating my own MSAccess Database

Post by Catweazle »

Any chance you could post a screenshot of a blank entry so we can see what they look like?

User avatar
norvic
WINNER! Stampboards Poster Of The Month
WINNER! Stampboards Poster Of The Month
Posts: 22397
Joined: 25 Feb 2008 21:51
Location: Norfolk, England
Contact:

Re: Creating my own MSAccess Database

Post by norvic »

The Pom wrote:Stamp cataloguing software has been much discussed over the years.

This Board search for "Access" links to a number of threads that may offer some help.

http://www.stampboards.com/search.php?keywords=Access&terms= ... mit=Search
Yup, it's good to hear the sound of wheels being reinvented.

HAve to say, though, that quite a lot of the SC software is US based and full of Scott numbers already. So if you are starting from scratch, on looking at GB, you might want to critically examine other offerings.
Ian Billings - Norvic Philatelics - Remember almost everything I picture is available, unless otherwise stated or copied from elsewhere, as I reduce a roomful of 'stuff' - just ask. GB stamps info: https://blog.norphil.co.uk, NPhilatelics on twitter, www norphil.co.uk, shop.norphil.co.uk for our e-commerce site

User avatar
RobRoyH
WINNER! Stampboards Poster Of The Month
WINNER! Stampboards Poster Of The Month
Posts: 8506
Joined: 19 May 2011 13:12
Location: Mansfield, Texas USA
Contact:

Re: Creating my own MSAccess Stamp Collector Database

Post by RobRoyH »

None I have seen or heard of is as customizable as one you design yourself.

I have more than a dozen catalogs in use.

I only use it in Table view so it could be mistaken for a spreadsheet... I have posted snips here and there in my stamp den thread of pieces of it.

I don’t even remember what the entry form looks like, I am sure that is what you want to see. As I have added many fields since inception I am sure it is ugly as I have never laid it out for use.

I will post some images though once I get back into the stamp den late tonight.
"You say grace before meals. All right. But I say grace… before I dip the pen in the ink."
G. K. Chesterton

User avatar
tikithindi
GOLD Star Super Posting Stampboarder!
GOLD Star Super Posting Stampboarder!
Posts: 315
Joined: 10 Mar 2011 12:48
Location: USA

Re: Creating my own MSAccess Stamp Collector Database

Post by tikithindi »

Hi,

Years ago I had started Making relational Database in MS Access, at that time I was using MS Office 2007 Ultimate. Was able to correlate with MS Excel sheet too. Though in the beginning there were many spelling mistakes. But was usable at least for my self. (as somebody's Comment forgot his name now) .

If I find Proto will Post it.

Cheers
tikithindi
( Dr. Khalak M U)

User avatar
Anita
GOLD Star Super Posting Stampboarder!
GOLD Star Super Posting Stampboarder!
Posts: 265
Joined: 06 Jul 2019 11:09
Location: Brisbane, Australia

Re: Creating my own MSAccess Stamp Collector Database

Post by Anita »

I too set up an Access database to manage my collection. I don't enter stamp details through a customised form. Instead, I just enter them in table mode. The columns in my database are as follows:
  • * ACSC number (specialised Australian catalogue from 1913 to 2001)
    * Stanley Gibbons number (for all other stamps)
    * Scott number (I rarely use this)
    * Country
    * Category (which Aust ACSC book eg roos/KGV/Decimals 1/etc or Modern Aust decimal, or Worldwide for all other countries)
    * Album (which album the stamp is housed in. For my thematic collections, this column lists the theme that houses the stamp)
    * Year issued
    * Watermark (I mostly use this for Aust roos and KGVs and leave it blank for most other stamps)
    * Perforation (I mostly leave this blank and only use it to differentiate similar stamps in my Aust collection)
    * Die (for Aust roos/KGVs)
    * Plate (for Aust roo flaws)
    * Denomination (eg 5c, $5, etc)
    * Description (brief general description from the catalogue)
    * Perforation or overprint
    * Postmark (for interest, but also to help me to find a stamp, eg if I have 3 of the same stamp and I give one away, I can tell which one to take out of the database)
    * Flaw/variety
    * Acquired from
    * Acquired date
    * Acquired price (I acquire most stamps in a bundle rather than individually, eg a box from here or an old album from there. I put the Acquired from and date on all the stamps in the lot, but just put the price on the first item I log in the database. That way, the price is not duplicated in the database, so my database should in theory show the total value I paid for my stamps)
    * Notes (eg selvage attached, damaged stamp, top left stamp in a block of 4, etc)
Sounds like a lot, but I never fill in all the columns for any one stamp. Most stamps are pretty quick to add in now that I'm familiar with my system.

I don't put catalogue values in my database, because they are only valid until the next catalogue comes out and I have way too many stamps in the database to go through and revise the values.
Started collecting Commonwealth Australian stamps. Then Australian kangaroo flaws. Then Australian pre-decimal flaws. Have now got my eye on worldwide birds, animals, gardening/backyards and engraved beauties. Oh, and maybe volcanoes. Who knows what tomorrow will bring :mrgreen:

User avatar
lightningstamp
AQUA Star Stampboards Enthusiast
AQUA Star Stampboards Enthusiast
Posts: 28
Joined: 04 Feb 2016 18:53
Location: Manitoba, Canada

Re: Creating my own MSAccess Stamp Collector Database

Post by lightningstamp »

RobRoy,

I would also be interested in a copy of your database template if you have a chance to send it. Thanks for your time!

gottalovestorms (at) gmail [dot] com

Matt

User avatar
RobRoyH
WINNER! Stampboards Poster Of The Month
WINNER! Stampboards Poster Of The Month
Posts: 8506
Joined: 19 May 2011 13:12
Location: Mansfield, Texas USA
Contact:

Re: Creating my own MSAccess Stamp Collector Database

Post by RobRoyH »

Here is an image of the entry form that I must have created back in 2007. It doesn't even have fields for the Catalog Prefix and Suffix numbers and none of the radio boxes for topicals.

Image

These things are great for handing over a database to a clerk for data entry, but all the tabbing around would drive me crazy. Far easier to cut and paste rows and edit fields as needed in table view.

Matt - email sent
"You say grace before meals. All right. But I say grace… before I dip the pen in the ink."
G. K. Chesterton

User avatar
ecwk
Senior Member Advanced Posting Guru
Senior Member Advanced Posting Guru
Posts: 209
Joined: 23 Aug 2010 18:54
Location: Hong Kong, China

Re: Creating my own MSAccess Stamp Collector Database

Post by ecwk »

Hello RobRoy,

May I have your file, too? Thank you

Eric

User avatar
phos45
Black Ninja Star! Board Posting Addict.
Black Ninja Star! Board Posting Addict.
Posts: 86
Joined: 22 Aug 2010 04:07
Location: CBI, Canada
Contact:

Re: Creating my own MSAccess Stamp Collector Database

Post by phos45 »

STAMPCAT is superb ! ... regretably licences are no longer available

https://www.fnprg.com/index.html

I have used it for a decade ...

User avatar
RobRoyH
WINNER! Stampboards Poster Of The Month
WINNER! Stampboards Poster Of The Month
Posts: 8506
Joined: 19 May 2011 13:12
Location: Mansfield, Texas USA
Contact:

Re: Creating my own MSAccess Stamp Collector Database

Post by RobRoyH »

ecwk wrote:Hello RobRoy,

May I have your file, too? Thank you

Eric
Email sent... twice as at first I forgot the attachment. :lol:

It would be interesting to hear if anyone has found these useful and what changes they made for their own applications.
"You say grace before meals. All right. But I say grace… before I dip the pen in the ink."
G. K. Chesterton

User avatar
Elkra
RUBY Gemstone Stampboard BARONET!
RUBY Gemstone Stampboard BARONET!
Posts: 17661
Joined: 26 Mar 2016 09:43
Location: Waterford, Ireland

Re: Has anyone written a MS Access Stamp Collector Database?

Post by Elkra »

Hello Dave

If your initial question had been about stamps of any Country: You'd have been flailed on here. Luckily the Mods here are mostly Australian so miss things :D

As your question was presented it leaves a number of questions to be answered;
1) Has anyone actually written an MS Access Database in which to catalogue your collection?
Yes

2)My idea is to have it set by set and to be able to pull a report off the database ....
How?

The above are from you're from your initial post.

I do not mean to be untoward Dave, but it might help if you mentioned your level with MS Access.

Do you understand Tables, Queries, Forms?

Relationships ?

Hugely important issues there and way above the normal Excel Flat File concept.

As I say, I do not mean to be untoward.

Use the Board Email option if you would like to discuss.

Keep Safe
John
John
Interests: Ireland - Luxembourg - Christmas/Rugby/Racehorses on Stamps.

User avatar
DaveC1979
Well on the way to 25 post Senior Member
Well on the way to 25 post Senior Member
Posts: 15
Joined: 23 Apr 2020 02:39
Location: Liverpool, UK

Re: Has anyone written a MS Access Stamp Collector Database?

Post by DaveC1979 »

.
Hi Rob,

Could you resend the email for me if you still have it? asenna2015 at yahoo.co.uk?

I do not mean to be untoward Dave, but it might help if you mentioned your level with MS Access.

Do you understand Tables, Queries, Forms?

My level with Access would be considered medium/high level, having written several database systems in the past
.
www.b787register.co.uk - The worlds number one Dreamliner Catalogue!

Post Reply

Return to “Discuss stamps - and *anything* at ALL happening with stamps”

Who is online

Users browsing this forum: Number-O-Ne and 8 guests