!!

Not Yet Registered?

Welcome to the N Gauge Forum!  We've currently hidden most of the threads due to the vast number of guests contributing in slowing the speed of the forum down.  Please register and login to see the many thousands of posts about our great hobby.  After registering and gaining 10 posts you will be able to sell and buy items on our N'porium.

If you have any problems registering, then please check your spam filter before emailing us.  


Thanks for reading,
The NGF Staff.

Author Topic: Stock database?  (Read 12918 times)

0 Members and 1 Guest are viewing this topic.

Offline MikeDunn

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 21391
  • Posts: 3098
    • Awards
Re: Stock database?
« Reply #60 on: July 04, 2013, 06:03:05 PM »
Hmmm, do you work @ my place  :hmmm:

Offline digger61

  • Trade Count: (0)
  • Full Member
  • ***
  • Posts: 43
  • Country: gb
    • Awards
Re: Stock database?
« Reply #61 on: September 03, 2013, 08:41:29 PM »
The best option would be MS access if you have it. I use this all the time In my job so if you wanted could create one for you

Offline MikeDunn

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 21391
  • Posts: 3098
    • Awards
Re: Stock database?
« Reply #62 on: September 03, 2013, 09:25:42 PM »
best [...] MS access
Now there are a couple of words you don't see together very often  >:D

Offline CarriageShed

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 24383
  • Posts: 2677
  • Country: ee
  • Gender: Male
  • Beechinged 1981-2013
    • Ebay
    • Twitter
    • The History Files
    • Awards
Re: Stock database?
« Reply #63 on: September 03, 2013, 11:24:22 PM »
best [...] MS access
Now there are a couple of words you don't see together very often  >:D

:smiley-laughing:

I've been avoiding it like the plague for years...

Offline EtchedPixels

  • Advertiser
  • Trade Count: (+44)
  • Full Member
  • ***
  • N Gauge Society Number: 16353
  • 2mm Association Number: 4412
  • Posts: 8332
  • Country: wales
  • Gender: Male
    • Ebay
    • Google+
    • Twitter
    • YouTube
    • Etched Pixels
    • Awards
Re: Stock database?
« Reply #64 on: September 04, 2013, 10:36:17 AM »
MS Access, how quaint.

It also assumes Windows, which seems a bit like short term planning right now!
"Knowledge has no value or use for the solitary owner: to be enjoyed it must be communicated" -- Charles Pratt, 1st Earl Camden

Offline CarriageShed

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 24383
  • Posts: 2677
  • Country: ee
  • Gender: Male
  • Beechinged 1981-2013
    • Ebay
    • Twitter
    • The History Files
    • Awards
Re: Stock database?
« Reply #65 on: September 04, 2013, 11:13:12 AM »
With apologies to Digger61, of course, who made a perfectly reasonable and helpful offer of assistance and is probably feeling a little miffed at all this laughter. You should be ashamed of yourselves.  ::) Sorry, Digger  :-[

Offline MikeDunn

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 21391
  • Posts: 3098
    • Awards
Re: Stock database?
« Reply #66 on: September 04, 2013, 12:52:25 PM »
Without meaning any insult to Digger, my professional approach to Access (note : not hobbyist approach) is "dragged kicking and screaming" ... the number of times I have found a client group with an Access "app" they depend on and is totally unsupported by us  is without count - and of course when it goes wrong, it's all our fault that a) it broke, and b) we won't touch it with a barge-pole !  That's not to mention what happens when an Office upgrade comes along !

And why do they have such a mission-critical app in Access ?  Because the group won't pay for the work to be done properly (ie into a proper SQL database (not necessarily MS SQL  :no:), with proper security, access controls etc etc etc and that gets backed up securely) and "Fred over there knows how to do it & rattled it off in an evening free - you guys wanted lots of money and weeks !" - right ... he wrote it, he can support it !

As an initial development environment or for a small-scale item (such as is suggested here), yeah it's OK.  But not for live production in the types of organisations I find it in !

Offline daveg

  • Trade Count: (+5)
  • Full Member
  • ***
  • N Gauge Society Number: 22509
  • Posts: 5181
  • Country: gb
  • Gender: Male
    • Awards
Re: Stock database?
« Reply #67 on: September 04, 2013, 01:04:08 PM »
One of the guys here (I think) was developing quite a neat-looking database from the development posts he'd made but that seems to have gone quiet.

I'm have MS Orri-face 2003 and my lists are on several xls pages. Not clever but it keeps a (sort of) organised list. I don't really need anything more, well, not at this stage.

Access is OK for basic stuff but there again I am a simple soul. I remember 8" floppy drives and when you had to partition a 32MB HD. Ahh, those were the days!  :worried:

Dave G


Offline CarriageShed

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 24383
  • Posts: 2677
  • Country: ee
  • Gender: Male
  • Beechinged 1981-2013
    • Ebay
    • Twitter
    • The History Files
    • Awards
Re: Stock database?
« Reply #68 on: September 04, 2013, 05:18:43 PM »
One of the guys here (I think) was developing quite a neat-looking database from the development posts he'd made but that seems to have gone quiet.

Do you mean DCCDave's efforts, shown on the first page of this thread? I was wondering about that, too. It looked very impressive in the screenshots.

Offline daveg

  • Trade Count: (+5)
  • Full Member
  • ***
  • N Gauge Society Number: 22509
  • Posts: 5181
  • Country: gb
  • Gender: Male
    • Awards
Re: Stock database?
« Reply #69 on: September 04, 2013, 08:31:27 PM »
One of the guys here (I think) was developing quite a neat-looking database from the development posts he'd made but that seems to have gone quiet.

Do you mean DCCDave's efforts, shown on the first page of this thread? I was wondering about that, too. It looked very impressive in the screenshots.

Yes! I was daft enough not to look back to the start.  :dunce:

Wonder if he'll pick up on the new posts?

Dave G

Offline digger61

  • Trade Count: (0)
  • Full Member
  • ***
  • Posts: 43
  • Country: gb
    • Awards
Re: Stock database?
« Reply #70 on: September 04, 2013, 08:56:12 PM »
One of the guys here (I think) was developing quite a neat-looking database from the development posts he'd made but that seems to have gone quiet.

Do you mean DCCDave's efforts, shown on the first page of this thread? I was wondering about that, too. It looked very impressive in the screenshots.

Yes! I was daft enough not to look back to the start.  :dunce:

Wonder if he'll pick up on the new posts?

Dave G

Wish I never bothered I'll just get my coat

Offline DCCDave

  • Trade Count: (+5)
  • Full Member
  • ***
  • Posts: 987
  • Country: gb
  • Gender: Male
  • N gauge transition era DCC
    • Facebook
    • Instagram
    • Google+
    • MySpace
    • PhotoBucket
    • Twitter
    • Skype
    • Awards
Re: Stock database?
« Reply #71 on: September 04, 2013, 09:00:11 PM »
One of the guys here (I think) was developing quite a neat-looking database from the development posts he'd made but that seems to have gone quiet.

Do you mean DCCDave's efforts, shown on the first page of this thread? I was wondering about that, too. It looked very impressive in the screenshots.

Yes! I was daft enough not to look back to the start.  :dunce:

Wonder if he'll pick up on the new posts?

Dave G

Yep I'm still working on it - I did say it would take a while as I'm busy on  other things like earning a crust and building a model railway :)

I'm currently doing a lot of background (that is non-UI) development so not much to see right now.

Cheers
Dave
« Last Edit: September 04, 2013, 09:10:50 PM by DCCDave »

Offline CarriageShed

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 24383
  • Posts: 2677
  • Country: ee
  • Gender: Male
  • Beechinged 1981-2013
    • Ebay
    • Twitter
    • The History Files
    • Awards
Re: Stock database?
« Reply #72 on: September 04, 2013, 11:43:55 PM »
Glad to know that it's still bubbling under, despite you getting all distracted with non-important stuff  ;)

Offline linuxyeti

  • Trade Count: (0)
  • Full Member
  • ***
  • Posts: 91
  • Country: gb
    • Awards
Re: Stock database?
« Reply #73 on: December 19, 2013, 09:01:49 PM »
Hi All

Sorry it's been a while, work just got in the way. Hopefully have time now over christmas to finish the one I was working on.

Cheers

Tony

Offline DCCDave

  • Trade Count: (+5)
  • Full Member
  • ***
  • Posts: 987
  • Country: gb
  • Gender: Male
  • N gauge transition era DCC
    • Facebook
    • Instagram
    • Google+
    • MySpace
    • PhotoBucket
    • Twitter
    • Skype
    • Awards
Re: Stock database?
« Reply #74 on: December 29, 2013, 11:51:06 PM »
Guys and Gals,

Just an update to let you know I'm working on this again. I've done a lot of work on the back end, ensuring that multiple inventories can be held (my stock, my son's stock, my mate's etc.), and that all of the 'reference' data can be applied as software updates (so for example, when a new manufacturer like DJModels comes along I can issue an update with their product range).

I've started rouging out some of the UI, here are a couple of screen shots of the work in progress. The whole UI will be skin able so that you can use the colors of you favorite railway company.





Cheers
Dave


 

Please Support Us!
September Goal: £60.00
Due Date: Sep 30
Total Receipts: £80.00
Above Goal: £20.00
Site Currency: GBP
133% 
September Donations

SimplePortal 2.3.5 © 2008-2012, SimplePortal