Customized ID Nos

As you have seen before, I have several tables of contact numbers in my
database. For each table, I want to put in a customized ID beginning with
the name or short description of the table. For example, the newspaper table
would begin with an ID of nwp1, nwp2 and so on for each record in the table.
Another example would be govt1, govt2, govt3, etc for each record in the
table. These tables have no autonumber ID now or any type of ID.

My intention is to append each table to a comprehensive table and connect
them relationally. This means each table id will be in the comprehensive
table and joined.

How do I make customized IDs?

If I have seen before that you have several tables, etc. I have forgotten
it. If you are seeking help it's best not to send people on a search for
the problem.

You could add an autonumber field, which will number in the order you want
for your existing records. Then, change the data type to Number, and
increment it for new records with something like the method he
http://www.rogersaccesslibrary.com/d...berProblem.mdb

I can't even guess what you mean by appending the records into a
comprehensive table and connecting them relationally. I can say that each
table should contain information about a single entity. For instance, in a
school database Students and Courses need to be in separate tables.

"faxylady" wrote in message
...
As you have seen before, I have several tables of contact numbers in my
database. For each table, I want to put in a customized ID beginning with
the name or short description of the table. For example, the newspaper
table
would begin with an ID of nwp1, nwp2 and so on for each record in the
table.
Another example would be govt1, govt2, govt3, etc for each record in the
table. These tables have no autonumber ID now or any type of ID.

My intention is to append each table to a comprehensive table and connect
them relationally. This means each table id will be in the comprehensive
table and joined.

How do I make customized IDs?

Please see the previous posting under faxylady. Thanks.

"BruceM" wrote:

If I have seen before that you have several tables, etc. I have forgotten
it. If you are seeking help it's best not to send people on a search for
the problem.

You could add an autonumber field, which will number in the order you want
for your existing records. Then, change the data type to Number, and
increment it for new records with something like the method he
http://www.rogersaccesslibrary.com/d...berProblem.mdb

I can't even guess what you mean by appending the records into a
comprehensive table and connecting them relationally. I can say that each
table should contain information about a single entity. For instance, in a
school database Students and Courses need to be in separate tables.

"faxylady" wrote in message
...
As you have seen before, I have several tables of contact numbers in my
database. For each table, I want to put in a customized ID beginning with
the name or short description of the table. For example, the newspaper
table
would begin with an ID of nwp1, nwp2 and so on for each record in the
table.
Another example would be govt1, govt2, govt3, etc for each record in the
table. These tables have no autonumber ID now or any type of ID.

My intention is to append each table to a comprehensive table and connect
them relationally. This means each table id will be in the comprehensive
table and joined.

How do I make customized IDs?

The data in each table will be appended to a large, massive table. Each
record will have a different ID.

"BruceM" wrote:

If I have seen before that you have several tables, etc. I have forgotten
it. If you are seeking help it's best not to send people on a search for
the problem.

You could add an autonumber field, which will number in the order you want
for your existing records. Then, change the data type to Number, and
increment it for new records with something like the method he
http://www.rogersaccesslibrary.com/d...berProblem.mdb

I can't even guess what you mean by appending the records into a
comprehensive table and connecting them relationally. I can say that each
table should contain information about a single entity. For instance, in a
school database Students and Courses need to be in separate tables.

"faxylady" wrote in message
...
As you have seen before, I have several tables of contact numbers in my
database. For each table, I want to put in a customized ID beginning with
the name or short description of the table. For example, the newspaper
table
would begin with an ID of nwp1, nwp2 and so on for each record in the
table.
Another example would be govt1, govt2, govt3, etc for each record in the
table. These tables have no autonumber ID now or any type of ID.

My intention is to append each table to a comprehensive table and connect
them relationally. This means each table id will be in the comprehensive
table and joined.

How do I make customized IDs?

Do I put this formula =Dmax["ProductID", "Product"]+1 in the criteria row of
a query? I did this and got an error message saying The expression you
entered contains invalid syntax or you need to enclose your text data in
quotes. You may have entered an invalid comma or omitted quotation marks...
I looked up your reference and followed your directions as to creating an
autonumber field, then changing the data type to number. Then I entered the
expression from your reference in the criteria row, hit run and got this
error message. Please help. Thanks.

"BruceM" wrote:

If I have seen before that you have several tables, etc. I have forgotten
it. If you are seeking help it's best not to send people on a search for
the problem.

You could add an autonumber field, which will number in the order you want
for your existing records. Then, change the data type to Number, and
increment it for new records with something like the method he
http://www.rogersaccesslibrary.com/d...berProblem.mdb

I can't even guess what you mean by appending the records into a
comprehensive table and connecting them relationally. I can say that each
table should contain information about a single entity. For instance, in a
school database Students and Courses need to be in separate tables.

"faxylady" wrote in message
...
As you have seen before, I have several tables of contact numbers in my
database. For each table, I want to put in a customized ID beginning with
the name or short description of the table. For example, the newspaper
table
would begin with an ID of nwp1, nwp2 and so on for each record in the
table.
Another example would be govt1, govt2, govt3, etc for each record in the
table. These tables have no autonumber ID now or any type of ID.

My intention is to append each table to a comprehensive table and connect
them relationally. This means each table id will be in the comprehensive
table and joined.

How do I make customized IDs?

On Sat, 15 Jul 2006 18:33:01 -0700, faxylady
wrote:

Do I put this formula =Dmax["ProductID", "Product"]+1 in the criteria row of
a query?

Reread the reference. Bruce did not suggest that syntax or anything
resembling it.


John W. Vinson[MVP]

In the database from Roger's site is the suggestion to put that expression
into the default value property of a text box bound to that field. The
default value comes into play only for a new record. Once the record has
been saved (by moving to another record, for instance, the number is a part
of the record unless you specifically change it. Syntax aside, using the
top value plus one as the criteria must logically fail, as far as I can see.

"faxylady" wrote in message
...
Do I put this formula =Dmax["ProductID", "Product"]+1 in the criteria row
of
a query? I did this and got an error message saying The expression you
entered contains invalid syntax or you need to enclose your text data in
quotes. You may have entered an invalid comma or omitted quotation
marks...
I looked up your reference and followed your directions as to creating an
autonumber field, then changing the data type to number. Then I entered
the
expression from your reference in the criteria row, hit run and got this
error message. Please help. Thanks.

"BruceM" wrote:

If I have seen before that you have several tables, etc. I have forgotten
it. If you are seeking help it's best not to send people on a search for
the problem.

You could add an autonumber field, which will number in the order you
want
for your existing records. Then, change the data type to Number, and
increment it for new records with something like the method he
http://www.rogersaccesslibrary.com/d...berProblem.mdb

I can't even guess what you mean by appending the records into a
comprehensive table and connecting them relationally. I can say that
each
table should contain information about a single entity. For instance, in
a
school database Students and Courses need to be in separate tables.

"faxylady" wrote in message
...
As you have seen before, I have several tables of contact numbers in my
database. For each table, I want to put in a customized ID beginning
with
the name or short description of the table. For example, the newspaper
table
would begin with an ID of nwp1, nwp2 and so on for each record in the
table.
Another example would be govt1, govt2, govt3, etc for each record in
the
table. These tables have no autonumber ID now or any type of ID.

My intention is to append each table to a comprehensive table and
connect
them relationally. This means each table id will be in the
comprehensive
table and joined.

How do I make customized IDs?

Maybe something went wrong with my download. Somehow, I missed this
information. I visited the site you suggested, but found only minimal
information, including the statement I quoted. I will check again. thanks.

"BruceM" wrote:

In the database from Roger's site is the suggestion to put that expression
into the default value property of a text box bound to that field. The
default value comes into play only for a new record. Once the record has
been saved (by moving to another record, for instance, the number is a part
of the record unless you specifically change it. Syntax aside, using the
top value plus one as the criteria must logically fail, as far as I can see.

"faxylady" wrote in message
...
Do I put this formula =Dmax["ProductID", "Product"]+1 in the criteria row
of
a query? I did this and got an error message saying The expression you
entered contains invalid syntax or you need to enclose your text data in
quotes. You may have entered an invalid comma or omitted quotation
marks...
I looked up your reference and followed your directions as to creating an
autonumber field, then changing the data type to number. Then I entered
the
expression from your reference in the criteria row, hit run and got this
error message. Please help. Thanks.

"BruceM" wrote:

If I have seen before that you have several tables, etc. I have forgotten
it. If you are seeking help it's best not to send people on a search for
the problem.

You could add an autonumber field, which will number in the order you
want
for your existing records. Then, change the data type to Number, and
increment it for new records with something like the method he
http://www.rogersaccesslibrary.com/d...berProblem.mdb

I can't even guess what you mean by appending the records into a
comprehensive table and connecting them relationally. I can say that
each
table should contain information about a single entity. For instance, in
a
school database Students and Courses need to be in separate tables.

"faxylady" wrote in message
...
As you have seen before, I have several tables of contact numbers in my
database. For each table, I want to put in a customized ID beginning
with
the name or short description of the table. For example, the newspaper
table
would begin with an ID of nwp1, nwp2 and so on for each record in the
table.
Another example would be govt1, govt2, govt3, etc for each record in
the
table. These tables have no autonumber ID now or any type of ID.

My intention is to append each table to a comprehensive table and
connect
them relationally. This means each table id will be in the
comprehensive
table and joined.

How do I make customized IDs?

Did you download the sample database?

"faxylady" wrote in message
...
Maybe something went wrong with my download. Somehow, I missed this
information. I visited the site you suggested, but found only minimal
information, including the statement I quoted. I will check again.
thanks.

"BruceM" wrote:

In the database from Roger's site is the suggestion to put that
expression
into the default value property of a text box bound to that field. The
default value comes into play only for a new record. Once the record has
been saved (by moving to another record, for instance, the number is a
part
of the record unless you specifically change it. Syntax aside, using the
top value plus one as the criteria must logically fail, as far as I can
see.

"faxylady" wrote in message
...
Do I put this formula =Dmax["ProductID", "Product"]+1 in the criteria
row
of
a query? I did this and got an error message saying The expression you
entered contains invalid syntax or you need to enclose your text data
in
quotes. You may have entered an invalid comma or omitted quotation
marks...
I looked up your reference and followed your directions as to creating
an
autonumber field, then changing the data type to number. Then I entered
the
expression from your reference in the criteria row, hit run and got
this
error message. Please help. Thanks.

"BruceM" wrote:

If I have seen before that you have several tables, etc. I have
forgotten
it. If you are seeking help it's best not to send people on a search
for
the problem.

You could add an autonumber field, which will number in the order you
want
for your existing records. Then, change the data type to Number, and
increment it for new records with something like the method he
http://www.rogersaccesslibrary.com/d...berProblem.mdb

I can't even guess what you mean by appending the records into a
comprehensive table and connecting them relationally. I can say that
each
table should contain information about a single entity. For instance,
in
a
school database Students and Courses need to be in separate tables.

"faxylady" wrote in message
...
As you have seen before, I have several tables of contact numbers in
my
database. For each table, I want to put in a customized ID
beginning
with
the name or short description of the table. For example, the
newspaper
table
would begin with an ID of nwp1, nwp2 and so on for each record in
the
table.
Another example would be govt1, govt2, govt3, etc for each record in
the
table. These tables have no autonumber ID now or any type of ID.

My intention is to append each table to a comprehensive table and
connect
them relationally. This means each table id will be in the
comprehensive
table and joined.

How do I make customized IDs?

What I downloaded appeared to be a database. When I clicked on it, the above
discussed information came up.

Since I found a way to get the customized ID and thought I had joined each
iD to the ID in the BIGtable, why aren't the records being deleted from the
BIGtable when I delete them from the individual tables? In order for this to
happen, does the ID have to be an autonumber?

"BruceM" wrote:

Did you download the sample database?

"faxylady" wrote in message
...
Maybe something went wrong with my download. Somehow, I missed this
information. I visited the site you suggested, but found only minimal
information, including the statement I quoted. I will check again.
thanks.

"BruceM" wrote:

In the database from Roger's site is the suggestion to put that
expression
into the default value property of a text box bound to that field. The
default value comes into play only for a new record. Once the record has
been saved (by moving to another record, for instance, the number is a
part
of the record unless you specifically change it. Syntax aside, using the
top value plus one as the criteria must logically fail, as far as I can
see.

"faxylady" wrote in message
...
Do I put this formula =Dmax["ProductID", "Product"]+1 in the criteria
row
of
a query? I did this and got an error message saying The expression you
entered contains invalid syntax or you need to enclose your text data
in
quotes. You may have entered an invalid comma or omitted quotation
marks...
I looked up your reference and followed your directions as to creating
an
autonumber field, then changing the data type to number. Then I entered
the
expression from your reference in the criteria row, hit run and got
this
error message. Please help. Thanks.

"BruceM" wrote:

If I have seen before that you have several tables, etc. I have
forgotten
it. If you are seeking help it's best not to send people on a search
for
the problem.

You could add an autonumber field, which will number in the order you
want
for your existing records. Then, change the data type to Number, and
increment it for new records with something like the method he
http://www.rogersaccesslibrary.com/d...berProblem.mdb

I can't even guess what you mean by appending the records into a
comprehensive table and connecting them relationally. I can say that
each
table should contain information about a single entity. For instance,
in
a
school database Students and Courses need to be in separate tables.

"faxylady" wrote in message
...
As you have seen before, I have several tables of contact numbers in
my
database. For each table, I want to put in a customized ID
beginning
with
the name or short description of the table. For example, the
newspaper
table
would begin with an ID of nwp1, nwp2 and so on for each record in
the
table.
Another example would be govt1, govt2, govt3, etc for each record in
the
table. These tables have no autonumber ID now or any type of ID.

My intention is to append each table to a comprehensive table and
connect
them relationally. This means each table id will be in the
comprehensive
table and joined.

How do I make customized IDs?