Lampwork Etc.
 
TrueDesign on Ebay

LE Live Chat

Enter Live Chat

No users in chat


Donate via PayPal to donate@lampworketc.com

Beads of Courage


 

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

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

Reply
 
Thread Tools
  #151  
Old 2011-01-09, 6:57pm
echeveria's Avatar
echeveria echeveria is offline
Senior Member
 
Join Date: Aug 31, 2006
Location: Knoxville, TN
Posts: 1,909
Default

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
__________________
Kathy
Reply With Quote
  #152  
Old 2011-01-09, 7:22pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

good idea - i was thinking of put a batch field in but that might be easier
__________________
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
  #153  
Old 2011-01-09, 8:51pm
SadiesJewels's Avatar
SadiesJewels SadiesJewels is offline
Senior Member
 
Join Date: Jun 21, 2005
Location: Melbourne, Australia
Posts: 4,627
Default

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.
__________________

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.


To view links or images in signatures your post count must be 5 or greater. You currently have 0 posts.
Reply With Quote
  #154  
Old 2011-01-09, 8:52pm
Toni Lutman's Avatar
Toni Lutman Toni Lutman is offline
maybe tomorrow
 
Join Date: Jun 17, 2005
Location: Carmichael, CA
Posts: 3,098
Default

Quote:
Originally Posted by echeveria View Post
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!
__________________
Toni
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
  #155  
Old 2011-01-09, 10:12pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

ok, i'll look at it - it still presents problems though, cos a different batch is just like a whole new colour anyway
__________________
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
  #156  
Old 2011-01-09, 10:57pm
Toni Lutman's Avatar
Toni Lutman Toni Lutman is offline
maybe tomorrow
 
Join Date: Jun 17, 2005
Location: Carmichael, CA
Posts: 3,098
Default

I don't think you need to make more work for yourself. We'll all gladly work around whatever you do.
__________________
Toni
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
  #157  
Old 2011-01-09, 11:05pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

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
__________________
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
  #158  
Old 2011-01-09, 11:37pm
Toni Lutman's Avatar
Toni Lutman Toni Lutman is offline
maybe tomorrow
 
Join Date: Jun 17, 2005
Location: Carmichael, CA
Posts: 3,098
Default

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.
__________________
Toni
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
  #159  
Old 2011-01-10, 10:47am
echeveria's Avatar
echeveria echeveria is offline
Senior Member
 
Join Date: Aug 31, 2006
Location: Knoxville, TN
Posts: 1,909
Default

What about using the comment field for that?
__________________
Kathy
Reply With Quote
  #160  
Old 2011-01-10, 12:05pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

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!
__________________
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
  #161  
Old 2011-01-10, 12:23pm
echeveria's Avatar
echeveria echeveria is offline
Senior Member
 
Join Date: Aug 31, 2006
Location: Knoxville, TN
Posts: 1,909
Default

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.
__________________
Kathy
Reply With Quote
  #162  
Old 2011-01-10, 12:28pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

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
__________________
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
  #163  
Old 2011-01-10, 12:29pm
Toni Lutman's Avatar
Toni Lutman Toni Lutman is offline
maybe tomorrow
 
Join Date: Jun 17, 2005
Location: Carmichael, CA
Posts: 3,098
Default

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!
__________________
Toni
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
  #164  
Old 2011-01-11, 5:32pm
pendragonfyre pendragonfyre is offline
Senior Member
 
Join Date: Mar 14, 2009
Location: Berry Mills, NB, Canada
Posts: 143
Default

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

Smiles,
Darlene
__________________

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.

E-Bay:
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
  #165  
Old 2011-01-11, 5:55pm
GlassPuppy's Avatar
GlassPuppy GlassPuppy is offline
Can't you see I'm busy???
 
Join Date: May 05, 2007
Location: Asheville, NC
Posts: 120
Default

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
Reply With Quote
  #166  
Old 2011-01-11, 9:26pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

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 View Post
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
__________________
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
  #167  
Old 2011-01-12, 4:17am
GlassPuppy's Avatar
GlassPuppy GlassPuppy is offline
Can't you see I'm busy???
 
Join Date: May 05, 2007
Location: Asheville, NC
Posts: 120
Default

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!
Reply With Quote
  #168  
Old 2011-01-12, 4:22am
GlassPuppy's Avatar
GlassPuppy GlassPuppy is offline
Can't you see I'm busy???
 
Join Date: May 05, 2007
Location: Asheville, NC
Posts: 120
Default

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....
Reply With Quote
  #169  
Old 2011-01-12, 7:06am
FourTailsLampwork's Avatar
FourTailsLampwork FourTailsLampwork is offline
The Andrea Half
 
Join Date: Aug 18, 2006
Location: Georgia
Posts: 1,411
Default

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
__________________

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
  #170  
Old 2011-01-12, 10:02am
cheng076's Avatar
cheng076 cheng076 is offline
Curmudgeon Engineering
 
Join Date: Feb 15, 2006
Location: Near Seattle, WA
Posts: 1,723
Default

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.

Last edited by cheng076; 2011-01-12 at 10:06am.
Reply With Quote
  #171  
Old 2011-01-12, 2: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 FourTailsLampwork View Post
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
__________________
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
  #172  
Old 2011-01-12, 2:13pm
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 GlassPuppy View Post
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
__________________
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
  #173  
Old 2011-01-12, 3:16pm
FourTailsLampwork's Avatar
FourTailsLampwork FourTailsLampwork is offline
The Andrea Half
 
Join Date: Aug 18, 2006
Location: Georgia
Posts: 1,411
Default

Quote:
Originally Posted by PerfectDeb View Post
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.
__________________

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
  #174  
Old 2011-01-12, 3:26pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

we only learn by screwing up
__________________
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
  #175  
Old 2011-01-13, 11:07am
cheng076's Avatar
cheng076 cheng076 is offline
Curmudgeon Engineering
 
Join Date: Feb 15, 2006
Location: Near Seattle, WA
Posts: 1,723
Default

Well then, I'm a freeekin genious!
Reply With Quote
  #176  
Old 2011-01-13, 1:07pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

as are we all
__________________
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
  #177  
Old 2011-01-13, 8:51pm
Listenup's Avatar
Listenup Listenup is offline
It's all about the color.
 
Join Date: Jul 03, 2005
Location: Texas
Posts: 1,832
Default

Quote:
Originally Posted by PerfectDeb View Post
we only learn by screwing up
Hey, I resemble that remark...lol
__________________
Kay Powell

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
  #178  
Old 2011-01-16, 4:20pm
xxxMiEkAxxx's Avatar
xxxMiEkAxxx xxxMiEkAxxx is offline
I <3 My Attitude Problem
 
Join Date: Jul 19, 2006
Location: Syracuse, NY
Posts: 119
Default

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!!!
__________________
-Sarah

Find me on
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
  #179  
Old 2011-01-16, 4:27pm
PerfectDeb's Avatar
PerfectDeb PerfectDeb is offline
Unmedicated since '62
 
Join Date: Jan 18, 2009
Location: Hunter Valley, Australia
Posts: 5,907
Default

you can apparently run it on a mac if you run parallels - its soooo not my field, sorry
__________________
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
  #180  
Old 2011-01-16, 4:57pm
xxxMiEkAxxx's Avatar
xxxMiEkAxxx xxxMiEkAxxx is offline
I <3 My Attitude Problem
 
Join Date: Jul 19, 2006
Location: Syracuse, NY
Posts: 119
Default

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

Find me on
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
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 11:25am.


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