Results 1 to 3 of 3
  1. #1
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419

    Disable progress bar, right corner of Access when loading data into access table

    I load excel data into access table by using this bottom code.



    Code:
    DoCmd.TransferSpreadsheet acImport, ,"table", file, true, "Sheet1!"
    a progress bar appear really quickly that shows the loading.
    It's there away to disable or not show the progress bar until the data is loaded and then to turn it back on ?

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

  3. #3
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    Ok - but how do you hide it programmatically then turn it back on just when you need it (for other portion of the program) ?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 14
    Last Post: 07-30-2017, 05:25 PM
  2. Replies: 0
    Last Post: 03-18-2017, 03:40 AM
  3. Replies: 14
    Last Post: 08-23-2014, 12:35 PM
  4. Replies: 9
    Last Post: 03-20-2013, 11:41 AM
  5. Replies: 3
    Last Post: 05-20-2009, 04:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums