StashMaster Glass Database - Page 6

echeveria · #**151** 2011-01-09, 6:57pm

I have been adding a new color for the ones that I want to be batch dated, and then putting the date in the color. Like

Aether 12-4-09 as the color instead of just Aether

PerfectDeb · #**152** 2011-01-09, 7:22pm

good idea - i was thinking of put a batch field in but that might be easier

SadiesJewels · #**153** 2011-01-09, 8:51pm

No I think a batch field would be better as it could get very cumbersome to add the date to each lot of glass as a name. I also add the vendor to my labels ... lol (just in case)

Also I'd like the export to excel option.

Toni Lutman · #**154** 2011-01-09, 8:52pm

Quote:

Originally Posted by echeveria

I have been adding a new color for the ones that I want to be batch dated, and then putting the date in the color. Like

Aether 12-4-09 as the color instead of just Aether

I go through an awful lot of some of the silver glasses. I don't even want to know how many times a year I order from DH, and there are certain colors that I order pretty much every time.

I think it would start to really clutter up things if I created a new item each time. Ack!

PerfectDeb · #**155** 2011-01-09, 10:12pm

ok, i'll look at it - it still presents problems though, cos a different batch is just like a whole new colour anyway

Toni Lutman · #**156** 2011-01-09, 10:57pm

I don't think you need to make more work for yourself. We'll all gladly work around whatever you do.

PerfectDeb · #**157** 2011-01-09, 11:05pm

and we discussed this earlier - apart from special silver glass, when you get new glass do you religiously separate it from the last batch? i guess you might if you labelled it right i guess

maybe i'm just not anal enough

Toni Lutman · #**158** 2011-01-09, 11:37pm

I don't keep different batches separated, but I have them labeled so that if it turns out there's a batch that reacts differently from the norm, I can pull it aside if I want to.

echeveria · #**159** 2011-01-10, 10:47am

What about using the comment field for that?

PerfectDeb · #**160** 2011-01-10, 12:05pm

yep, you could put a comment saying that batch date xx/xx/xxxx is more silver or more shocky etc - that might be the best way, otherwise you're going to get lots of different records for the same glass and that breaks the golden rule of database - DONT DUPLICATE!

echeveria · #**161** 2011-01-10, 12:23pm

Since there is a spot for Torch Notes and a spot for Comments, I think there is a lot of room for special handling. Use the Comments for short things like a date or a source, and then use the Torch Notes for permanent comments that you want to keep in there. You can change the comment to the new batch date each time you want to print labels.

The other option is to find the color in the spreadsheet before you do your merge and add a column for batch date and fill it in directly in the spreasheet.

PerfectDeb · #**162** 2011-01-10, 12:28pm

yes, i tried to put lots of field where you could put whatever you like so that will work

there is a facility to delete ones you dont like in the new version so that lets you create temporary items too

Toni Lutman · #**163** 2011-01-10, 12:29pm

Good idea! I know I just need to play with it more to find the easiest way for me. Sounds like there are lots of ways to go! Thanks!

pendragonfyre · #**164** 2011-01-11, 5:32pm

Deb,
Email those tables to me when you have a chance... I am looking into a possibility for us Mac users...

Smiles,
Darlene

GlassPuppy · #**165** 2011-01-11, 5:55pm

OK - say you buy a batch of something, and put a batch date in the Comments field. Then six weeks later, you get more. Now what? Add another date in the comments field?

I think if you truly want to keep track of batches there is only one (or maybe two) ways to do it - make each batch a new glass as has been suggested, or ( maybe lots of work for our noble Deb) add a batch field that is part of the key. This is a tough one to solve.

Deb, what seems to work best for you? All options can work, just each in a different way.

Hope I'm adding light, not heat!

Whatever you decide, we love your StashMaster!

Pat

PerfectDeb · #**166** 2011-01-11, 9:26pm

just add a comment to the comment field then when you print the labels identify that batch somehow (b1, b2, b3) etc

so the comment would read

b1 - new batch, purchased 12/01/11 darker colour
b2 - new batch, purchased 16/04/11 has streaks and is shocky

etc

so when you pick up a rod and it has

123456
blue
b2

you know what it is

Quote:

Originally Posted by GlassPuppy

OK - say you buy a batch of something, and put a batch date in the Comments field. Then six weeks later, you get more. Now what? Add another date in the comments field?

I think if you truly want to keep track of batches there is only one (or maybe two) ways to do it - make each batch a new glass as has been suggested, or ( maybe lots of work for our noble Deb) add a batch field that is part of the key. This is a tough one to solve.

Deb, what seems to work best for you? All options can work, just each in a different way.

Hope I'm adding light, not heat!

Whatever you decide, we love your StashMaster!

Pat

GlassPuppy · #**167** 2011-01-12, 4:17am

Oh oops - so the batch comment is only for label printing - perfect, Deb! My mistake was thinking that the comment became part of the permanent record.

Looks like StashMaster will work perfectly for my needs!

GlassPuppy · #**168** 2011-01-12, 4:22am

Oh dear - stated that wrong - the comment is not just for the label, there are actually Comments fields for both the record and the batch. Even better!

Think I'll shut up now....

FourTailsLampwork · #**169** 2011-01-12, 7:06am

I have another thought, as I use this wonderful database --the one thing I am frustrated with is having to choose the glass according to color name. I don't think in names so much as in numbers, because names vary so much! So I poick the clolor, scroll back up to check the number ...

However, I can fix that by fiddling with it when I can actually *get* to my university office and use a Windows machine. Then I can change the form to let me pick by number rather than name, and have it autofill the name rather than the number. Right now I am not venturing out on the slick ice, period. Okay, I have to refill a prescription, but other than that am not going anywhere

cheng076 · #**170** 2011-01-12, 10:02am

Since a new order of the same color that is different is a new color essentially, why not just create a new color with that batch name or date in the name? "Glory Hole White 1.2.3" and "Glory Hole White 2.3.4". You then know it is/was supposed to be "Glory Hole White" but was slightly different in shade and the date tells you which batch it is.

PerfectDeb · #**171** 2011-01-12, 2:11pm

Quote:

Originally Posted by FourTailsLampwork

I have another thought, as I use this wonderful database --the one thing I am frustrated with is having to choose the glass according to color name. I don't think in names so much as in numbers, because names vary so much! So I poick the clolor, scroll back up to check the number ...

However, I can fix that by fiddling with it when I can actually *get* to my university office and use a Windows machine. Then I can change the form to let me pick by number rather than name, and have it autofill the name rather than the number. Right now I am not venturing out on the slick ice, period. Okay, I have to refill a prescription, but other than that am not going anywhere

are you good with Access and macros and VB etc? if so, its easy to change - you just have to go into the after update event procedure for the second combo box and make it select by code instead of colour

if this all sounds like gobbldygook then dont do it

PerfectDeb · #**172** 2011-01-12, 2:13pm

Quote:

Originally Posted by GlassPuppy

Oh dear - stated that wrong - the comment is not just for the label, there are actually Comments fields for both the record and the batch. Even better!

Think I'll shut up now....

there is only one comment field - you can put anything you like it that field

FourTailsLampwork · #**173** 2011-01-12, 3:16pm

Quote:

Originally Posted by PerfectDeb

are you good with Access and macros and VB etc? if so, its easy to change - you just have to go into the after update event procedure for the second combo box and make it select by code instead of colour

if this all sounds like gobbldygook then dont do it

I'm just good enough to screw it up royally, which is why I will play with a copy. Of course. I almost didn't make it back into my driveway after having to go out for a prescription, so it'll be quite a while before I can get to a Windows machine that has Access on it.

PerfectDeb · #**174** 2011-01-12, 3:26pm

we only learn by screwing up

cheng076 · #**175** 2011-01-13, 11:07am

Well then, I'm a freeekin genious!

PerfectDeb · #**176** 2011-01-13, 1:07pm

as are we all

Listenup · #**177** 2011-01-13, 8:51pm

Quote:

Originally Posted by PerfectDeb

we only learn by screwing up

Hey, I resemble that remark...lol

xxxMiEkAxxx · #**178** 2011-01-16, 4:20pm

Deb, I can't tell you how thrilled I am and how much I appreciate all your hard work!

Sorry to be late to the game and all, and I've read through the comments but still I"m unclear; has anyone figured out how to run this on a mac at all? I wanna use the database!!!

PerfectDeb · #**179** 2011-01-16, 4:27pm

you can apparently run it on a mac if you run parallels - its soooo not my field, sorry

xxxMiEkAxxx · #**180** 2011-01-16, 4:57pm

That's okay, Deb- I think I actually have a copy of parallels laying around!