Skip to main content

@Patrick1544 posted:

I use Yard Office model train inventory.  It’s a free download.  No expiration or time limits.  Fully functional.  If you like it you can pay them or not. Your choice.  It’s very detailed.  I think it’s great.  Try it .  Nothing to lose, it’s free.  
http://www.musicmixradio.com/yardoffice/

Downloaded YardOffice.  Paid the $27, but have not received a Registration Code.  

@hokie71 posted:

... Trainz is attractive since it populates information with pictures even....

My only concern is that this is on Trainz' cloud service and they have access to everything you put on it.  In the past there were complaints that Trainz was using pictures and data from individual's inventories for their own marketing.  They may have stopped that by now, or this may not be an issue with you, but read the privacy notice.

Last edited by CAPPilot
@Gerhardt posted:

Hi Guys,

Trainz Auctions offers a free online inventory program that ties into their database, so you get pictures, description and even auctioned value range.  I like that you can download it to Excel so you always have a backup.  I've bought stuff from them and you can automatically add those items to you inventory.  It's functional for my needs. I hope that helps,

G

Unless they changed, I found Trainz Auctions limiting in that you can not sort your collection.

Over the years my train collection has grown enough that I needed some way of knowing what I have.

I've tried a variety of inventory programs. Unfortunately no one had all the info I needed so I finally created a LibreOffice (free alternative to Office/Excel) spreadsheet.

As others have pointed out, almost impossible to create reports from a spreadsheet so I finally bit the bullet and created a database using Microsoft Access. Unfortunately I've forgotten a lot of what I leaned back in the early 2000s regarding how to make an Access database compact so I don't have many calculated fields. Plus not sure how to populate one field with info based upon some you enter into another field.

Regardless, here's the fields in each record:

Seq # (unique record number; can not be duplicated; this allows me to sort MY way)
Cat No
Unq ID (if I have more than one item with the same Cat # this differentiates each item)
MA (I check this field when I enter the item into the Access datase; I'm slowly moving all my data from my spreadsheet to Access)
Description
Color(s)
Series / Set
Manufacturer
Scale
Group (my own designation)
Road Name Code
Road Name Description
Road Logo
Reporting Mark
Category
Type
Min Curve
Length
Built
Status
Config
Years Cataloged
MSRP
Purch Date
Sold by
Purch Price
S & H / Tax
Calc. Total
% MSRP Purch Price
Item Cond
Best Value
% MSRP Best Value
CY Greenberg Value
% MSRP CY Greenburg Value
MITrains Value Date
MITrains Value Price
% MSRP MITrains Value Price
Qty
Box Type
Box Cond
Images (up to 8)
Notes

Excel's filtering and reporting can get sketchy after a while as it's designed to crunch numbers rather than running queries.

I put together a Microsoft Access database over 15 years ago as a teaching tool for my students (bet they got sick of trains). It was primarily to show the flexibility of the product. One of these days I'll put some code behind it instead of macros (Visual Basic wasn't part of the course curriculum as it was an Access class for the business department and not a programming class). Will probably dig it out when I retire and have some time.

Main Menu:

Main_Menu

Sample Record:

Sample_Record

 

 

Attachments

Images (2)
  • Main_Menu
  • Sample_Record

Add Reply

Post

OGR Publishing, Inc., 1310 Eastside Centre Ct, Suite 6, Mountain Home, AR 72653
800-980-OGRR (6477)
www.ogaugerr.com

×
×
×
×
Link copied to your clipboard.
×
×