Stack Overflow
Stack Overflow

Questions tagged [autonumber]

158 questions
0
votes
0 answers

Power Automate: How to generate autonumber for every batch of new items in a sharepoint list

Here is the process that I wish to give autonumbers which i would like to call ATSUB# and ATT#: ATSUB#0001 and ATT#0001-01. ATSUB Email is received and comes with attachments that ranges from 1 PDF and up. I already setup a Sharepoint list with the…
VeeEss
  • 33
  • 5
0
votes
0 answers

Autonumbering in YAML file

I have following YAML file with disrupted numbering: aaa: bbb: ccc: 1: ddd: '123' eee: '123' fff: 'abc' ggg: 'abc' hhh: '123' 4: ddd: '123' eee: '123' fff: 'abc' …
user 01072021
  • 11
  • 1
0
votes
0 answers

1) I want to auto update a field value by client ID. 2) Also want to update a value in a field in a table when someone creates new record in another

Please be kind. I am retired and new to Access. I am helping a friend set up a simple(ish) database for their charity, and while I can manage the simpler stuff, I have run into a couple of problems. I have a Client Master table- keyed on Client ID…
Jdubya
  • 1
0
votes
0 answers

How can I avoid duplicate records with autonumber ID and how to increment autonumber ID sequentially in access?

I have an input table (including input ID and Input fields) and a type table (including typeID and type fields) where there is one to many relationship between them (one type ID to many inputs)... InputID and typeID are the primary keys and…
user16465317
  • 1
  • 1
0
votes
1 answer

How to retain the AutoNumber of a Primary Key when executing a query in MS Access?

I am trying to do something like the following in a query: Dim rs As RecordSet Dim NewPrimaryKey as Long Set rs = Currentdb.OpenRecordset("SELECT * FROM MyTable WHERE MyPrimaryKey Is Null;") With rs .AddNew NewPrimaryKey =…
Curtis Inderwiesche
  • 4,940
  • 19
  • 60
  • 82
0
votes
1 answer

Dynamics365 - adding a new auto-number field to an existing entity and fill its values

I need to add a new "auto-number" field to an entity in Dynamics365 CE. Thanks to Jonas Rapp's excellent XrmToolbox "Auto Number Manager", adding the field and defining its look is a breeze. My challenge is: I have 100'000+ existing rows in that…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
0
votes
2 answers

How to make autonumber restart every year in Laravel/PHP?

I made code like this in Models Number_npe: public function nomor_akhir() { $query = DB::table('nomor_npe') ->select('*') ->orderBy('id','DESC') ->first(); return $query; } Then the Controllers: public function…
Ranmouri
  • 1
  • 3
0
votes
1 answer

Update Table and Add New Primary index Column

I have a gradebook DB and when I calculate the averages, I dump them into a table in a different DB using the cSQL Statement below. I have two issues - one, I cannot update the new table because it has no primary key. Two, I am trying to add a…
Michael Allen
  • 21
  • 4
0
votes
1 answer

How to create a custom autonumber in ms access form using VBA?

I have a primary key field named "Code" in my Products table. I also have a form for that table. I need to auto generate the "Code" in the form like GK01, GK02 and so on. I have tried the Dmax function but it didn't work maybe because the "Code"…
Nashid Iftekhar
  • 63
  • 7
0
votes
2 answers

The auto numbering/bullets of the Source MS Word document do not automatically align with those of the Destination MS Word document

It happens when a user inserts a Word Document(Source) into another Word Document(Destination) - auto numbering/bullets didn't work... I wont to insert text here, and continue auto-numbering of source as it in destination: Step 1 But it inserting…
Andrey Bogatyrev
  • 31
  • 3
0
votes
3 answers

How to increment Numbers With Decimals and Restart Numbering When Number Changes?

I want to increment the decimal part of a number and restart numbering every time the number changes as below 1.00 1.01 1.02 1.03 1.04 1.05 2.00 'Restart With 2 2.01 3.00 'Restart With 3 3.01 3.02 …
Meho2016
  • 25
  • 5
0
votes
2 answers

How to generate an autonumber using jsp?

I want code in jsp or javascript which will generate numbers serially and automatically when ever registered by the user.
Samiksha
  • 1
  • 1
0
votes
1 answer

How can I still use autonumber in an Access table if it has existing data and we cannot lose the numbers that are there now?

I'm in a real crunch here. We have a table with existing data, over 100K records. It has an integer primary key that was Autonumbered. Please don't ask, we had to do some merging and re-importing. Long story short, Access won't let me change that…
David Britz
  • 117
  • 1
  • 3
  • 9
0
votes
3 answers

AutoNumbering in Visio and PPT

Is there a way to autonumber when you open up visio or ppt? I need a number to count on the slide in ppt and in a shape in visio. I have tried insert excel that has a macro that will do what I want it to do but I can't get it to work when you open…
user688011
  • 1
  • 1
0
votes
2 answers

How do I prevent creating a new record in MS Access 2010 before the current record is correctly saved into the table

Situation I've created a database for making invoices and similar documents. As we know these documents must be numerated progressively and univocally without any missing number from one invoice (or other document) and the following. For this reason…
willy wonka
  • 1,440
  • 1
  • 18
  • 31
1 2 3
…
10 11