Create own Auto ticket number

[Steven.Ashby82]

Hi All

I've searched the net for whether this is possible and I'm still a little unsure,

I want to create an Auto generated ticket number along the lines of AV13****(obviously the * would be the incrementing number)

It's for a Fault Log that I'm creating.

Kind Regards

 

[pr2-eugin]

Steven, this is a similar case of DMax Plus 1, a method implemented by RainLover in this forum.. Check it out.

 

[Steven.Ashby82]

I've had a look but I was trying to have the process automated Much like Auto Number but where I could specify the number as having letters and year followed by the number.

 

[pr2-eugin]

You can automate the process.. Have you gone through the code on how it works? It uses DMax()..

If you want it automated, then you will do that in the Form Current method, see if it is a New record if so, then you create the Ticket ID, using the DMax function..Something like..

Private Sub Form_Current()
    If Me.NewRecord Then
        'do your string generation
    End If
End Sub