Do you absolutely need to have a field in each table with autonumbering?
If I dont what are the consequences?
Is there a way to make it so that AutoNumbering uses a formula that you came up with?
IE. I want to use a letter an ID month year and a sequence (quote #1, #2, #3 etc)
I have a table with an autonumber as pk. it has reached 67378 and now has started wanting to add records back from 1 again. The newest record want to start from 19 ( I guess as i attempted to add records from a recordset it used up numbers from 1 to 18 and ditched them).
I obviously could never add records again now. so what should I do, using the tool fix database did nothing.
as the field is an autonumber with long int is there a maximum size due to number of bits used to store?
help would be much appreciated.
I noticed on other tables it did the same went from a number to suddenly adding very large autonumbers out of sequence.
regards
Peter
Hello,
I 'm pretty new to access and I am trying to divide number of courses into groups automatically e.g if i have 80 students on a programme i want to divide them into groups and each group must have a maximum of 20 students.It could be less but not more.
Please any help will be highly appreciated.
Thanks
I am using DMax function for my custom autonumber
I just realized that when using this in a multi user environment, I am getting duplications.
This field is not the primary key, and I am using this as a group ID and cannot set it to “no duplications”
My form also has a sub form, and when entering the sub form, the main record gets saved automatically.
First I added the following procedure
Private Sub Form_AfterInsert()
If IsNull(Me.OrderNo) Then
Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1
End If
Private Sub cmdSave_Click()
If IsNull(Me.OrderNo) Then
Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1
End If
However, I then realized the after insert function will add the new autonumber to the form. However, it will not saved it to the table until the main record is saved again (which may not happen)
“DoCmd.RunCommand acCmdSaveRecord” doesn’t seems to be working after the “Form_AfterInsert”
Now I moved the code to the “Form_BeforeUpdate” (still testing)
Does anyone have any experience on this problem?
Thank you
Joe
I have some data that I import them to Access into a predefined table. The first colum of this data is A/A (lets say from 1-500). I do this in order to validate some data. The problem is that when I want to delete one row (lets say row 99) then the numbering is left as it is (.....97, 98, 100, 101.....). It ignores the fact that number 99 is missing. I want when I delete one record to start recounting from the begining (1-499).
I want the same thing when I enter a new value in the table. Lets say to enter a raw in the meddle of the table (lets say in position 65) to change the entire countin of the first column.
Thanks in advance.
Hi
I am trying to autonumber a field in a form so that it should have a value of 1 more than the highest value in the field.
I am trying to use the following formula.
DMax("[SAMPLE]","BUGSAMPLE")+1
where sample is the name of the field and bugsample is the name of the table.
but everytime I exit the form. the value in the form field becomes 1 while the value in the table field remians the fine.
What else I can do to fix this problem.
Also I cannot change the field in the table to autonumber as there are a lot of relationship already with that field.
Regards
Rahul