Here is a revised edition for V8 - it uses a modified version of Alpha Sports
to use it - open it, goto Customers, and use the DemoLookup button
the FTP is only good for 14 days, so if you see this after 4/27/2007+14 email me at [email protected] and I'll email it to you.
it uses form CustomerLookup - note there is a shared form vaiable called bcol (browse current column) and that at the browses onarrive event, it sets the variable to the browses current column - and when changing columns it resets the variable.
all the action is in the form's onkey event. If you type "W" and then "I" in the Customer column, and then use for example the tab or right arrow key to change columns, it resets the query.
the salient feature is that it searches within the current field, not from left to right. It is especially helpful when looking up in fields where the values are cryptic - like in a partnumber field where the value was "R7-A24769b-Lugs-Boeing" and you had 5 parts that contained "Lugs" and 7 that contained "Boeing" - you could quickly find by searching for "lugs", scrolling, and Enter of DoubleClick. It works as is quite well where there are up to about 12 to 14 thousand records. For larger files, I set it to start looking on the 2nd or 3rd character entered.
http://www.yousendit.com/download/WUJiTkFuTmFxRTAwTVE9PQ
to use it - open it, goto Customers, and use the DemoLookup button
the FTP is only good for 14 days, so if you see this after 4/27/2007+14 email me at [email protected] and I'll email it to you.
it uses form CustomerLookup - note there is a shared form vaiable called bcol (browse current column) and that at the browses onarrive event, it sets the variable to the browses current column - and when changing columns it resets the variable.
all the action is in the form's onkey event. If you type "W" and then "I" in the Customer column, and then use for example the tab or right arrow key to change columns, it resets the query.
the salient feature is that it searches within the current field, not from left to right. It is especially helpful when looking up in fields where the values are cryptic - like in a partnumber field where the value was "R7-A24769b-Lugs-Boeing" and you had 5 parts that contained "Lugs" and 7 that contained "Boeing" - you could quickly find by searching for "lugs", scrolling, and Enter of DoubleClick. It works as is quite well where there are up to about 12 to 14 thousand records. For larger files, I set it to start looking on the 2nd or 3rd character entered.
http://www.yousendit.com/download/WUJiTkFuTmFxRTAwTVE9PQ
Comment