Stack Overflow
Stack Overflow

Questions tagged [autonumber]

158 questions
1
vote
2 answers

Excel VBA : Auto numbering

I'm creating a database on Excel, and encountered some problems as I tried to assign auto number to each row. Requirements are: generate auto number to each row(on the column A) when column B is not blank. the number should be unique and must…
hanae
  • 11
  • 1
  • 2
1
vote
1 answer

Auto Number Php form field

I have a php form where I add entries to a mysql database. I am trying to have the number field on the php form be automatically numbered. So, instead of having to type in the number myself for each entry, it would appear in the number field box…
vinman64
  • 55
  • 1
  • 10
1
vote
1 answer

How to make auto numbering on UITextview when press return key in swift

When user press [Return] key then need to display the number. Like serial numbers [1,2 etc] for each line.Is there any way to do that? Following code I tried func textView(_ textView: UITextView, shouldChangeTextIn range: NSRange, replacementText…
Lydia
  • 2,017
  • 2
  • 18
  • 34
1
vote
2 answers

changing autonumber field to number datatype

Is there any way to change the autonumber field to a number datatype, when the field is used a primary key and linked to other tables?
lamcro
  • 6,069
  • 18
  • 57
  • 70
1
vote
1 answer

Getting the most recent autonumber field from another table

I have 2 tables: tblInvoice (InvoiceID (pk), Invoice) tblLineItem (LineItemID (pk), InvoiceID) I have 2 forms "Main Menu" and "Shop." On the "Main Menu" form, when you click the btnNext, it will generate the autonumber for InvoiceID in tblInvoice,…
Ron T
  • 397
  • 1
  • 4
  • 22
1
vote
1 answer

InfoPath autonumbering

I was working on a project, basically it's using MS InfoPath to design a form. I am currently facing an issue with the autonumbering. Here is the scenario: User submits a form (ID: 1) Admin receives the form (ID: 1) - correct Admin edits the same…
Blake Kong
  • 35
  • 6
1
vote
2 answers

How to get custom autonumber?

I am trying to get custom autonumber from a autonumber. But, when there is some data in the database table it runs smooth and when there is no data in database table it gives me error. Private Sub CustomNo() Dim comm As OleDbCommand Dim…
Tarak Bhavsar
  • 145
  • 2
  • 13
1
vote
3 answers

Get Autonumber from newly inserted record in Access 2007 using Enterprise Library 4.1

It's been ages since I last used Access as a back end but I'm being forced to. I'm using Enterprise Library 4.1, the Data Access Application Block.. with .NET 3.5 and I wanted to know the best way (code sample if possible) to write an insert query…
GR7
  • 5,083
  • 8
  • 48
  • 66
1
vote
2 answers

Autonumbering Rows in mysql view in cycles

Hi I am trying to achieve rows auto numbering in cycles in a mysql view. I did start with Pure-SQL Technique for Auto-Numbering Rows in Result Set and got it to work. Then I tried tweaking it and got ALMOST there.... and now I am stuMainmped the…
Paola Maggi
  • 21
  • 5
1
vote
1 answer

How do I give an SQL field an autovalue as a string (SQL Server)?

I want insert multiple records into a table and I want the primary key to start as ITS0001 and then increment by 1 for each record. For example: Record 1 = ITS0001 Record 2 = ITS0002 Record 3 = ITS0003 Record 4 = ITS0004 Record 5 = ITS0005 How can…
pgunston
  • 302
  • 6
  • 16
1
vote
1 answer

MS Access Sorting by Autonumber / Primary Key

I'm intrigued about sorting results in a select statement by an autonumber that's the primary key in the table. Ultimately I'm looking to select the most recent record from the table and notice that the execution time is significantly more when…
Gareth
  • 5,140
  • 5
  • 42
  • 73
1
vote
2 answers

Expression Too Complex Access 2007, how can I simplify this IIF sequence?

I am running the below complex statement to provide an value in Column "SODist" that increments for each successive matching value in the "SalesOrderNo" field. I use an "ID" as auto-number to simulate a "row number" function but I need to scale…
Mike Dowdal
  • 23
  • 5
1
vote
1 answer

Run-time error '-2147352567 (80020009)' No Current Record MySQL back-end DAO recordset

I upgraded back-end MS Access 2003 to MySQL 5.1 of a database. I am linking the backend MYSQL 5.1 database thr' ODBC (MySQL ODBC 5.1 Driver) to MS Access front-end .mdb. I am using DAO recordset. I add new record by using .AddNew method and update…
Sham Yemul
  • 463
  • 7
  • 30
1
vote
1 answer

Combine Access tables

Before you think this is a question that has already been answered, hear me out. I inherited an Access MDB file. It has 2 tables (actually 4 but I'm only really concerned with 2). One is a member table with an AutoNumber field. The second table has…
Ed Danley
  • 63
  • 9
1
vote
1 answer

Adding records with old ids that were generated using auto number in access

I have an access database. In this I have a table which had an auto number field that created the ids. I somehow deleted these ids in the table. Now that I have deleted these records, I need a same sequence to continue (I want the deleted ids back…
amir shadaab
  • 469
  • 3
  • 9
  • 23
1 2 3
…
10 11