Loading info from Access as the application opens

Posted on 2007-08-02
Last Modified: 2010-04-23
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.
Question by:kiranboi
    LVL 2

    Expert Comment

    You can make a public recordset where you load the requered info into.
    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.

    LVL 27

    Accepted Solution

    One way to get around the delay is to have a splash screen first and have the data load in the background. then move on to your main app. form.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
    The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now