How to Autofill a field based on a table of values

[amiliab]

I have a form based on a main table of geographic features. However, for all
new records, I would like to have the Geography Feature ID field autofill
based on a separate table of allowable values. I would use the autonumber
format for this, however, the allowable values are a list of letter codes
(i.e. AAAA through to AAAZ). I already have several records with acceptable
codes...however I would like all future records to pull ID's from this table.

What would be the best way to go about this?
Any help would be greatly appreciated.

Thanks.

 

[Arvin Meyer [MVP]]

The following link has code which will return values from AA001 through
ZZ999. You should be able to modify it to do what you need to do:

http://www.datastrat.com/Download/AlphaNumeric2K.zip

 

[Eighte]

The answer is:They canot tahan too.. It`s too katties..nice name.
hehehhehehe....:].

 

[Eighte]

Daddy does not want us to beak-up the good ties. We make look diff but
related."Ware`=Wali.

 

[Eighte]

I have but not like Takuya.hehehhe...

Hi -

When you create a new record in your main table, how do you tell what
allowable value to use, and must it be unique? In your example you only
can
have 26, but is that a typo? Or, do you want a new record to just have
the
next available letter code, in sequence, i.e. AAAA, AAAB, .... AAAZ,
AABA,
etc.

If the latter - i.e. codes in sequence, I can post a function which does
exactly that.

What are the fields in your Allowable Values table? In order to cover all
possible alphabetic 4-letter combinations, you would need over 450,000
entries!

John

 

[amiliab]

Hi John,

I have a block of allowable values (from LCBJB to LDAAA) which I would like
to go in sequential order (i.e. LCBJB to LCBJZ, then move to LCBJC, and so on
until LDAAA is reached - I think about 5100 codes in total). So basically,
yes I want new records to be assigned the next available letter code. Any
info you have would be greatly appreciated!

Thanks.

 

[Eighte]

By book.. Will Load it. You

Hi -

When you create a new record in your main table, how do you tell what
allowable value to use, and must it be unique? In your example you only
can
have 26, but is that a typo? Or, do you want a new record to just have
the
next available letter code, in sequence, i.e. AAAA, AAAB, .... AAAZ,
AABA,
etc. ILU.Rindu.

If the latter - i.e. codes in sequence, I can post a function which does
exactly that.

What are the fields in your Allowable Values table? In order to cover all
possible alphabetic 4-letter combinations, you would need over 450,000
entries!
-412/=
John



--

Trying to do carut excess:Is Karim Name dupe> John Goddard

 

[Eighte]

By book.. Will Load it. You

Hi -

When you create a new record in your main table, how do you tell what
allowable value to use, and must it be unique? In your example you only
can
have 26, but is that a typo? Or, do you want a new record to just have
the
next available letter code, in sequence, i.e. AAAA, AAAB, .... AAAZ,
AABA,
etc. ILU.Rindu.

If the latter - i.e. codes in sequence, I can post a function which does
exactly that.

What are the fields in your Allowable Values table? In order to cover all
possible alphabetic 4-letter combinations, you would need over 450,000
entries!
-412/=
John



--

Trying to do carut excess:Is Karim Name dupe> John Goddard