kiranboi
asked on
Loading info from Access as the application opens
Hi all,
In my app I have a LinkLabel that, when clicked, opens a lookup form which pulls a series of records from an Access tbale and adds them to a listview on the lookup form.
The first time I open this form it takes a little while to load because there are so many records in the access table but every time I open it after that it loads instantly.
I need to be able to load the information into memory when the application starts so that the lookup form opens instantly even when first clicked on.
I have tried opening the lookup form with its visibility turned off as my app loads and then auto closing it once the data has been loaded but that didnt make a difference. Can someone suggest a way I can achieve this.
Thanks.
In my app I have a LinkLabel that, when clicked, opens a lookup form which pulls a series of records from an Access tbale and adds them to a listview on the lookup form.
The first time I open this form it takes a little while to load because there are so many records in the access table but every time I open it after that it loads instantly.
I need to be able to load the information into memory when the application starts so that the lookup form opens instantly even when first clicked on.
I have tried opening the lookup form with its visibility turned off as my app loads and then auto closing it once the data has been loaded but that didnt make a difference. Can someone suggest a way I can achieve this.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This records set can be recognized in whole the program.
You can load it in main.bas first and after that you can load the Main form for the first time.