Prev: 2 Designers
Next: SAVING REPORTS "SAVE AS"
From: Cinquefoil22 on 27 May 2010 17:01
Simple question, hope I can get an answer....
Ok, I have created a table and form for our company to keep track of incoming
inventory. Being that we work with metals, each piece that comes in is
assigned
a unique 3 letter value. We started with AAA. What I need to know is once I
enter the item we are receiving is there a way for it to automatically go to
the
next sequence of letters. Example, yesterday we received in. The last
series
of letters I used was BHV. So today, when I receive in, I want the product
to
automatically be assigned BHW and then BHX and so on. After I use BHZ my
next sequence would be BIA. Ultimately when I get to BZZ, my next sequence
would be CAA and so on....
Do you think you can help me figure out how to do this?

From: Dorian on 27 May 2010 17:04
Its pretty easy to do. Set up a string with all letters in sequence with an
extra A at end.
Dim strAB = "A........ZA"
Then you use INSTR function (look in HELP for details) to locate the letter
and then just add 1 to position to the next one.
You will have to check when last letter goes from Z to A since that will
trigger the same logic for the second letter. Same for the second letter
changing from Z to A triggers changing the first letter.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Cinquefoil22" wrote:

> Simple question, hope I can get an answer....
> Ok, I have created a table and form for our company to keep track of incoming
> inventory. Being that we work with metals, each piece that comes in is
> assigned
> a unique 3 letter value. We started with AAA. What I need to know is once I
> enter the item we are receiving is there a way for it to automatically go to
> the
> next sequence of letters. Example, yesterday we received in. The last
> series
> of letters I used was BHV. So today, when I receive in, I want the product
> to
> automatically be assigned BHW and then BHX and so on. After I use BHZ my
> next sequence would be BIA. Ultimately when I get to BZZ, my next sequence
> would be CAA and so on....
> Do you think you can help me figure out how to do this?
>
From: Cinquefoil22 on 27 May 2010 17:51
ok, but where am i typing the string at? I think, honestly, I am just
confused all the way around on what you are telling me to do....
Sorry...

"Dorian" wrote:

> Its pretty easy to do. Set up a string with all letters in sequence with an
> extra A at end.
> Dim strAB = "A........ZA"
> Then you use INSTR function (look in HELP for details) to locate the letter
> and then just add 1 to position to the next one.
> You will have to check when last letter goes from Z to A since that will
> trigger the same logic for the second letter. Same for the second letter
> changing from Z to A triggers changing the first letter.
> -- Dorian
> "Give someone a fish and they eat for a day; teach someone to fish and they
> eat for a lifetime".
>
>
> "Cinquefoil22" wrote:
>
> > Simple question, hope I can get an answer....
> > Ok, I have created a table and form for our company to keep track of incoming
> > inventory. Being that we work with metals, each piece that comes in is
> > assigned
> > a unique 3 letter value. We started with AAA. What I need to know is once I
> > enter the item we are receiving is there a way for it to automatically go to
> > the
> > next sequence of letters. Example, yesterday we received in. The last
> > series
> > of letters I used was BHV. So today, when I receive in, I want the product
> > to
> > automatically be assigned BHW and then BHX and so on. After I use BHZ my
> > next sequence would be BIA. Ultimately when I get to BZZ, my next sequence
> > would be CAA and so on....
> > Do you think you can help me figure out how to do this?
> >
 | 
Pages: 1
Prev: 2 Designers
Next: SAVING REPORTS "SAVE AS"