View Single Post
  #4 (permalink)  
Old January 16th, 2004, 02:08 PM
jrwlkn jrwlkn is offline
Authorized User
 
Join Date: Dec 2003
Location: Middletown, CT, USA.
Posts: 81
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Since they all have 'code' in front of them you can use an InStr() function to determine the position of the word 'code'...then use that position to mark the coordinates for the mid() string function. I am assuming that all the item codes have the same number of characters.
Let me know how you make out or if you need some coding help.

John

Reply With Quote