Recent content by joannk

Thanks, I actually fiquired out.... I used the following Private Sub Save_Click() If IsNull(Me![Number]) Then Me![Number] = Format(Nz(DMax("[Number]", "[UCCPermit]", "Year([Date1])= " & Year(Me.Date1) & " AND " & "[ts code]= '" & Me.[TS Code] & "'"), 0) + 1) End If Me![PermitNo] =...

Hello, all I am setting up a database that maintains permits issued. I want to be able to created a permit no. based on the year issued and the township. my permit id no is setup as follows: ex 2012bu-1 with the first 4 being the year the second a township code and the last the current number...

Hi, I have dowloaded the code to use in my database, and I must be missing something, because I can not get this to work.. I actually, need the number to reset based on year and permit code, I am attaching my database. Can anyone tell me what I did wrong. I know that I do not have the permit...