Re: Generating Unique Numbers on a Form with Multi-users

"Nerida via AccessMonster.com" <u15138@uwe> wrote in message
news:6ac7b8cb13e38@xxxxxx
Hi there,

Hope someone can help me out. I am developing a little Db to help track
documents. There will be around 6 users of the database and each document
entered in needs a unique number to help keep track of it. The unique
number
(DocNo) is the primary key and is an Autonumber.


Using AutoNumber may give you gaps in the numbers, eg 1, 5, 6, 7, 12 ... and
so on. Use this as a text box's default value if you want sequential
numbering:

Nz(DMax("MyField","tblMyTable")) +1

Keith.
www.keithwilby.com


.

Relevant Pages

  • Generating Unique Numbers on a Form with Multi-users
    ... I am developing a little Db to help track ... There will be around 6 users of the database and each document ... Set the focus to the DocSent field. ... is not used again [Me.Refresh in BeforeUpdate Event of DocSentDate field]. ...
    (microsoft.public.access.forms)
  • Generating Unique Numbers on a Form with Multi-users
    ... I am developing a little Db to help track ... There will be around 6 users of the database and each document ... Set the focus to the DocSent field. ... is not used again [Me.Refresh in BeforeUpdate Event of DocSentDate field]. ...
    (microsoft.public.access.forms)
  • Q:Job search tracking software?
    ... Is there any decent software which I could use to help track my job ... also job sources and be able to link between ... sources and jobssources.(1 to many or even many to many database ... It must have both PC and PPC client and have easy access to the data (I ...
    (microsoft.public.pocketpc)
  • Re: Generating Unique Numbers on a Form with Multi-users
    ... I am developing a little Db to help track ... There will be around 6 users of the database and each ... it's possible two users may grab the same value that way. ... there was no mention made that gaps in the numbering were a ...
    (microsoft.public.access.forms)
  • Re: Restart Autonumbering
    ... compact the database. ... If that does not reset the seed of the autonumber, ... could then use an append query to catch it up to the present numbering. ...
    (microsoft.public.access.tablesdbdesign)
Loading