Lampwork Etc.
 
TrueDesign

LE Live Chat

Enter Live Chat

No users in chat


The Flow

Beads of Courage


 

Go Back   Lampwork Etc. > Library > Tips, Techniques, and Questions

Tips, Techniques, and Questions -- Technical questions or tips

Reply
 
Thread Tools
  #1  
Old 2010-12-16, 1:58pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default StashMaster Glass Database

Just a note to start with...

Creating this program was a labour of love for me, I did it because firstly i needed the information and secondly I could see a need in the glass community for a program that would allow us to track the huge piles of glass we seem to collect.
I've distributed it for free as a way of paying back the community for all the help I’ve received, to date 1000s of copies have been downloaded or sent directly by me, over 600 in the first version alone, a lot of people have kindly paid me for the software and I really appreciate that, I didn’t expect or ask to be paid but it helps fund my glass addiction.
But, I’m not inclined to distribute the source files, while the data is free to anybody who wants to go look for it, it took me the best part of a year to collect, sort and "clean" the data, as well as creating the interface that lets you easily utilise it. I’m in the process of creating a paid version with a lot more features and I’d like to be able to sell that outside of LE to the greater glass community.
So I would really appreciate it if you wouldn’t use the info that I’ve provided in the database to… well, do exactly what I’m trying to do, like any tutorial created by your fellow glass bead makers, I’m asking that you don’t reproduce or distribute any of the info that I’ve put together in this free version.

Thank you



So, you ask, what the hell is StashMaster?

StashMaster is a Microsoft Access database application that lets you organise your glass, it evolved from a need to be able to print labels for my glass rods.
  • StashMaster comes pre loaded with every available glass I could find, every manufacturer, colour and Coe
  • It lets you keep track of all your glass - rods, frit, powders, sheet, etc – so you can simply have a list of all the glass you have without listing quantities or weights etc
  • Additionally, it lets you track quantities by any unit of measure you choose and you can mix the UOM, so you can keep glass from one manufacture in pounds, while you keep another by rod or oz or bag etc
  • You can create a list of labels; export the information to a spreadsheet (Excel), using that you can then print labels in any format or label size you choose. (see separate instructions for label printing)
  • You can create and print wish lists to help you place orders with suppliers
  • You can keep track of issues, problems, techniques and experiments via the comments and torch notes sections
  • You can tag any glass with an unlimited number of attributes – i.e. silver, striking, opalino etc. The database already contains more than twenty different attributes but you can create more as you come across new ones.
  • You can upload up to 12 images – these can be anything you choose, pictures downloaded from suppliers, images of your own beads or paddle shots
  • You can add new glass colours as they become available, you can also add new manufacturers, COEs, glass types, attributes, UOM.
  • You can delete colours you don’t use or you’ve duplicated
  • You can export lists to Microsoft Excel of all the information in the database so you can then use the data for costing or other programs
  • Best of all, even if you are totally disorganised like me, you can give the impression that you truly have it all together because goddammit – you have a database!

update - due to overwhelming requests (well at least three people) - i've added a batch tracking feature





StashMaster 1.3 now available to download here


Update

Kathy from CiM has kindly provided me with a full file of JPG images of all the CiM colour paddles.

you can download them here, (go down to post 396) i've divided them into colour groups to reduce the size of the file
__________________
Deb

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- my 17yo sons first novel


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- download, get organised, enjoy

Last edited by PerfectDeb; 2012-10-16 at 3:54pm. Reason: new version
Reply With Quote
  #2  
Old 2010-12-16, 1:59pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

first main question i'm getting is how to set up labels. i'll go into more detail but for starters here is the MS instructions for how to print labels via mail merge

http://support.microsoft.com/kb/294684

when you put a number in the labels field in "Add to or change my Stash" form and save the record, this collects in a table for later use.
when you export to excel it creates a spreadsheet that automatically has multiples based on the numbers you input - you dont need to adjust the label numbers or fiddle with the spreadsheet at all - you may want to add a date field so you can print that on your labels but thats up to you.

create labels as per the link above and use the spreadsheet as your data source when prompted, arrange your labels as you like and print.

when you're finished, make sure you clear the labels by clicking the "Clear Label Print List" button or they will be duplicated the next time
__________________
Deb

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- my 17yo sons first novel


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- download, get organised, enjoy

Last edited by PerfectDeb; 2010-12-16 at 2:56pm.
Reply With Quote
  #3  
Old 2010-12-16, 2:26pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

when you select glass in the "Add to or change my Stash" form, make sure you tick the boxes you want and save. if you want to take glass out you have to do the same thing but untick the boxes. you cant untick the boxes from the "My Glass" list because its just a report
__________________
Deb

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- my 17yo sons first novel


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- download, get organised, enjoy
Reply With Quote
  #4  
Old 2010-12-16, 4:10pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

i really expected more questions...

should i take this as a positive?
__________________
Deb

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- my 17yo sons first novel


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- download, get organised, enjoy
Reply With Quote
  #5  
Old 2010-12-16, 4:29pm
Imaglassgal's Avatar
Imaglassgal Imaglassgal is offline
GlassDocNC
 
Join Date: Aug 12, 2008
Location: Asheboro, NC
Posts: 946
Default

A massive thank you from me!
Reply With Quote
  #6  
Old 2010-12-16, 4:40pm
SELSEY's Avatar
SELSEY SELSEY is offline
Bead Obsessed
 
Join Date: Jul 18, 2005
Location: So. Calif.
Posts: 474
Default

I can't play with it here at work but plan to really dive into it this weekend. It's amazing how much thought and work you put into this to give it to everyone for free! What a generous heart you have.
__________________
Sheryl Kelsey
Selsey Designs


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
Reply With Quote
  #7  
Old 2010-12-16, 4:50pm
PittsGlass's Avatar
PittsGlass PittsGlass is offline
Glass Hive Kiln Tech.
 
Join Date: Jun 23, 2007
Location: Toledo, OR
Posts: 907
Default

Quote:
Originally Posted by PerfectDeb View Post
i'm moving this to here so i can answer questions in one place.

***clarifying again cos three people just emailed me, i'm not taking money for this - download, enjoy, get organised***

you can now download the database from this link

http://www2.lampworketc.com/members/...hMaster1.2.zip

this is the read me file
As an alternate form of thank you, I did ask her to pick a color. She said "always green". If that helps anyone with little gifty ideas
__________________

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


It's not what you look at that matters, it's what you see.
Henry David Thoreau
Reply With Quote
  #8  
Old 2010-12-16, 4:54pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

thanks

every significant thing i own is green - car, iphone, linen...
__________________
Deb

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- my 17yo sons first novel


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- download, get organised, enjoy
Reply With Quote
  #9  
Old 2010-12-16, 5:31pm
Deb's Avatar
Deb Deb is offline
Superkitty
 
Join Date: Jun 10, 2005
Posts: 2,897
Default

Deb, when I open the program, I get this. When I click on the "More Information" link I get nothing. Anyone else get this?
__________________
Deb
Reply With Quote
  #10  
Old 2010-12-16, 5:33pm
KJJames's Avatar
KJJames KJJames is offline
Karen James
 
Join Date: Mar 22, 2006
Location: Rhode Island
Posts: 599
Default

Deb, I have MS Access 2007. Do you know if anyone is running Access 2010 Runtime & Access 2007 on the same machine without a problem? I know previous versions have had issues so I thought I would ask since I know you did some testing.

Thanks
__________________

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
Karen
To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

Cricket, Mini CC, Devilbiss MC84 Oxy and NG
Reply With Quote
  #11  
Old 2010-12-16, 5:37pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

Quote:
Originally Posted by Deb View Post
Deb, when I open the program, I get this. When I click on the "More Information" link I get nothing. Anyone else get this?
this is because the database has macros in it, its just a warning. you have to enable the macros or it wont work
__________________
Deb

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- my 17yo sons first novel


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- download, get organised, enjoy
Reply With Quote
  #12  
Old 2010-12-16, 5:39pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

Quote:
Originally Posted by KJJames View Post
Deb, I have MS Access 2007. Do you know if anyone is running Access 2010 Runtime & Access 2007 on the same machine without a problem? I know previous versions have had issues so I thought I would ask since I know you did some testing.

Thanks
i'm not sure, i tried to find some info about just that issue but there was nothing i could find on MS that said anything either way

do a backup just in case
__________________
Deb

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- my 17yo sons first novel


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- download, get organised, enjoy
Reply With Quote
  #13  
Old 2010-12-16, 5:45pm
ironmountainglass's Avatar
ironmountainglass ironmountainglass is offline
Senior Member
 
Join Date: May 30, 2006
Location: NC
Posts: 913
Default

Quote:
Originally Posted by PerfectDeb View Post
i'm not sure, i tried to find some info about just that issue but there was nothing i could find on MS that said anything either way

do a backup just in case
I'm running Access 2000 and Open Office on my computer and its working just fine.
donna
__________________
"When life hands you lemons reach for the Tequila"
Donna
Reply With Quote
  #14  
Old 2010-12-16, 5:48pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

Quote:
Originally Posted by ironmountainglass View Post
I'm running Access 2000 and Open Office on my computer and its working just fine.
donna
really!!! are all the forms working ok?
__________________
Deb

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- my 17yo sons first novel


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- download, get organised, enjoy
Reply With Quote
  #15  
Old 2010-12-16, 5:51pm
KJJames's Avatar
KJJames KJJames is offline
Karen James
 
Join Date: Mar 22, 2006
Location: Rhode Island
Posts: 599
Default

Quote:
Originally Posted by ironmountainglass View Post
I'm running Access 2000 and Open Office on my computer and its working just fine.
donna
Do you mean Runtime is running fine? If so, thank you for the answer!
__________________

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
Karen
To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

Cricket, Mini CC, Devilbiss MC84 Oxy and NG
Reply With Quote
  #16  
Old 2010-12-16, 5:58pm
Deb's Avatar
Deb Deb is offline
Superkitty
 
Join Date: Jun 10, 2005
Posts: 2,897
Default

Thanks for the explaination, Deb. I'll stop worrying! lol!
__________________
Deb
Reply With Quote
  #17  
Old 2010-12-16, 5:59pm
ironmountainglass's Avatar
ironmountainglass ironmountainglass is offline
Senior Member
 
Join Date: May 30, 2006
Location: NC
Posts: 913
Default

Quote:
Originally Posted by PerfectDeb View Post
this is because the database has macros in it, its just a warning. you have to enable the macros or it wont work
Deb if she is using Open Office instead of Access she just needs to only click ok for it to open and run. I also think that the macros are automatic on Open Office because when I open it the program blinks like it does in
Access when you enable the macros. Does this make since? I hope so I have my quto of coffee today
__________________
"When life hands you lemons reach for the Tequila"
Donna
Reply With Quote
  #18  
Old 2010-12-16, 6:01pm
ironmountainglass's Avatar
ironmountainglass ironmountainglass is offline
Senior Member
 
Join Date: May 30, 2006
Location: NC
Posts: 913
Default

Quote:
Originally Posted by PerfectDeb View Post
this is because the database has macros in it, its just a warning. you have to enable the macros or it wont work
Quote:
Originally Posted by KJJames View Post
Do you mean Runtime is running fine? If so, thank you for the answer!


Yes if you have runtime downloaded it will automaticly open in it or it does on my computer.
__________________
"When life hands you lemons reach for the Tequila"
Donna
Reply With Quote
  #19  
Old 2010-12-16, 6:05pm
dkpmd04's Avatar
dkpmd04 dkpmd04 is offline
Glass & Parrots = Heaven
 
Join Date: Oct 10, 2009
Location: National Park, NJ
Posts: 184
Default

Hi Deb,
How do I remove a glass entry?

BTW thanks for all your hard work!
__________________
Dawn

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

Best Bud Cosmo - Eclectus Parrot
Reply With Quote
  #20  
Old 2010-12-16, 6:11pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

Quote:
Originally Posted by dkpmd04 View Post
Hi Deb,
How do I remove a glass entry?

BTW thanks for all your hard work!
just go back and search that glass again and uncheck the boxes then save
__________________
Deb

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- my 17yo sons first novel


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- download, get organised, enjoy
Reply With Quote
  #21  
Old 2010-12-16, 6:18pm
ironmountainglass's Avatar
ironmountainglass ironmountainglass is offline
Senior Member
 
Join Date: May 30, 2006
Location: NC
Posts: 913
Default

Quote:
Originally Posted by PerfectDeb View Post
really!!! are all the forms working ok?
They all seem to working great. I've added glass, I've removed glass, I've prined lables, I haven't added pics yet but will try and do that tonight.

Edited: I just added a picture and it works! whooot whoot.
__________________
"When life hands you lemons reach for the Tequila"
Donna

Last edited by ironmountainglass; 2010-12-16 at 6:26pm.
Reply With Quote
  #22  
Old 2010-12-16, 7:44pm
dkpmd04's Avatar
dkpmd04 dkpmd04 is offline
Glass & Parrots = Heaven
 
Join Date: Oct 10, 2009
Location: National Park, NJ
Posts: 184
Default

Quote:
Originally Posted by PerfectDeb View Post
just go back and search that glass again and uncheck the boxes then save
Thanks for the quick reply...should have known it would be so easy
__________________
Dawn

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

Best Bud Cosmo - Eclectus Parrot
Reply With Quote
  #23  
Old 2010-12-16, 8:29pm
cheng076's Avatar
cheng076 cheng076 is offline
Curmudgeon Engineering
 
Join Date: Feb 15, 2006
Location: Near Seattle, WA
Posts: 1,723
Default

I had to download the Runtime 2010 but then it worked right away and all functions I've tried are working.
Reply With Quote
  #24  
Old 2010-12-16, 8:49pm
penny5658 penny5658 is offline
Senior Member
 
Join Date: Sep 27, 2005
Location: Burnaby, BC Canada
Posts: 419
Default

Thanks so much for this and all the work you have put into it.Happy Holidays!
Penny
__________________
A Girl Can Never Have TOO Much Glass!
Reply With Quote
  #25  
Old 2010-12-16, 9:55pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

Quote:
Originally Posted by cheng076 View Post
I had to download the Runtime 2010 but then it worked right away and all functions I've tried are working.
great!

so far its only the mac peeps who cant use it

sorry guys
__________________
Deb

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- my 17yo sons first novel


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- download, get organised, enjoy
Reply With Quote
  #26  
Old 2010-12-16, 10:50pm
foolrex's Avatar
foolrex foolrex is offline
Ishum Designs
 
Join Date: Nov 08, 2010
Posts: 92
Default

Wow! And thank you! Haven't really started using this yet (just installed Access Runtime and opened it), but I am awed and grateful. Especially for folks that are trying to run a business, this is a great inventory tool (or at least looks like it). Really looking forward to organizing my stash!
Reply With Quote
  #27  
Old 2010-12-16, 11:46pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

Quote:
Originally Posted by foolrex View Post
Wow! And thank you! Haven't really started using this yet (just installed Access Runtime and opened it), but I am awed and grateful. Especially for folks that are trying to run a business, this is a great inventory tool (or at least looks like it). Really looking forward to organizing my stash!
it wont keep track of inventory, but it could easily be modified to do so. you would need to have the full version of Access to be able to modify it and that would cost you about $200 - if you want to do that email me and we'll work something out
__________________
Deb

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- my 17yo sons first novel


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
- download, get organised, enjoy
Reply With Quote
  #28  
Old 2010-12-17, 5:34am
Angie09 Angie09 is offline
Angie09
 
Join Date: Aug 06, 2009
Posts: 1,788
Default

Quote:
Originally Posted by PerfectDeb View Post

so far its only the mac peeps who cant use it

sorry guys
OH THAT'S WHAT'S WRONG!!! I figured it was just me .... BUMMER!!!
Reply With Quote
  #29  
Old 2010-12-17, 6:39am
KJJames's Avatar
KJJames KJJames is offline
Karen James
 
Join Date: Mar 22, 2006
Location: Rhode Island
Posts: 599
Default

Okay, MS Runtime 2010 and Access 2007 will not live peacefully on Windows 7. Not a problem though! Here is the deal. Using Access 2007, I exported all of the tables, forms, queries, etc...to a new database. The only form that would not come through was the Home form. Deb, you gave a sneak peek of that in the other thread. So, I knew that one of the forms you used to create it. However, there seems to be another form under that...My glass. Could you give me a screen print of that or tell me which form that is? Then I can just replicate the Home form and be good to go.

Thank you! This database is awesome!
__________________

To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
Karen
To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.

Cricket, Mini CC, Devilbiss MC84 Oxy and NG
Reply With Quote
  #30  
Old 2010-12-17, 11:04am
cheng076's Avatar
cheng076 cheng076 is offline
Curmudgeon Engineering
 
Join Date: Feb 15, 2006
Location: Near Seattle, WA
Posts: 1,723
Default

I have followed these StashMaster threads since its beginning. I have some first hand knowledge of software writing even if at the amatuer level. I was an initial tester of the database and it is obvious how much work went into this thing. I also know there will be support work needed on a continuing basis; bug fixes, new features, questions. It's like having a child you have to keep nurturing.

Debbie has refused to charge for this effort and I think that that is very kind and generous of her. BUT I strongly believe she should get something for her time, knowledge, effort, and kindness. She may not approve but I am suggesting we all send her a donation of at least $10.00. It isn't that much individually but may help her with Christmas or whatever. Maybe some suntan lotion for the Christmas Holidays down under

I don't know how PayPal works exactly and I only see an Etsy account so if anyone out there knows how this can be done please post it and I will be the first to send a donation. Lets support our friend for all her good work.

PJH

Last edited by cheng076; 2010-12-17 at 11:07am.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump




All times are GMT -7. The time now is 8:35pm.


Powered by vBulletin® Version 3.7.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Your IP: 98.84.18.52