Re: Advise

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Michael Lam (kl_mis_at_pacific.net.hk)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 14:53:02 +0800

Dear Larry

Is there any way to avoid such situation cos that access program will be
accessed by totally three offices (one local and two connected by T1 line )

THx

Michael Lam
"Larry Linson" <bouncer@localhost.not> ¦b¶l¥ó
news:OW1t5529DHA.2368@TK2MSFTNGP11.phx.gbl ¤¤¼¶¼g...

"Michael Lam" <kl_mis@pacific.net.hk> wrote in message
news:OZqV%23G19DHA.2404@TK2MSFTNGP12.phx.gbl...
> thx , I have use the Autonumber already
>
> But I when test the form , It generate the number as soon as I start keyin
> the info. Is there any way to make the autonumber field generate number
> after click the Save button ?

No. That is not the way AutoNumber works, unless you are using an unbound
form and writing the information from code to a table that has an Autonumber
field. I do not, as a general rule, think it a good idea to use unbound
forms for data, because you have to reimplement functionality that is
included in (and massively tested) Access.

  Larry Linson
  Microsoft Access MVP

Quantcast