Topics Search

how to auto inset sequence number at column

how to auto inset sequence number at column
Views: 68
I have linktable from oracle. right now, We manual insert sequence number into column when input data. do we have any way (create form, or VBA program) to auto insert sequence number at column?

how to auto inset sequence number at column in linktable?

I am using 2007 access in window XP.
Sponsored Links:

More topics

 

Find missing number in 2 column sequence

Preview
I have a table that has a beginning and an ending column for a serial number range. I want to see if theres a way to know if a number is skipped in the sequence. I have searched for HOURS trying to find a solution to apply to my problem but none talked about a 2 column sequence.

so example would be Table1
Beg End
etc.

so is there a way to have access tell me that 13, 18, 19, and 20 is missing from this range
 

ID code not autonumber

Preview
I want to create an (8) digit number such as 20121234 (1st four are the year and the last four digits would be an auto number) how would I go about doing this. I am a new user to Access and I have built my (4) main tables and before I go create my forms sheets ect I want to get my "id" column creating the correct number sequence.
 

Autonumber with Date and Sequence Number-2

Preview
Perhaps you may be wondering, whey we need something different when there is an Autonumber feature already built-in into Microsoft Access? Well, the built-in feature may not be suitable for all situations, like Patient’s Unique Registration Numbers in hospitals, with change of date and sequence numbers. We have created a function earlier for generating auto-numbers with date and sequence numbers and you can have that from the first link given below. You may visit the other two links for some different approaches for generating Auto-numbers in Queries too.
 

Generating Sequence Numbers - Incrementation Question

Preview
I've got a list of over 2,000 unique ID's. These ID's are associated with specific projects. Trying to figure out a quick and easy way to generate sequence numbers that correspond with each ID.

The number of sequence numbers per unique ID will vary based on individual project capacity. Some ID's will have as few as 25 sequence numbers associated some as many as 100. Wouldresult in the following outcome if sequence #'s increment by 33.

Ex.
Where Unique ID = 1234500123; and Project Capacity = 25
Beginning with number 1234500123
Resulting Sequence Numbers: 1234500123, 1234500156, 1234500189, 1234500222, etc… ending with 1234500948

Where Unique ID = 1234500123; and Project Capacity = 100
Beginning with number 1234500123
Resulting Sequence Numbers: 1234500123, 1234500156, 1234500189, 1234500222, etc… ending with 1234503423

Ideally I'd be able take my existing table, look at all 2,000 plus values in the Unique ID column compare them to the Project Capacity column and spit out anew table of incremented sequence numbers.
 

Appending Records with a desired auto number in a table with Auto Number

Preview
Here is my issue. In a table with an Auto Number index some records have been deleted. I have been able to recreate them along with their original auto number. The problem is that I do not know how to append these records forcing the original auto number. I have tried changing the auto number field to a number field in the table, this works except I cannot change it back to auto number.

I am sure Im not the first with this question or issue. I did search through a couple hundred entries about auto number before I posted this question
 

Reverse Sequence of Numbers

Preview
I think the best way for me to ask the question is to explain the scenerio. Data is linked to an external source. Each time an event occurs (like a payday lets say), a new record is created and it is assigned a sequence number. (For argument sake, there is no set day or date that payday falls on.) Someone paid by the company two times would have two records, the first payday would be sequence # 1 and the second payday sequence # 2. Someone with the company multiple years could have 100 records or more. I am trying to isolate the highest sequence number for each employee. The highest number would indicate the latest event. I have utilized other software in the past and used a rank function which would reverse the numbers and then I could just filter for sequence = 1. Is there a way for me to do this in access
 

How to get the last value of an AutoNumber Column

Preview
I've a table that has 3 Columns:

Column A : Type - Auto Number.

Column B : Type - String.

Column C : Type - String.

The Current Data in the table is as follows:

1, "USA","Florida"
2, "USA, "Michigan"
3, "USA", "New York"

If a add new Row, the Column A, being Auto Number, takes my Count to 4 i.e.

4, "USA", "Texas"

Suppose I've deleted Row 3 and Row 4. The table data is now:

1, "USA","Florida"
2, "USA, "Michigan"

If I try to add a new Row, the Column A, being Auto Number, takes my Count to 5 (instead of 3). Its OK as Auto Number, by default, will follow this numbering.

My question is: Is there a way to programmatically figure out that my row is going to get added at 5, before I actually insert a row and figure it out by myself using @@Identity
 

How to get the last value of an AutoNumber Column

Preview
I've a table that has 3 Columns:

Column A : Type - Auto Number.

Column B : Type - String.

Column C : Type - String.

The Current Data in the table is as follows:

1, "USA","Florida"
2, "USA, "Michigan"
3, "USA", "New York"

If a add new Row, the Column A, being Auto Number, takes my Count to 4 I.e.

4, "USA", "Texas"

Suppose I've deleted Row 3 and Row 4. The table data is now:

1, "USA","Florida"
2, "USA, "Michigan"

If I try to add a new Row, the Column A, being Auto Number, takes my Count to 5 (instead of 3). Its OK as Auto Number, by default, will follow this numbering.
 

Converting time to decimal number

Preview
I need to convert time to a decimal number after I insert it. I have found a function to do that in a book.
Code:

Function IndT(T As Date) As Single
IndT = T * 24
End Function
Sub ConvertTime()
MsgBox IndT([fieldname])
End Sub


It works but it is not what I really need. I have a number field in a table and I want time to change to decimal number after I inset the time (for example 3:45 to 3,75). I don't need message box I need those numbers inset to the table.
 

Save record sequence number from form

Preview
I posted this earlier but it never appeared.
I have a continuous form that displays 4 fields from a table. The form also has sort buttons which sorts the records in the form based on the sort selected. My table also has a field called “sequence number”. Based on the sort that is selected I would like to save the record sequence number for each record based on the order that the records appear in the form. In other words the record that appears first in the form would have a sequence number of 1 stored for that record in the table, the second record would have a sequence number of 2, etc.