X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> From Refresh During Queries, Access 2013    
post Jul 17 2019, 09:48 AM

Posts: 1,009
Joined: 27-July 05

Woud you be able to provide an example?
Go to the top of the page
post Jul 18 2019, 11:29 AM

UtterAccess VIP
Posts: 4,725
Joined: 5-June 07
From: UK

do you mean me?

this is the osrt of code layout you use. It's more coding than simply docmd.openquery, but gives you control of the process.


declare and open a recordset

while not recordset.eof

  process record

  'code block to show progress, or anything else
  'goes here


so now you are processing each record of the query individually. The DoEvents relinquishes control to the OS, and you can do other things in the background. eg - click other forms, which can give a friendlier interface, but you have to be careful not to interfere with the query process.

If you want to update other information within the process, you can do this within the loop. You might find the DoEvents helps in allowing the display to refresh.

Dave (Male)

(Gemma was my dog)
Go to the top of the page
2 Pages V < 1 2

Custom Search

RSSSearch   Top   Lo-Fi    23rd August 2019 - 06:35 AM