Recent content by jr_00_22

Yes this record number is not necessary and is used only for an attribute of the form. However this is how we refer to records, as record number 08-007 and so on. This number may/may not be used for a query in a report but it does need to be seen on the form. If my boss tells me to get incident...

I need more help. I fixed my last problem but my boss would like to see something different. He has asked me to make the record number dependant of the date value from low to high. This means that if you have one record on 1/1/2008 @ record number 08-001 and the next on 1/9/2008 @ record number...

Ok I got something that works, used a simple IF statement. Private Sub Text1_AfterUpdate() If IsNull(Me.Text8) = True Then Me.Text2 = Format([Text1], "yy") Me.Text3 = DMax("[Rec# part 2]", "Table1", "[Rec# part 1]= '" & Forms!Form1!Text2 & "'") + 1 If IsNull(Me.Text3) = True Then Me.Text3.Value...

Sorry for the late reply it took me this long to get this. This is what I've got. Private Sub Text1_AfterUpdate() Me.Text2 = Format([Text1], "yy") Me.Text3 = DMax("[Rec# part 2]", "Table1", "[Rec# part 1]= '" & Forms!Form1!Text2 & "'") + 1 If IsNull(Me.Text3) = True Then Me.Text3.Value = "1"...

I am in need of a custom record number in a form to be stored in my table. I would like it to act like an autonumber howerver I need it to read "00-000" or in order would be "08-001","08-002","08-003" and so on, where "08" represents the year and "003" represents the record number. Futhermore I...