Re: Unique fields using AAAA instead of/as well as AutoNum

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

That's OK! Just use the method with QuoteID when entering quotes to generate
the four character unique field. Orders are related to quotes so just carry
over the four character field when entering an order. Don't calculate the
four characters from OrderID.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@xxxxxxxxxxxxxxx
www.pcdatasheet.com


"BenjieB" <BenjieB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BEAC134E-5C7E-4724-9CA3-2975EDCF5BC4@xxxxxxxxxxxxxxxx
> Hiya,
>
> Thanks for this...greatly appreciated.
>
> As it's for a high value low turnover product application with an
> extremely
> optimistic estimate of 30 quotes max per month, 676 should be more than
> sufficient for a 6 month interim solution. Also am none too sure of the
> feasibility of this due to the user wants/needs to generate the 4char
> during
> the quote stage; ineffect the quote ID becomes the acount ID upon sale as
> it
> were.
>
> Ben
>
> "PC Datasheet" wrote:
>
>> AA to ZZ is 676 records (26*26). Keep your autonumber. Make the last
>> autonumber you have GLAA and create a function that calculates the four
>> characters based on the number of records entered since your last
>> autonumber. For example: say your last autonumber is 34511 and records
>> have
>> been added and none deleted to where your current autonumber is 34536. 25
>> records have been added so your four characters are GLAZ. BTW, you can
>> test
>> if there are any gaps in the numbers to determine if any records have
>> been
>> deleted after 34511.
>>
>> --
>> PC Datasheet
>> Your Resource For Help With Access, Excel And Word Applications
>> resource@xxxxxxxxxxxxxxx
>> www.pcdatasheet.com
>>
>>
>> "BenjieB" <BenjieB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:420CEEA6-0018-4F65-B25A-D0451248BE01@xxxxxxxxxxxxxxxx
>> > Hi,
>> >
>> > Does anyone know of a way of creating an auto generated/increasing in
>> > value
>> > field (key) that uses chars instead of (or in addition to) Autonum e.g.
>> > GLAA,
>> > GLAB, GLAC, GLAD...etc.?
>> >
>> > Any ideas, views, comments or help would be very welcome.
>> >
>> > Thanks
>> >
>> > Ben
>>
>>
>>


.

Relevant Pages

  • Weird, Wise or Wacky. (MST character quotes)
    ... Below are listed 10 quotes from characters in MSTed movies. ... The sorcerer "Lodac" to Sir Branden as Lodac reneges ...
    (rec.arts.tv.mst3k.misc)
  • Re: Weird characters in a textbox
    ... It may be automatically replacing text as you type, e.g., Printers' Quotes for Regular Quotes. ... you'll have to look at the Character Map to see if the fancier quotes are available in that font. ... When I click the zoom box the>characters ...
    (microsoft.public.access.formscoding)
  • Re: Letter AND Merge by Category
    ... The one thing you do need to be sure of is that every pair of are not the ordinary characters you can type on the keyboard, but the special field code braces that you can insert using ctrl-F9 ... The instructions explain about the quotes, ... Example: SET Donor1 {Mergefield "Donor"} ... The constant in the mail merge is the Sales Manager name. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Quotes, Tilde, Caret Symbol appears only when clicked twice !
    ... Quotes and Carets are a common way of typing ... characters like e' and ... The strange thing is that when I type out any of these symbols twice ...
    (comp.databases.ms-access)
  • Re: Importing from Excel
    ... as it will import longer strings. ... table is the order of the fields, results because there is no Autonumber ... Special characters that you must avoid when you work with Access databases ... >>> errror occured while importing 'File' File was not imported. ...
    (microsoft.public.access.externaldata)