Questions tagged [autonumber]
158 questions
-1
votes
1 answer
Access VBA: how to get auto numbering on continuous form records
I have a form of view type "continuous forms" that is returning records based on a query, and I want the records to have a number label like 1, 2, 3.. in the order listed:
Is there any way to generate a label or textbox automatically there?
Any…
Shubham
- 949
- 6
- 21
- 29
-1
votes
1 answer
How to retrieve an autonumber value form MS Access datatable and convert it to int64
I want to retrieve an auto number value from the MS Access data table from column name "id" and convert it to Int64 in C# in asp.net. How can I do it
Kaise karen
- 1
- 1
-1
votes
1 answer
Value Always Set to 0 instead of 1 When Creating Auto-Generated ID in Netbeans
I'm trying to make unique auto-generated ID using combination of char, date, and value. This is my code :
int getValue;
public void generateNOS(String query) throws SQLException {
try {
Connection con = koneksi.koneksiDB();
…
wiryadev
- 1,089
- 1
- 11
- 33
-1
votes
2 answers
maximum records in access table
I recently run into the problem of reaching the maximum amount of records in my table, somewhere around 32567. I got an overflow error trying to access the records. I figured out how it could happen since I have only around 2000 actual records in…
Marco
- 85
- 1
- 14
-1
votes
1 answer
MS Access Creating a New Order And Orderline
I have a Customer table, an Order table, an Orderline table and a Product table. All of them have an Autonumber field as their primary key, and Orderline has a foreign key reference to Order ID on Order table:
ORDER
-----
Order ID - Autonumber …
Stephen Dean
- 1
- 2
-1
votes
1 answer
Autonumber in inputting new records
My patient number(pnum) need to have a autonumber, like BLHC-2014-0001. I need to automatically have the BLHC-current year-and auto increment of the number with 4 digits when i input new record.
-1
votes
1 answer
Automatic number insertion in MySQL with the format "AN-00000000"
My purpose on this is to insert a autonumber for this format AN-00000000 to the db, with the type in db varchar.
my code in windows form is saving a integer number already "10000000".
But I turn on my mind and think if possible that the auto number…
user3073146
- 3
- 2
-1
votes
1 answer
How I can Delete a row in Access with its ID number(autonumber)? in C#
coulmn count is autonumber
I want to Delete a row Where
"Where(Table1.count)='" + count1 + "'";
but I dont know what should be the type of count1 !!!
When I use
"Where(Table1.count)=9";
I dont have any problem & the row with id numbr 9 will be…
user2664591
- 23
- 4