Questions tagged [autonumber]
158 questions
0
votes
3 answers
Access 2013 Increment a text ID field in a form
I have created a database from an excel file, one of the columns (PK) is the license number however this is in text format XX/XX/XXXX
When a new record is created I would like the form to auto-populate the license number field with a similar ID…
Luke Gatt
- 169
- 1
- 2
- 12
0
votes
1 answer
Access: A query that resets the autonumbering
My database is made for skiing competitions. The idea is that you can fill in the times people ski, and the databse automatically calculates what kind of medal you earned based on someone who set the time first, your gender and your age. I have made…
Raptor-ZH
- 17
- 1
- 1
- 6
0
votes
4 answers
Are there issues with tables using an autonumber as a primary key in a back-end ms access db?
I inherited an MS Access database at my office that is heavily used by several people over the network. This causes many issues with data collisions and locks. I want to split the db so that each user has thier own front-end app and maintain the…
owlie
- 179
- 1
- 3
- 9
0
votes
1 answer
DB2 unique index and autonumbering
Having gotten an answer to a Java problem I had last week (thanks!), I'm now on to a new problem with DB2... The Java app I'm working on takes data from a web form and puts in in a DB2 file (database). The SQL string that is passed to the Java…
Sam
- 129
- 3
- 12
0
votes
2 answers
Specify Serial No. in mysql while function
while ($one = mysql_fetch_array($two)) {
Want Serial No Here
friendishan
- 299
- 1
- 3
- 9
0
votes
2 answers
Order by Total For Sum function used
'" . strtotime($time1) . "' AND date<'" . strtotime($time2) . "' GROUP BY user_id");
while ($order =…
friendishan
- 299
- 1
- 3
- 9
0
votes
1 answer
My AutoNumber Code Does Not Work
Can anyone help me here? I am trying to do a user defined autonumber when I click on a button. The code worked fine when the recordset is empty, it give me a 1 on my first record, however, after I click on the button again, it give me 1 again.…
Clifford
- 1
0
votes
2 answers
Ms Access, using Excel to modify tables; dealing with ID autonumber
TLDR: I summarized the long question at the end of the question.
My business is using an Ms Access DB properly set with relationships, PKs, and FKs. I sometimes have to make major modifications to tables (adding fields, conducting column operations,…
Vincent Labrecque
- 304
- 1
- 5
- 12
0
votes
0 answers
Autonum changed when insert a register in middle of table
I've detected a change in the way autonums are being managed in access. May be due to de access verions.
Till Access 2003, when I insert a record in the middle of a table that uses autonum key to create new record, the autonum counter keeps its…
Kaikus
- 1,001
- 4
- 14
- 26
0
votes
1 answer
autoNumeric not working as expected
alert($('input[type=text]#A_CLAIM_AMT1').val());
$('input[type=text]#A_CLAIM_AMT1').autoNumeric('init',{vMin:'0.00',vMax:'99999999999.99',aSign:'',aSep:',',aPad: false,mDec:'2',aDec:'.'});
alert($('input[type=text]#A_CLAIM_AMT1').val());
I am using…
osama yaccoub
- 1,884
- 2
- 17
- 47
0
votes
1 answer
How to specify Microsoft Access auto number prefix value based on user selection
I am currently experimenting with Microsoft Access and was curious how one would accomplish this.
I know that one can add a prefix to an autonumber in the format option such as "EMP"000, and each autonumber would fill as EMP001, EMP002, and so…
Born2Discover
- 133
- 13
0
votes
1 answer
Assigning autonumber to HTML form entry
I have searched everywhere, but nothing I find seems to help solve this. I have a html web form (in a PHP document) that writes data to a CSV file, and below the form is a table that filters the CSV data back in based on a key word. I have no…
breanne_arline
- 57
- 1
- 1
- 7
0
votes
2 answers
Derive Autonumber based on value from another column in SQL
I have a SSIS package which has Stored procedure feed in the backend.I have to derive the autonumber logic for this ChannelName.
My current code is:
IF @p_channelname ='ABCD'
BEGIN
;WITH CTE_AUTONUMBER_PV_AMER AS
(SELECT…
Aiswarya
- 37
- 7
0
votes
2 answers
Custom user autonumber
I have been searching for a solution to this autonumber problem that I am having. There seems to be no definite answer anywhere.
I have a form which has a text field.
I want this form to display the next number from a field in a table.
Example: the…
saranmc
- 5
- 4
0
votes
1 answer
assign sequential number to each set of duplicate records
I've been searching for an easy solution to a pretty trivial problem. I have an huge set of records (~120,000) that I need to screen for duplicates, assign a sequential number to each set of duplicates, like Assign# below:
Eventually, I am trying…
Shtork
- 1
- 1