Generating Unique Numbers on a Form with Multi-users

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.

This is what I think the sequence of events should be and what I've done to
try and acheive my goal:

1. Set the focus to the DocSent field (so uses can enter the date). As soon
as user starts typing new doc no. displays [Me.DocSentDate.SetFocus in
OnCurrent Event].

2. User enters the current date and then TABs or clicks in the next field
and the form is refreshed to add the new doc no. to the dataset to ensure it
is not used again [Me.Refresh in BeforeUpdate Event of DocSentDate field].

At step two I get an error: Run-time error ‘2115’ – the macro or function
set to the BeforeUpdate or ValidationRule property for this field is
preventing Access from saving the data in the field.

I would also like to have some compulsory fields but this doesn't seem
possible if you're going to use the Me.Refresh command ... or without a lot
of serious programming.

Can anyone help me please?

Many thanks,
Nerida.

--
Cheers,
Nerida

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200612/1

.

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)
  • 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: 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 ... is the primary key and is an Autonumber. ...
    (microsoft.public.access.forms)