how can I autogenerate value for a text field

[moonrb]

Hi,

I have a customer table with a Primary field name "CustomerCo de" .

I want that the value in the field should generate automatically, like A001 To A200 and then B001 to B200 and go on

Is it possible?

Thanks

[zmbd]

Moonrb: Asking for code is against the site rules; however, if you will search back in the access forum, several versions of this have been covered and in many different methods.

In your case, I would have two fields, on with the A, B, C, etc.. and a second with the sequence (1,2,3,... 198,199,200)
The query would be to group (and sort) on letter field and return the max of the sequence field now would would get a table of:
[A][200]
[B][200]
[C][198]

Now I would do a findfirst to return the record where [sequence]<200, if no records, then move to the last record to find the next letter, I use the ascii values and just return the max, converting to letter in the calculated formula for the field/control

there are 20 other different methods... (^_^)

[NeoPa]

Using a DMax() call on the existing data will give you the last one used to date. From there is should be very straightforward to work out the next in the sequence and use it.

NB. This sequence gives you a maximum number of 5,200 records. Few real-life situations will manage with that for very long. Possibly yours might, but I'd advise you to be very certain at the design stage as it's so much harder to fix later on.