Stack Overflow
Stack Overflow

Questions tagged [autonumber]

158 questions
0
votes
0 answers

Update the MS Access table using the ComboBox using a VBA to generate Auto Numbers

The idea is when a Number is provided in the combobox, the update query runs to update the table with the provided number of records. Ex: If 100 entered then 100 records should gets updated. And here is the Query. I have observed the query does…
CoderVen
  • 1
0
votes
1 answer

How I can use Autonumber in new screen multiple users in Acumatica?

I have a custom screen in Acumatica with autonumber, but only one user can use at the same time. How can get screen multiuser? In Sales Order/Payment and Applications I have a tab('COMPLEMENTOS'), in this tab you can add a new complement in other…
Alejandra Guerra
  • 13
  • 2
0
votes
0 answers

Unique AutoID for each row in google sheet that never changes even if I insert new rows

I found this code by searching google (https://blog.cloudstitch.com) and it works but I need to tweak it for two extra things: I need the number to be three digits - where in the code do I set the length? If I insert a row the ID will be a…
Jesper Kindt Larsen
  • 107
  • 3
  • 12
0
votes
1 answer

Autonumber value of last inserted row - MS Access / VBA (Value=0)

I need to get the Autonumbered ID of the last record inserted into a table (through INSERT INTO command) I have seen some methods in the forum that looks to work for most of the community but not in my case: Autonumber value of last inserted row -…
Master Piece
  • 1
  • 2
0
votes
2 answers

Pyspark Autonumber over a partitioning column

I have a column in my data frame that is sensitive. I need to replace the sensitive value with a number, but have to do it so that the distinct counts of the column in question stays accurate. I was thinking of a sql function over a window…
Keerikkattu Chellappan
  • 495
  • 1
  • 7
  • 16
0
votes
1 answer

How do I keep my auto generated number the same when a record is edited in MS Access?

I have code behind my Save button that generates a Change Request Number upon the record being saved. So let's say: I create Change Request 97 and save it. It writes to the table as Change Request Number 97. When I go back in to Edit it and…
Shileshia Milligan
  • 1
0
votes
1 answer

Latest Autonumeric is allowing decimal point even if decimalPlaces set to 0

I have requirement to allow whole numbers for the input textboxes, I do have the requirement to have currency symbol along with commas. I have used the latest version of autonumeric js. I have set the decimalPlaces property to 0 but still it is…
suryakiran
  • 1,976
  • 25
  • 41
0
votes
3 answers

VBA auto number cells that contain text

I am trying to find a solution for the following problem: column A contains names and I would like to keep those names there and use a code that will auto number them. Something like: I have looked at quite a few examples on StackOverflow but what…
RobertC
  • 51
  • 1
  • 7
0
votes
1 answer

Auto Number Format

I currently have an auto number field populated in the format "\E00000". After some thought I would like to change the auto number to the date that it is made (today's date) and then an incremented value after that, because there may be multiple…
Matt H
  • 147
  • 1
  • 13
0
votes
1 answer

Appending data to an indexed table

I'm attempting to append records to a table that has data indexed by an ID column. I'd like the appended data to continue that indexing and attach the next number to the first appended record and so on. However, that ID column is not an AutoNumber…
Katie
  • 105
  • 2
  • 12
0
votes
1 answer

MS Access - restricted, repeating auto-number

I'm trying to implement a restricted auto-number within multiple tables which can be used as common ground to facilitate work allocation. Currently I have a range of queries that select a number of pieces of work sorted by descending value. I'd like…
JamesMc
  • 3
  • 2
0
votes
1 answer

MS Access Second Autonumber Field Option or Workaround

I would like to add an AutoNumber field in an Access table but ID is already type Autonumber and is used for the index in the table. You can't have more than one Autonumber field in a table apparently. The use case is: Existing database of Clients…
MonoJoker
  • 1
  • 4
0
votes
1 answer

missing autonumbers in Access

I have a very basic database with only one main table and a few lookups - no relationships. the Autonumber field in the main table has little code associated with its form however I am noting that every 10 records or so it skips a number. I have…
Dude
  • 11
  • 4
0
votes
0 answers

Access Autonumber Format Not applying to my VB.NET Form

I am presently working on an application for a fictive taxi company, and I have to record each new customer with a customerID set as AutoNumber with a specific format: Field size : Long integer New Values : Increment Format : \C00 Indexed : Yes(No…
LaureLazard
  • 55
  • 7
0
votes
2 answers

Dynamics 365 implementation auto number with plugin

I have already implement auto number with plugin, and it is through another entity type to ensure all operations are in one transaction. but I have another question, that is can we use process lock(eg. mutex) to fix it? this will more flexible than…
Richard
  • 53
  • 7
1 2 3
…
10 11