Recent content by catsoncars

There are usually no separaters other than a space. And the text is inconsistent. I am not even guaranteed a fixed order of the three fields. That is why I need to compare them to the lookup tables to see if it is a valid field.

I am not guaranteed there will be a dash, I just have to look for the value as a match. I can't use a delimiter.

sample record coming in....this is one text field called TxIncoming "AXD - CI4 - VF99 - noticing several issues with the JHG spreadsheets" we have 3 lookup tables containing a list of different codes. AXD, AXE, AXF, ACG, etc. (keyno) CI4, CA5, CA3, etc. (partno) VF89, VB99, VF84, etc...

In an access database, data is imported daily from an external system. One of the fields in question is a text field and contains information that I would like to parse out to specific fields. I have picklists for each of these specific fields. Using VBA how would you match the list to a...

The very first WIIncidentID has 5 rows, it loaded the WI IncidentID but nothing in the CombWorkInfo. If there was only 1 row for anWIIncidentID then it populated the CombWorkInfo also but if multiple rows, only the WIIncidentID was populated.

My first post and I am pretty clueless so be nice (: I have a recordset Set rst = db.OpenRecordset("SELECT qryWorkInfoText.WIIncidentID, qryWorkInfoText.WIText FROM qryWorkInfoText;") The WIIncidentID is just a alphanumeric number and WIText is a string. I need to take multiple rows of...