Results 1 to 4 of 4
  1. #1
    TexMax007 is offline Novice
    Windows Vista Access 2000
    Join Date
    Aug 2009
    Posts
    4

    Accessing Code For a Query

    Hello Everyone,



    I have a report that I run which takes quite a while to complete. It runs 3 or 4 queries.

    I would like to have some indication of progress being made so the user doesn't think their computer has frozen.

    The progress bar that microsoft provides does not suit my needs, as it's very sporadic.


    One of my queries is a make-table.

    I would like to display the number of rows the query has built thus far on my form (to show the user there is progress).

    However, I'm not sure how to do this because I can't figure out how to access the VB code for the query (to imbed my code for the form update).

    Also, I don't know how large the table is going to be before-hand.


    Any help with this would be greatly appreciated.

    Thanks,

    Max

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You are going to have problems here because Access is single threaded. Running queries and keeping a Progress Bar moving is probably not going to happen.

  3. #3
    TexMax007 is offline Novice
    Windows Vista Access 2000
    Join Date
    Aug 2009
    Posts
    4
    Yeah, I was afraid of that, that's why I wanted to kind of embed the progress code in the query code itself so that it would be executed as if it were part of the original query to begin with.

    Thanks for your input though, I appreciate it.

    Max

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The best you could do is run a query and when its done then advance the progress bar. Then run another query and when its done advance the progress bar again.

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

Similar Threads

  1. Accessing my inventory remotely
    By Steven in forum Access
    Replies: 2
    Last Post: 02-27-2010, 11:56 AM
  2. Accessing form controls
    By dante in forum Forms
    Replies: 15
    Last Post: 07-28-2009, 08:26 AM
  3. Accessing subform fields
    By nkenney in forum Forms
    Replies: 1
    Last Post: 04-21-2009, 10:10 PM
  4. code help for updat query
    By Grant in forum Queries
    Replies: 1
    Last Post: 01-31-2008, 05:53 AM
  5. Using SELECT query within a VBA code in Access
    By championss in forum Programming
    Replies: 4
    Last Post: 10-23-2006, 05:50 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