Questions tagged [autonumber]
158 questions
0
votes
3 answers
Inserting into a Access DB with an AutoNumber PK and getting an Insert syntax error
I am trying to insert into a access db and the PK is an autonumber that is generated by the DB. I am getting a syntax error for the insert statement and dont know why. If possible I would like to return the autonumber value in the same statement.…
Sean P
- 949
- 4
- 22
- 41
0
votes
1 answer
C# get access 2010 autonumber
Hi I am submitting a form to access but want to get the access assigned auto number to display in a textbox after I submit. Below it was i have, any suggestions would be great!
string cmdstr = "Insert into …
hex c
- 705
- 2
- 13
- 22
0
votes
1 answer
MySql | table autonumber reverting to zero over time
I have a MySql 5.1.52 database with a table which has consistently forgotten its autonumber sequence and then subsequently started from 1 again. It can take hours, days or weeks for this reset to occur.
Some have suggested that its related to…
TheLegendaryCopyCoder
- 1,658
- 3
- 25
- 46
0
votes
2 answers
Copy/Paste records in Tables that have autonumber => same ID until refresh
I have a silly nuisance on an error.
I have access front end and sql back end.
In a form with a Record Source: Select * from ViewX(View of 2 tables each with autoID)
The problem is..I copy a row and paste it underneath..it works but the AUTOID…
AngelicCore
- 1,413
- 3
- 22
- 40
0
votes
2 answers
INSERT statement for AutoNumber field text box (Access)
I have a Windows form which has the following textboxes, and is displayed in gridview. The application is connected to an Access database using C#.
Companyid (autonumber)
CompanyName(shorttext)
TypeofCompany(shorttext)
How can I generate an…
Shrenik
- 1
- 1
0
votes
1 answer
Auto Number by Grouping Column in Oracle
Is there any oracle statement for my problem.
Eg. TableA has 2 columns : columnA and columnB
ColumnA ColumnB
-------------------
A WA
A WA
B WA
B WA
C WA
A CA
A CA
B CA
B …
Kop
- 3
- 1
0
votes
1 answer
Possible to continue using AutoNumber Type? (with Access frontend & SQL Server backend)
I feel like this has to be somewhat of a common question, however I cannot seem to find the answer via search, so here goes:
We just moved all of our tables to a SQL Server backend and are looking to continue using MS Access as a frontend because of…
Erik Kieling
- 3
- 2
0
votes
1 answer
Getting the ID(Autonumber) after the session saved in nhibernate?
Hi i am inserting a row of data into a table through nhibernate, how to get the Id(auto number)of the last inserted row? please help me...
Venkatesh
- 1
- 1
0
votes
1 answer
how to export register from a table with autonumber iD?
I have a database which all the tables have as ID a autonumeric field. I think that is the best option, but if I need to export data from a database to another, how can I do that? Because I can insert a value in the autonumeric fields.
Is a good…
Álvaro García
- 18,114
- 30
- 102
- 193
0
votes
2 answers
Insert rows into Access db from C# using Microsoft.Jet.OLEDB.4.0, autonumber column is set to zero
I'm using C# and Microsoft.Jet.OLEDB.4.0 provider to insert rows into an Access mdb.
Yes, I know Access sucks. It's a huge legacy app, and everything else works OK.
The table has an autonumber column. I insert the rows, but the autonumber column…
MindModel
- 822
- 1
- 10
- 22
0
votes
1 answer
How to insert new value autonumber by parameters to access
When I press insert, I receive the error: Syntax error in INSERT INTO statement
EmployeeID (Autonumber)
EmployeeName(Text)
Position(Text)
Address(Text)
OleDbDataAdapter ad;
DataSet ds;
DataTable dt;
protected void SetInsertParameters()
{
…
Sơn Phạm
- 21
- 4
0
votes
1 answer
Autonumber for document numbering request list
We have a scenario where a user requests an "autonumber" for documents.
There is a field where they select the "document type" when adding a new item to the list, which is a lookup field (doc_type) held in another list call…
user1579360
- 1
- 1
0
votes
1 answer
retrieve autonumber from ms access to a strongly typed database in vb.net
I am using VS2010/VB.NET/MS Access 2007
I had added a database from ms access to the vb.net application (strongly typed)
that table contains an autonumber field.
I made a button to add new row and another one to save the row the problem is that I…
Mina Nakhla
- 11
- 4
0
votes
6 answers
Generate serial number using letters and digits
I'm developing an application for taking orders in C# and DevExpress, and I need a function that generates a unique order number. The order number must contain letters and digits and has a length of 20 ..
I've seen things like Guid.NewGuid() but I…
NadaNK
- 782
- 2
- 10
- 26
-1
votes
1 answer
Looking for a VBA or Addin for Auto numbering text box in slides
enter image description hereFor educational purposes, I need a method or plugin that allows automatic textbox numbering.
I ran into solutions on this site stating that such a sequence is possible from the PowerPoint interface, but unfortunately this…
AAgamdi
- 1
- 1