I have a field in Ms access table which has data type = Long integer, now I want to use unbound form to update that field with a control not bound to a table how do I much the data type to Long integer
I'm gambling on Clng or CInt functions , for example CInt(Me.txtEsDFinInvoice) , represent the invoice number from Json string
What should I do in case to archive the same data type as per table (long integer) the complete data is being received via Json format that is I need the correct data type to avoid an overflow. Without fixing the data type correctly then I will risking loss of data
I'm gambling on Clng or CInt functions , for example CInt(Me.txtEsDFinInvoice) , represent the invoice number from Json string
What should I do in case to archive the same data type as per table (long integer) the complete data is being received via Json format that is I need the correct data type to avoid an overflow. Without fixing the data type correctly then I will risking loss of data
Code:
'Processing data from the string above
Set db = CurrentDb
Set Rs = db.OpenRecordset("tblEfdReceipts", dbOpenDynaset)
Set json = JsonConverter.ParseJson(strDataAudit)
Dim Z as integer
'Process data.
Z = 1
For Each Details In json
Rs.AddNew
Rs![ESDTime] = CDate(Format$(Details("ESDTime"), "00/00/00 00:00:00"))
Rs![TerminalID] = Details("TerminalID")
Rs![InvoiceCode] = Details("InvoiceCode")
Rs![InvoiceNumber] = Details("InvoiceNumber")
Rs![FiscalCode] = Details("FiscalCode")
Rs![INVID] = CInt(Me.txtEsDFinInvoice)
Rs.Update
Z = Z + 1
Next
Rs.Close
Set Rs = Nothing
Set db = Nothing
Set json = Nothing
Set Details = Nothing