Find Maximum Value of a Field and Add 1
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I made a form which is bounded to a table. The form or table has 2 fields named "points" and "free_time". The field "points" has a validation rule of <=300, which means - that field should have a maximum input value of up to 300 only. Now, what I was aiming for is to find a formula or code that when the field "points" reaches its maximum value which is 300, it will automatically add 1 (one) to another field called "free_time".
In simple terms 300 points = 1 free time, but I don't know how to make that happen in my form.
And if it's possible, after adding 1 to free_time, the field points would go back to zero since it cannot exceed the value
I am a beginer of access programming.
I have a problem in doing a task with my form.
Actually I have a button to add a new record which opens a new form there I enter the values to the record. But when I press the Addnew record button I want to calculate the maximum of the Identity field +1 and open the new form with that new number which I have calculated. How can I do this
Name | 2008 | 2009 | 2010 | 2012
Fred | 4 | 7 | 9 | 11
Joe | 11 | 22 | 3 | 323
I want to be able to calculate the minimum or maximum number for Fred. for all 4 years.
Everything works fine except I do not know how to add or reference a new detail row when a I move to the next record in the recordset, and as a result my form shows me one row for eachrecord repeating whatever data was in the ending record.
So my question is: How do I populate the detail row so that one detail row matches one record from the recordset.
Some background. Each unbound control in the detail section is named "Col" and then a sequential number. So I have Col1, Col2, Col3, etc to Colx (the maximum field the query can return.
I have done the same with the heading being Hed1, Hed2, etc to the maximum. Now I need to be able to reference Row1Col1, Row1Col2, Row1Col3, etc and then Row2Col1, Row2Col2,Row2Col3, etc to the maximum number of records.
It would need to go through every column and row.
If I have a field that has a maximum field length of 10 characters and the cell has data which is 5 characters - I need the remainder to be filled with 5 blank spaces if its a text cell.
If I have a field that has a maximum field length of 15 characters and the cell has data which is 2 characters - I need the remainder to be filled with 13 blank spaces.