Search results for query: *

I don't know that it's necessary for me to have all of those tabs, but my main problem at this point is to be able to parse the fields for any one particular record and put them on a tab as a text field, piece of a grid, anything. Can you help with that? TIA! :-)

I'm attempting to create an HL7 (an EDI format) parser. The following is an example of the data: MSH|^~\&|AMR18||SCH06||20040524140917||SIU^S12^SIU_S12|4561|P|2.3.1|| SCH||1275381|||||GAKL2||10|MIN|^^^20040524003500|SSMITH^SMITH^STEVEN...

I have the following piece of code attempting to update an Access field: While Not rst.EOF If rst![CASEUPC] Is Null Then valueA = rst![CASEUPC] .Edit rst![chkCASEUPC] = StripString(valueA) .Update End If .MoveNext Wend When...

Oh, I see. In other words, the type mis-match wasn't with regard to two fields being incorrectly compared, but with the DAO-type resultset being passed back to an ADO-type object? If your answer is yes, Thanks for changing the context without telling me, MS! :-) Or am I wrong and this is...

Believe it or not, I fixed everything by changing the following two lines: Dim DB As Database Dim rsQueries As Recordset to Dim DB As DAO.Database Dim rsQueries As DAO.Recordset Do any of you have any idea why this is? I'm stumped.

BTW, sSQL evaluates to: SELECT UPC FROM APP_PRC_PRODUCT_UPC WHERE (PRODID=52) AND (PRIMARYUPC='Y'); When I put that into a query in Access, it runs fine. For some reason, doing it programmatically comes up with a type mis-match.

Folks, I have a function being used to return a UPC I'm looking up in another table. When I run it, I get a "type mismatch" error. Can you help me spot the error or give me tips on how to diagnose what the problem is? I'm not sure what is "mismatching", you see. PRODID...