[b][red]This message was edited by the ctx at 2002-3-5 13:37:13[/red][/b][hr]
I have been having trouble with NULL. When I read data into the array "OutputArray," sometimes one of the fields is an empty field. The snippet below then reads the data from OutputArray into a table called "act_contacts." The array is a variant array and the fields in the table are "dbText", whatever that is.
Whenever one of the empty fields is read into act_contacts, I get the following error, which stops execution:
Runtime error '3315': Field "act_contacts.Name" cannot be a zero-length string.
Does anyone know how I can get rid of this error message and read in fields that are empty from a variant array to a table?
Set rstContacts = CurrentDb.OpenRecordset("act_contacts")
Do While (count <= LastRecord)
objContact.GetDataEx CntInfoArray, OutputArray
'Sequentially add all ACT contacts to the temporary table
rstContacts!UniqueID = CVar(OutputArray(0))
rstContacts!Name = CVar(OutputArray(1))
rstContacts!Company = CVar(OutputArray(2))
rstContacts!Phone = CVar(OutputArray(3))
rstContacts!State = CVar(OutputArray(4))
count = cunt + 1
If objContact.IsEOF Then