Stack Overflow
Stack Overflow

Questions tagged [autonumber]

158 questions
1
vote
1 answer

Excel - how to get auto number in levelling columns?

I want to count on the data in same columns and restart the count if there have new data in upper level (say previous column), see my picture. I use the formula of counta, but the numbering is incorrect (say row 8 in…
win w
  • 13
  • 3
1
vote
0 answers

Save Customer Number From Form Text Field to Table

In an Access database I have a Customer table with a “CustomerNum” text field with the format ‘00001’ for example. This database had no autonumber field in the Customer table. I added “CustomerID”. However, all the coding in existing forms, queries,…
Dino52
  • 11
  • 2
1
vote
2 answers

change the serial number of letters by year

how to change the serial number of letters by year, I got the formula in microsoft excel but how to use the formula in googlesheet with the array method formula to those who understand please guide me, just an illustration of the formula I use in…
auto form
  • 23
  • 2
1
vote
3 answers

Access & SQL-Server: Resetting Autonumber field with table wipe

I am trying to keep a copy of an activity table synchronized between a SQL Server Express table and the production Access version. In other tables, I am able to wipe the contents of the SQL Server table, and insert the whole mess back in to capture…
Comrad_Durandal
  • 651
  • 2
  • 10
  • 23
1
vote
0 answers

Concurrency violation: the UpdateCommand affected 0 of the expected 1 records with autonumber fields

I am writing a small C# society membership app using Visual Studio 2008, and the new data layer with .Net 3.5, along with SQLite. I used the various wizards to generate my main form, which has a BindingNavigator and a BindingSource on it. The idea…
Nikki Locke
  • 2,759
  • 6
  • 29
  • 53
1
vote
2 answers

R: Using doBy with Dates

I am doing some coding in R. I am trying to use the doBy package to get a sum total score for a variable (x) by both date (date) and by id (id). The doBy command works fine and I get this output. data id date x 1 01/01/2021 1 1 01/02/2021…
Eric Boorman
  • 71
  • 7
1
vote
2 answers

Is there a way to have an integer autoincrement field in Mongo Db as part of a document/table different from the standard id?

We'd love to have an integer autoincrement field within a Mongo Db document / "table", possibly being different from the autogenerated and unique _id index. The purpose is to provide the users with a unique readable number, auto-incrementing itself,…
frandro93
  • 13
  • 1
  • 4
1
vote
1 answer

Autonumbering in Google Sheets Using Apps Script

I'm currently working with Google Forms and Appsheet to create a complaint tracking app for my company. This project requires that each complaint that is submitted via Google Form has a ComplaintID. The format for this ComplaintID is the current…
Melanie Moore
  • 13
  • 3
1
vote
1 answer

How to find the next ID auto number from access table and display the number in an Excel userform?

I would like take the next ID auto number from an access table and display it in a textbox on an excel userform. I have found this code and I've played around with it but I'm not getting anywhere and completely lost. I'd be grateful if someone could…
Matt
  • 31
  • 5
1
vote
1 answer

AutoNumeric JQuery Plugin not allowing to insert decimal point once focus loss

I am using jQuery autoNumeric plugin to format number automatically in currency. It's working fine and converts number to currency. But once i loss focus from field and again i go to that field at that time it's not allowing me to type decimal…
Anvesh
  • 309
  • 1
  • 8
  • 24
1
vote
1 answer

Adding Laika auto-numbering to top-level directory titles

I have the directory.conf: title = "SRLLab Manual" autonumbering { scope: all } navigationOrder = [ introduction multi-arm-bandits finite-markov-decision-processes ] In each of the sub-level directories I have a directory.conf and a…
user2051561
  • 838
  • 1
  • 7
  • 21
1
vote
1 answer

postgresql serial pk reverts to integer after restore

I built a db with serial type for the pks, I migrated to another server and the pk columns are now integer and as a result I cannot add new data due to the not null restriction of a pk. Is there any Alter command which can fix this?
Spatial Digger
  • 1,883
  • 1
  • 19
  • 37
1
vote
2 answers

vb.net MS Access insert record with auto number primary key column into table with SQL query

I want to insert a new row into a table with a auto number column. My code is below, I can't find out how to insert auto number column simultaneously with other columns: pth = My.Application.Info.DirectoryPath Dim SQL = "INSERT INTO approved (id,…
fahad
  • 35
  • 6
1
vote
2 answers

Do #anchors after urls affect ranking in seo?

While programming a new tabs-system in javascript, where each tab is clickable and has its own ancher text on it, it would be easier to make these anchors numbers #1 #2 #2 etx. On the other hand, its more difficult to make #text anchors, but if…
Sam
  • 15,254
  • 25
  • 90
  • 145
1
vote
1 answer

Access linked table to SQL Server: TinyInt incorrect mapping

I got a SQL Server PriceLists table: CREATE TABLE [dbo].[PriceLists]( [PriceListId] [tinyint] IDENTITY(1,1) NOT NULL, [PLName] [varchar](20) NULL, CONSTRAINT [PK_PriceLists] PRIMARY KEY NONCLUSTERED When I link it into Access 2007, Access…
iDevlop
  • 24,841
  • 11
  • 90
  • 149
1 2
3
…
10 11