como eu uso esse codigo pra buscar o codigo na tabela lancamento e o campo da tabela e lanc
Function ProximoNumero()
'criado por Alexandre Neves
'em 2010-10-23
'para Assis
'do fórum MaximoAccess
Dim Rst As DAO.Recordset
If DCount("*", "ProducaoBloco", "DataBloco=#" & Format(Me.DataBloco, "mm-dd-yyyy") & "#") = 0 Then
Set Rst = CurrentDb.OpenRecordset("SELECT DISTINCT DataBloco FROM ProducaoBloco WHERE Year(DataBloco)=" & Year(Me.DataBloco) & ";")
If Not Rst.BOF Then Rst.MoveLast: Rst.MoveFirst
proximoNumero = Year(Date) & Format(Rst.RecordCount + 1, "0000")
Else
proximoNumero = DLookup("Producao", "ProducaoBloco", "DataBloco=#" & Format(Me.DataBloco, "mm-dd-yyyy") & "#")
End If
Set Rst = Nothing
End Function
Function ProximoNumero()
'criado por Alexandre Neves
'em 2010-10-23
'para Assis
'do fórum MaximoAccess
Dim Rst As DAO.Recordset
If DCount("*", "ProducaoBloco", "DataBloco=#" & Format(Me.DataBloco, "mm-dd-yyyy") & "#") = 0 Then
Set Rst = CurrentDb.OpenRecordset("SELECT DISTINCT DataBloco FROM ProducaoBloco WHERE Year(DataBloco)=" & Year(Me.DataBloco) & ";")
If Not Rst.BOF Then Rst.MoveLast: Rst.MoveFirst
proximoNumero = Year(Date) & Format(Rst.RecordCount + 1, "0000")
Else
proximoNumero = DLookup("Producao", "ProducaoBloco", "DataBloco=#" & Format(Me.DataBloco, "mm-dd-yyyy") & "#")
End If
Set Rst = Nothing
End Function