|
|
| Artuhr K 2006-03-28, 6:29 pm |
| I have a table in Access2002. Within this table there is an ID field that is
defined as AUTONUMBERed.
When I populate the form and get into INSERT RECORD mode the ID field is
empty. How do I populate that field with appropriate number ?
Arthur
| |
|
| Artuhr K wrote:
> I have a table in Access2002. Within this table there is an ID field
> that is defined as AUTONUMBERed.
> When I populate the form and get into INSERT RECORD mode the ID field
> is empty. How do I populate that field with appropriate number ?
Don't. Don't put anything in that field, and it will generate it's own
number. It's not needed on the form.
HTH,
Pete.
--
Peter Connolly
http://www.acutecomputing.co.uk
Derby
UK
Skype ID: acutecomputing
| |
| bregent 2006-03-28, 6:29 pm |
| You don't. You should not try to populate an autonumber column. The dbms will do it for you. Do not pass any value to this column in the insert statement.
| |
| bregent 2006-03-28, 6:29 pm |
| To be more clear, do not use this column at all in your insert statement.
| |
| Joe Makowiec 2006-03-28, 6:29 pm |
| On 28 Mar 2006 in macromedia.dreamweaver, Artuhr K wrote:
> I have a table in Access2002. Within this table there is an ID field
> that is defined as AUTONUMBERed.
> When I populate the form and get into INSERT RECORD mode the ID
> field is empty. How do I populate that field with appropriate number
> ?
The others have the right answer, but to emphasize: Don't even include
the field in the form.
--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/email.php
|
|
|
|
| Copyright 2003 - 2008 forum4designers.com Software forum Computer Hardware reviews |