Results 1 to 2 of 2

Thread: [MSAccess] [VBA] Status of query

  1. Feb 28th, 2011, 01:09 PM #1
    thechazm
    thechazm is offline

    Thread Starter
    New Member
    Join Date
    Dec 2010
    Posts
    12

    [MSAccess] [VBA] Status of query

    I have a major update that the users can run to update priority numbers and all the other junk.

    My question is can I use vba to provide an active status of the update queries that run. It takes them a while so I thought if I could I would like to show whats going on.

    The code at this point is not to important I just don't know which way to go with this. Use docmd.runsql, open db.execute, or adodb/dao database connection... Can't seem to narrow down which way to go to provide a status.

    What I would like to see is: Record 27/13000 Updated and then just keep counting through as its updating. If it has a progress bar it has to get the value's from somewhere right?

    Thanks,

    TheChazm
    Reply With Quote Reply With Quote
  2. Mar 1st, 2011, 05:57 PM #2
    jdc2000
    jdc2000 is offline
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,399

    Re: [MSAccess] [VBA] Status of query

    Possibly useful link:

    http://www.mrexcel.com/forum/showthread.php?t=233681
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width