A different autonumber question - single column table

Table with just one column which is an autonumber column - how do I insert
records?

--
Tim Ward
Brett Ward Limited - www.brettward.co.uk

"Tim Ward" wrote in
:


Table with just one column which is an autonumber column - how do I
insert records?

Like any other insert command:

INSERT INTO MyTable (MyANcolumn)
VALUES (1024)

but why would you want to..?

B Wishes


Tim F

"Tim Ferguson" wrote in message
...
"Tim Ward" wrote in
:


Table with just one column which is an autonumber column - how do I
insert records?

Like any other insert command:

INSERT INTO MyTable (MyANcolumn)
VALUES (1024)

but why would you want to..?

I think he means manually, from the UI. He has opened the table datasheet.
How does he add new records to it (manually)?!

TC

"TC" wrote in :

but why would you want to..?

I think he means manually, from the UI. He has opened the table
datasheet. How does he add new records to it (manually)?!



Ummm.... why would he want to?

What about pressing tab whilst the focus is on the autonumber field of
the "new record" row...

Puzzled


Tim F

"Tim Ferguson" wrote in message
...
"TC" wrote in :

but why would you want to..?

I think he means manually, from the UI. He has opened the table
datasheet. How does he add new records to it (manually)?!



Ummm.... why would he want to?

What about pressing tab whilst the focus is on the autonumber field of
the "new record" row...

Oops, yep, I guess that would do it.

As for why - I fear that we shall never know!

Cheers,
TC

"Tim Ferguson" wrote in message
...
"Tim Ward" wrote in
:


Table with just one column which is an autonumber column - how do I
insert records?

Like any other insert command:

INSERT INTO MyTable (MyANcolumn)
VALUES (1024)

Doesn't work, surely, doesn't that just put 1024 into the AutoNumber column
rather than generating an automatic value?

but why would you want to..?

Eh?? A table isn't much use if you can't insert records into it.

--
Tim Ward
Brett Ward Limited - www.brettward.co.uk

The only purpose of an AutoNumber Field is to provide uniqueness to each
Record in the Table. Thus, the Table with only the AutoNumber Field does
not have any useful information content.

Why would you want to create the Table without any meaningful info. content?

--
HTH
Van T. Dinh
MVP (Access)




"Tim Ward" wrote in message
...
"Tim Ferguson" wrote in message
...
"Tim Ward" wrote in
:


Table with just one column which is an autonumber column - how do I
insert records?

Like any other insert command:

INSERT INTO MyTable (MyANcolumn)
VALUES (1024)

Doesn't work, surely, doesn't that just put 1024 into the AutoNumber
column
rather than generating an automatic value?

but why would you want to..?

Eh?? A table isn't much use if you can't insert records into it.

--
Tim Ward
Brett Ward Limited - www.brettward.co.uk

"Van T. Dinh" wrote in message
...
The only purpose of an AutoNumber Field is to provide uniqueness to each
Record in the Table. Thus, the Table with only the AutoNumber Field does
not have any useful information content.

Why would you want to create the Table without any meaningful info.
content?

Because the only attribute of this object is a multivalued attribute, so the
actual information is in a join table which refers back to this main table
via a foreign key.

--
Tim Ward
Brett Ward Limited - www.brettward.co.uk

So you have another Field in this Table which is a ForeignKey Field???

--
HTH
Van T. Dinh
MVP (Access)


"Tim Ward" wrote in message
...
"Van T. Dinh" wrote in message
...
The only purpose of an AutoNumber Field is to provide uniqueness to each
Record in the Table. Thus, the Table with only the AutoNumber Field
does
not have any useful information content.

Why would you want to create the Table without any meaningful info.
content?

Because the only attribute of this object is a multivalued attribute, so
the
actual information is in a join table which refers back to this main table
via a foreign key.

--
Tim Ward
Brett Ward Limited - www.brettward.co.uk

"Van T. Dinh" wrote in message
...
So you have another Field in this Table which is a ForeignKey Field???

No, I have another table which refers back to the autonumber field with a
foreign key.

--
Tim Ward
Brett Ward Limited - www.brettward.co.uk