invoice number
Hi,
don't forget the last argument adLockPessimistic after the ",". In fact the
whole statement "rst.open" till "adLockPessimistic" is one statement. The
"_ " sign makes it possible to continue on the next line. The last argument
probably is put on a next line by the text editor of the newsgroup, but
should continue on the same line.
Tip: while typing the code, in a lot of cases, the VBA editor shows the
possible arguments.
--
Kind regards
Noëlla
"cjgav" wrote:
Hi,
That reference was already checked .
I've checked the table name and all the field names and I still receive a
syntax error in this line:
rst.Open "select inrLastUsed from tblInvoiceNumbers where inrType = """ & _
strType & """ and inrYear = " & Year(Date), cnn, adOpenKeyset,
Regards
|