If I have a field defined inan Access database to be an AutoNumber Field and i add a new record, is ther a way of access the newly generated number. I know the with sqlserver you can access the Gl...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10032780.html
Zones:
Visual BasicDate Answered: 12/20/1997 Grade: A Views: 0
I have a little students database, where the student number is the primary key.
I want the student number to be six digits where the first two digits are the last two digit of a year, and the othe...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10079176.html
Zones:
MS AccessDate Answered: 09/11/1998 Grade: A Views: 4
I need to be able to autonumber or perhaps increase an ID with a query so that I can automatically update an
alphanumeric number ie. A0001 to A0002 or A9999 to B0001 etc . . .that kind of thing. A...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10101858.html
Zones:
MS AccessDate Answered: 12/14/1998 Grade: A Views: 0
Hi, Everyone: I try to add an autonumber field into a my existing table. The problem is my table have about 100,000 records. Access only handle 9500 record at once. So any idea can resolve this pro...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10117594.html
Zones:
MS AccessDate Answered: 01/14/1999 Grade: A Views: 0
I need a field that has an autonmber created when a new record on a form is created that has a text prefix such
as DN-1000. After all entries has been made and the user
wants to create a new recor...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10120015.html
Zones:
MS AccessDate Answered: 01/22/1999 Grade: A Views: 0
I created a program in VB5. I am using MS ACCESS 97 as the backend with an ACCESS's AutoNumber as the Primary Index. In the VB program, I have created a RecordSet and use variables to get the new...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_10159401.html
Zones:
VB DBDate Answered: 05/10/1999 Grade: B Views: 0
I need to find a replacement(s)for Access 97's AutoNumber. The replacement needs to be automatic and incremental. I can utilize various ideas & object placements.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10162351.html
Zones:
MS AccessDate Answered: 03/17/2002 Grade: A Views: 0
I want to create a field, where the default value will be the last 2 digits of the year, and an AUTONMUMBER field.
So, for instance, the next def value would be
995061
I'm having some troub...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10223187.html
Zones:
MS AccessDate Answered: 11/27/1999 Grade: B Views: 0
Does SQL have an autonumber choice like Access or do you have to do it through your own code?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10242735.html
I want an AutoNumber field to start from a particular value.
Can any one suggerst how this can be done.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10290073.html
Zones:
MS AccessDate Answered: 02/07/2000 Grade: B Views: 0
