Special Filter? (1 Viewer)

Hey,

I have a table with a huge master list (some hundred thousand) of unique bar code tags, which either have 8 or 12 digits. (Valid characters are "0123456789ACEFHJKLMNPRYXW").

I created a form, which is automatically looking up valid records as the string is entered position by position from left to right. This is working fine and sufficient in 99% of the cases.

Sometimes characters are not readable on the original document, so I need a tool/form, were I can enter only the readable positions of the code and the tag list is then filtered accordingly.

For that, I created a separate form with 12 text boxes for each possible position of the bar code and a listbox. This list box should be filtered as the readable characters are entered in their respective positions/textbox.

Unfortunately, I did not get this filter to work yet. :banghead:

Any ideas, how to approach this problem? I tried the macro builder. Maybe it needs VBA?

Any help/leads will be greatly appreciated.

Best regards,
Maik

why use 12 boxes?, you could simply have one box and the user type a ? when the character is unreadable

See this link

http://msdn.microsoft.com/en-us/library/swf8kaxw.aspx

So if the user cannot read a couple of characters they may type

12?dfer?