The contents of the data being parsed is just plain text. It's a combination of numbers and words, with each section of data separated by a semicolon as I mentioned. I have attached some of my code below. In fact there are more cases and fields that are being populated, but the total amount doesn't really matter because it operates just the same.
Code:
sLongCode = txtScan
iFld = 1
i = InStr(sLongCode, ";")
While i > 0
sWord = Left(sLongCode, i -1) ' Get next fld in string
sLongCode = Mid(sLongCode, i+1) ' Reduce string
Select Case iFld
Case 1
txtA = sWord
Case 2
txtB = sWord
End Select
i = InStr(sLongCode, ";")
iFld = iFld +1
Wend
I am new to Access, but I was trying to start a new record once my "iFld" reached a certain value. That made sense to me, but it didn't work. I am familiar with Excel VBA, but determining the functions for Access VBA has been a bit of a struggle. OR... I guess I could use another delimiter such as an asterisk within the dataset and search for that?
Hope this helps!