Fairport
asked on
VB - Pocket Access - Database App. - Help Needed
We're just starting out. Trying to write our Pocket PC version of a program which we have currently running like a dream on Palm.
Problem: filling combo boxes with data from a Pocket Access table... the .AddItem function is taking too long. Any ideas/workarounds. or ... Are there database aware components out there? Like a LookupCombo component.
Our testing shows that reading data from the Pocket Access tables isn't the time problem. So it seems to be isolated the Fill (.AddItem) function.
Problem: filling combo boxes with data from a Pocket Access table... the .AddItem function is taking too long. Any ideas/workarounds. or ... Are there database aware components out there? Like a LookupCombo component.
Our testing shows that reading data from the Pocket Access tables isn't the time problem. So it seems to be isolated the Fill (.AddItem) function.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We have sorted the problem out here actually...
The answer was to hide the Combo Drop Down List component while running the AddItem Loop then make it visible again when filled.
Thanks for the SQL 2000 tip ...!!