Re: AutoNumber feild

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jason (mail_at_jasonmartinez.com)
Date: 06/28/04 

Date: 28 Jun 2004 13:39:35 -0700

I didn't understand your exact question, but I had a similar problem
where auto numbers in my forms where not working in my ADP project
like they had in my .mdb application. I found the solution was
setting the form;s "Unique Table" to property the forms underlying
table.

Hope this helps,

Jason

"R.D.CHETTY" <anonymous@discussions.microsoft.com> wrote in message news:<2225601c45d0e$d9ce7c90$a301280a@phx.gbl>...
> Hi
> I used to have autonumber in the form which gives the
> current record no which i comfortably used to mention in
> the the document from where data is extracted for future
> reference.
>
> Now I linked the table to sql server, unless i add the
> record and go back I am unable to see the number.
> Everytime I can ask user tos ee like that as he feeds many
> records a day.
>
> To solve the problem I used another form whre max number
> of feild to display which means the last record.This form
> is made to pop up on pressing add record.
>
> Is there any way to display the autonumber before the
> record is inserted like in access
>
> Thanks in advance
> R.D.CHETTY

Relevant Pages

  • Auto Number
    ... To display 7 digits for the autonumber make the format for ... >How do I get the auto number to display 7 digits? ...
    (microsoft.public.access.gettingstarted)
  • Re: Design Problem
    ... > MFIDS PK (Auto Number) ... > IDS PK ... If only clients can be Primary Contacts, ... there is no point in using an autonumber as part of a compound PK, ...
    (microsoft.public.access.tablesdbdesign)
  • Netscape & CSS
    ... display: inline; ... bottom: auto; ...
    (alt.html)
  • Re: Hpw best to link item & detail when items are very different
    ... tblItems ... itmItmID PK autonumber ... Item Telephone would have details of Color, Cordless y/n, Answer y/n ... A details table for each Item type makes the most sense but I am not sure how to display the one I need using forms ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Funkthermometer fürs Auto?
    ... >Moin moin, ... >Auto einbauen. ... sowie noch nicht einmal die Innentemperatur. ... Sonneneinstrahlung war das Display komplett schwarz und nach 3 Monaten ...
    (de.etc.fahrzeug.auto)