Auto Number

[Mr2006]

I would like to create custom autonumber that will contain the following:

firstletter from firstname
first letter from lastname
dateof birth.

John Smith 04/05/2008
JS04052008

How can I go about doing this?

Thanks

 

[dhookom]

I would create a small function or sub in the form module like:

Function UpdateCustAuto() as boolean
    Me.txtCustAuto = Left(Me.txtFirstName & " ",1) & _
        Left(Me.txtLastName & " ",1) & _
        IIf(IsNull(Me.txtDOB),"00/00/0000",Format(Me.txtDOB,"mmddyyyy")
End Function

You can then call this function from the after update event of the other controls.


Duane
Hook'D on Access
MS Access MVP

 

[dhookom]

oops,

Function UpdateCustAuto() as boolean
    Me.txtCustAuto = Left(Me.txtFirstName & " ",1) & _
        Left(Me.txtLastName & " ",1) & _
        IIf(IsNull(Me.txtDOB),"00000000",Format(Me.txtDOB,"mmddyyyy")
End Function

Duane
Hook'D on Access
MS Access MVP

 

[Mr2006]

dhookom,

will this be for a form after update event...

 

[dhookom]

Probably work better in the Before Update. Test it and report back.

Duane
Hook'D on Access
MS Access MVP