Re: AutoNumber feild

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

From: R.D.CHETTY (anonymous_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 03:13:21 -0700

Jason

That is what exactly my problem . But I linked the table
and not using adps. We dont have unique table property in
mdbs, though bound to linked tables, is not it?

Any help?

R.D.CHETTY

>-----Original Message-----
>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

  • Re: adp vs mdb
    ... only options for Access development are MDB and ADP, ... has been recommending MDB over ADP for a couple of years now. ... MDBs with ODBC perform better than ADPs, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: adp vs mdb
    ... how is MDB linked tables LESS LAYERS than just OLEDB? ... only options for Access development are MDB and ADP, ... MDBs with ODBC perform better than ADPs, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access awake after 7 years?
    ... I'm not sure I understand what the "idea" of ADPs was supposed to ... I don't see why MDBs couldn't have had features added to interface ... better with SQL Server, rather than throwing that out and starting ... Server front end solution) on the capabilities of ADO, ...
    (comp.databases.ms-access)
  • Re: Multiple Form_Current events in ADP projects with subforms
    ... have debug code in the Form_Current events of all the linked subforms. ... I think that ADPs are very different than MDBs, and it would be nice is we ... > being called multiple times? ...
    (microsoft.public.access.formscoding)
  • Re: Using a Simple Query Wizard
    ... What have you done to troubleshoot this? ... Does this happen in all MDBs? ... What are the field types that don't display? ...
    (microsoft.public.access.queries)