Re: AutoNumber feild
From: Jason (mail_at_jasonmartinez.com)
Date: 06/28/04
- Next message: John Eikanger [MSFT]: "RE: DETAILS SOUGHT: Renaming this user-defined function removes any existing permissions and extended properties."
- Previous message: Bill D: "why does NT user have access to all tables?"
- In reply to: R.D.CHETTY: "AutoNumber feild"
- Next in thread: R.D.CHETTY: "Re: AutoNumber feild"
- Reply: R.D.CHETTY: "Re: AutoNumber feild"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: John Eikanger [MSFT]: "RE: DETAILS SOUGHT: Renaming this user-defined function removes any existing permissions and extended properties."
- Previous message: Bill D: "why does NT user have access to all tables?"
- In reply to: R.D.CHETTY: "AutoNumber feild"
- Next in thread: R.D.CHETTY: "Re: AutoNumber feild"
- Reply: R.D.CHETTY: "Re: AutoNumber feild"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|