Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IIf(Month([EntryDate])>=10,Year([EntryDate])+1,Year([EntryDate])).
- Private Sub CreateProjNo_Click()
- Me.Sequence = Nz(DMax("[Sequence]", "Projects"), 0) + 1
- DoCmd.RunCommand acCmdSaveRecord
- End Sub
- =[EntryFiscalYr] & Format([Sequence],"000")
- Me.Sequence = Nz(DMax(“[Sequence]”, ”Projects”,”[EntryFiscalYr]) = “ &(Me.[EntryFiscalYr])),0)+1
- Me.Sequence = Nz(DMax(“[Sequence]”, ”Projects”, ” [EntryFiscalYr] = ‘“ & Me.[EntryFiscalYr] & “’”),0)+1
- Private Sub CreateProjNo_Click()
- Me.EntryFiscalYr = IIf(Month([EntryDate]) >= 10, Year([EntryDate]) + 1, Year([EntryDate]))
- Me.Dirty = False
- If IsNull(Me.Sequence) Then
- Me.Sequence = Nz(DMax("[Sequence]", "Projects", "[EntryFiscalYr] = " & Me.[EntryFiscalYr]), 0) + 1
- Me.Dirty = False
- End If
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement