ACC: How to Create a Multiuser Custom Counter (1.x/2.0) (88159)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
This article was previously published under Q88159
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
You can define a field as a counter in a Microsoft Access table. When you
define a field as a counter, Microsoft Access manages the numbering in the
field. When you add a record, Microsoft Access assigns the next available
value to the field. You have no control over this value.
You may want to use a unique counter that is not immediately sequential in
nature. For example, you may want to use a counter that decrements, or a
counter that steps according to some value.
This article demonstrates a sample user-defined Access Basic function that
you can use to create a custom counter field.
This article assumes that you are familiar with Access Basic and with
creating Microsoft Access applications using the programming tools provided
with Microsoft Access. For more information about Access Basic, please refer to the "Introduction to Programming" manual in Microsoft Access version 1.x, or the "Building Applications" manual in version 2.0.
Modification Type: | Major | Last Reviewed: | 5/9/2003 |
---|
Keywords: | kbhowto kbusage KB88159 |
---|
|