Access 2000 Forms Programming

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

Is it possible to have both text and a counter number in
the same field?
E.G. We want to use a autonumber combined with text
INV001, INV002, etc.
 
Karen,
This is a commom question. ssearch these newgroups for discussions on
autonumber.
see "Re: Populate field with multiple data?" and "Re: Generating and
AutoNumber that increases by 2"


This is not a good approach in most cases. It is much simpler to use a
system where you have
two columns - ine holds the autonumber and the orher holds the type - INV
etc
in reports you could combine the two for display purposes.

HS
 
HSalim said:
Karen,
This is a commom question. ssearch these newgroups for discussions on
autonumber.
see "Re: Populate field with multiple data?" and "Re: Generating and
AutoNumber that increases by 2"


This is not a good approach in most cases. It is much simpler to use
a system where you have
two columns - ine holds the autonumber and the orher holds the type -
INV etc
in reports you could combine the two for display purposes.

HS
Click to expand...


But remember that Autonumber should not be used if you want to generate
sequential numbers!

Autonumber is designed only to provide a unique identifier for records
in a table. This is used internally by Access in building relationships
between tables according to your design. The actual values that
Autonumber delivers are unimportant and should never be exposed to
users or have any external meaning at all. Depending on the design and
use of the database, Autonumber will develop gaps, become
random and go negative.

For any number series that you want to control or have available
externally, you must design your own. There are several schemes
available depending on what you want to do.

hth

Hugh
 
Back
Top