Stack Overflow
Stack Overflow

Questions tagged [autonumber]

158 questions
0
votes
2 answers

autonumber not distintc in access

Is it possible to create a table where two columns represent a primary key and one of them is autonumber but not distinct. Something like (teacherID,schoolID(FK),teacherName) where first two are primary key and first one is autonumber. When teachers…
Dragan Peric
  • 69
  • 1
  • 2
  • 9
0
votes
1 answer

Grouping then numbering by common number

I am exporting a parts list from a schematic program. I need to be able to sort in a specific order to group the components by type and then by part number. I have that figured out. What I need to do now is add a new number automatically that will…
patRc
  • 3
  • 2
0
votes
1 answer

resetting "Issue ID" in Sharepoint site

I designed a site in share point. There is a column called "Issue ID (linked to item)" in ALL Issues view. I am using this column to list and identify the items which are created by employees. It increases by 1 as a new issue is created.…
ephieste
  • 21
  • 2
  • 4
0
votes
2 answers

autonumber/rank by a column in access

I have a list of claim numbers and I want to add a ranking column that changes when there is a new claim number. If the claim number is the same, I want the ranking to go up by 1, but when there is a new claim number, I want the ranking to start…
Ayesha Soto
  • 27
  • 6
0
votes
2 answers

SQL Server Identity Column Renumbering

I have a table which has a primary key ID column and is set to increment 1 for each new entry, a fairly standard configuration. This table is updated regularly with new records, and is archived once a month to an archive table and then truncated. …
LegendaryDude
  • 562
  • 8
  • 23
0
votes
1 answer

Reset Autonumber in C# based on year and date using oracle database

i have auto generate number create automatically in C#. this sample like this PPP-150500001 , PPP-150500002 => PPP- is a string never change, 15 is a year, 05 is a date, and 00001 is auto generate number. How Can i reset auto number after get a new…
aminvincent
  • 553
  • 1
  • 12
  • 43
0
votes
0 answers

How can I change the autonumber field to increment differently?

I have a situation in which I need to make an "a" and "b" for each record. Long story short, it's for a report. Is it possible to change the auto number increment to increase by .5, or make a record "1a" and "1b"?
autumntiger
  • 105
  • 1
  • 13
0
votes
0 answers

MSAccess : Change AutoNumber field sequence after 99999 record each time

I can change the auto number field to hold sequence value like "A-1", "A-2" or "B-1", "B-2" by setting the format property of field but I want to change the sequence each time when records count reach to 99999 records. for example for first 99999…
user3826874
  • 1
  • 2
0
votes
2 answers

How to get auto number based on selected date

please help me to get auto number based on selected date? i have working code for auto number but that's only for today/current date. what i want is if date options selected then auto number generated based on the date selected... here is my sample…
dhanykoe
  • 17
  • 8
0
votes
1 answer

Resetting next sequence ID on SERIAL column

After committing a row with a SERIAL (autonumber) column, the row is deleted, but when another row is added, the deleted row's sequence ID is not reused. The only way I have found for reusing the deleted row's sequence ID is to ALTER the SERIAL…
Joe R.
  • 2,032
  • 4
  • 36
  • 72
0
votes
1 answer

Algorithm for setting the next AutoNumber for the table

I have a table called AutoNumber which have fields like Public Class AutoNumber{ int Id, Bool Autogenerate Book IsLocked, Int IncrementValue, String Prefix, String Postfix, int IdentityValue string ModuleName …
garyson ford
  • 71
  • 1
  • 5
0
votes
0 answers

Use AutoNumber Value as TempVariable in Access

I'm using Microsoft Access, I've got a form with three sub forms in. I want to use an auto number in the first field. Once I start entering data in the first record I'd like the auto number to set a temporary variable to use in the other sub forms.…
REdim.Learning
  • 655
  • 2
  • 14
  • 32
0
votes
1 answer

How to change the auto numbering id field to serial type in PostgreSQL

I have a Database which is migrated from MSSQL to PostgreSQL(9.2). This Database have 100+ tables, These table have autonumbering filed(PRIMARY KEY field), given below is an example for a table CREATE TABLE company ( companyid integer NOT NULL…
user3814846
0
votes
4 answers

Access Insert Query

I am using C# to write/read to an Access 2007 Database. The table is ID - AutoNumber [pkey] Fname - Text Lname - Text Address - Text The query string I Use is "Insert into TblMain (Fname,Lname,Address) Values…
tecno
  • 99
  • 1
  • 2
  • 9
0
votes
0 answers

Access 2007 Autonumber Incrementing Sporadically

I was hoping someone would be able to help with why one of my Access 2007 databases seems to be rather randomly assigning an autonumber as an ID. I understand that it's a unique number assigned automatically by access. My question is why has access…
Gareth
  • 5,140
  • 5
  • 42
  • 73
1 2 3
…
10 11