Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Give control back to a form so it can update itself during my subroutine.

Posted on 2003-11-26
5
Medium Priority
?
334 Views
Last Modified: 2006-11-17
Can't remember the statement.

In short, within a routine I run three different queries. I open a form to give the status of the routine to the user.


i.e. (pseudo code)

sub a
   open form "myMsgBox"
   msg = "performing query 1"
--->......what is the code that I should put here?
   open query1
   msg = "performing query 2"
--->......what is the code that I should put here?
   open query2
   msg = "performing query 3"
--->......what is the code that I should put here?
   open query3
end sub


What is the statement that I would use to give control back to the form allowing it to update.

I searched the EE db and couldn't run find an answer.  I think the code is something like doSysEvent or something.

P.S.  Pls help me do it this way.  I don't want to use the status bar or any other method.

Thanks,
Robert
0
Comment
Question by:rgcole
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 32

Expert Comment

by:jadedata
ID: 9827896
Hey rgcole!

  msgbox comes to mind, because I presume you're delivering the messages one at a time.
  if not....

  You need to open a separate form in popup mode that has an unbound textbox and concant the message to the popup form's text box as each query runs separated by a dbengine.idle and a forms!MyPopup.repaint

  Having this code in the form open would require the routine to run completely before giving over control to the form presentation.

regards
Jack
0
 
LVL 9

Author Comment

by:rgcole
ID: 9828015
I am opening a form "mymsgbox" and filling it in with different messages as the routine proceeds.  But, while in the routine the form didn't draw itself perfectly.

There is a call I believe that gives control back to Access so it can do some housekeeping to maybe complete the drawing of the screen.



Robert
0
 
LVL 32

Accepted Solution

by:
jadedata earned 500 total points
ID: 9828046
dbengine.idle
doevents
and .repaint

would all force the issue.  sometimes ya just need a bigger hammer...

The one I wouldn't expect to see repainting would be the form_Open calling form
0
 
LVL 9

Author Comment

by:rgcole
ID: 9828132
-j-,
Thanks.

I used DoEvents.  All the necessary updating of the screen now occurs.

Robert
0
 
LVL 32

Expert Comment

by:jadedata
ID: 9828160
good to go!  When you comin back to the TOP 15??
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

722 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