On 3/3/2011 2:09 PM, Mike Copeland wrote:
> Thanks Mike! I'll try that. Hell, I'll try anything.
>
> The "WHILE !EOF('temp')" is an old habit that makes it easier for me to
> read the code and grasp what is going on.
>
> As for the 23,000 items...I'm in an odd situation with a client that
> involves both technical-computer issues and my competency, and political
> issues with a new co-owner. The new co-owner is, for want of a better
> term, frothing at the bit to dump my app and me and bring in his "guy."
>
> I've approached the fact that having 23,000 SKUs available at all times
> is way over the top (they could easily get by with 7,000), and the code
> does run faster with fewer SKUs in the pie, but using that as the
> solution is going to be used as another brick in the wall in the
> political situation.
>
> And, I have to confess that it just rubs me wrong that my app is running
> great until Windows 7 becomes an issue. Suddenly I'm thinking like a
> curmudgeon...."Why can't we all go back to Windows NT?"
>
> I'll let you know about the impact from the code tweaks, if any. Thanks
> again!
>
> Mike
You might try a simple textbox that checks the SKU entered in the Valid
event, and if an exact match is not found, then show a list of partial
matches in a pop-up form and let him pick there from a much-lesser
populated, focused list. Then, back on the first screen, show the part
description in a label next to the valid SKU chosen.
Just a thought.
Good luck!
--Mike
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/4d7005bf.7090...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
