Custom Autonumber

Hello everyone,

How would I go about creating a "custom autonumber routine"?

Any comments would be helpful!

Thanks!
Evan McCutchen
evan AT radiologyonesource DOT com

Evan,

If I understand correctly what you are after, the answer depends on how you
add records to the table. So, if records are added manually, you can do it
on the data entry form; if they are imported from an external source, you
can use a calculated field in an append query. More specifically:

Form: you can use the Default Value property of the control bound to the PK
field, or you can use some code fired by the On Current event of the form,
and allowed to run when NewRecord = True.

Append Query: you can use Access built-in finctions in a calculated field,
or a custom function (written in code).

If you post more details on what you are trying to do, you will get more
specific help.

HTH,
Nikos



"Evan McCutchen" wrote in message
...
Hello everyone,

How would I go about creating a "custom autonumber routine"?

Any comments would be helpful!

Thanks!
Evan McCutchen
evan AT radiologyonesource DOT com

Nikos,

I was actually looking for the information about the form. Thanks for your
assistance... that was just what I was looking for! I have problems thinking
outside of the box when it comes to access.

Again, thanks for your help!
Evan McCutchen
evan AT radiologyonesource DOT com

"Nikos Yannacopoulos" wrote in message
...
Evan,

If I understand correctly what you are after, the answer depends on how
you
add records to the table. So, if records are added manually, you can do it
on the data entry form; if they are imported from an external source, you
can use a calculated field in an append query. More specifically:

Form: you can use the Default Value property of the control bound to the
PK
field, or you can use some code fired by the On Current event of the form,
and allowed to run when NewRecord = True.

Append Query: you can use Access built-in finctions in a calculated field,
or a custom function (written in code).

If you post more details on what you are trying to do, you will get more
specific help.

HTH,
Nikos



"Evan McCutchen" wrote in message
...
Hello everyone,

How would I go about creating a "custom autonumber routine"?

Any comments would be helpful!

Thanks!
Evan McCutchen
evan AT radiologyonesource DOT com