Re: Display Form or MsgBox while query is running

Tech-Archive recommends: Fix windows errors by optimizing your registry

You could use the form timer event to animate a picture. I used it once,
totally usless function but I thought it was fun. I used a tiny police car
beacon with 3 overlaid images of it with the bright part in diffifent
postions and alternated visible with a case statement for the three
pictures. Looked like the light was revolving. You could do something with
a couple of text boxes or such. Might slow Access down a little but keeping
the picture/textbox small and the timer reasonable I didn't notice much.


"JimP" <j_pockmire@xxxxxxxxxxx> wrote in message
news:M-SdncZynOcsrMPUnZ2dnUVZ_rmdnZ2d@xxxxxxxxxxxxxxx
Thank you,

That works fine - if I want to kick it up and have a label on the form
blink (e.g. Gathering Data), is there a way to do this?

I can force the label to blink using the "OnTimer" event by simply opening
the form manually, but haven't found a way to force it to blink when the
query is running in the background.


"Albert D. Kallal" <PleaseNOOOsPAMmkallal@xxxxxxx> wrote in message
news:eN7Z0XObJHA.1328@xxxxxxxxxxxxxxxxxxxxxxx
"JimP" <j_pockmire@xxxxxxxxxxx> wrote in message
news:XrednRkgn8kQv8PUnZ2dnUVZ_v7inZ2d@xxxxxxxxxxxxxxx
I have a lengthy append query that runs when WindowHide is set to yes.
The problem is that users have no way of knowing that the query is
running because the status bar is not displayed.

How can I force a form to open before the query runs and then close when
it finishes without user interaction?

1. Simply opening the form before the query runs, partially loads the
form while the query runs.

Just open the form, but place a doevents right after.

Eg:

docmd.OpenForm "MyPleaseWaitMessageForm"
doevents

run long query here....

docmd.Close "MyPleaseWaitmessageForm",acForm

msgbox "done"


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx






.

Relevant Pages

  • Re: Clearing all fields with code problem
    ... In a saved query you could use the following as criteria ... The cards are assigned to staff in our building, so the card is either blank, I.e no one has that card or someone has the card and the record is filled in. ... There is only one table apart from several small tables that populate the drop down boxes. ... What code should I enter that will check if there is any thing to delete in my OLE picture field ...
    (microsoft.public.access.gettingstarted)
  • Re: Custom property data type
    ... an error that a date was expected, but with my "Date Picture Taken" ... >> window of Indexing Services and I am able to query by this file property ... >> what to set the datatype to in Property window on Index Server. ...
    (microsoft.public.inetserver.indexserver)
  • Re: More help with PHP menus? 2nd level ideas. (OT to some).
    ... because it is set to 20 chars, it doesn't stick out as in your picture ... search div. ... "The search input field should be wide enough to contain the typical ... query; if the box is too small, the query will scroll and diminish ...
    (alt.html)
  • Re: Adding a parent for existing child row. (typed datasets)
    ... see the query being generated by ado.net for you - chances are ... Specify your own query explicitly that ... A lot of users have not yet selected a picture, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Display Form or MsgBox while query is running
    ... That works fine - if I want to kick it up and have a label on the form blink ... query is running in the background. ... but place a doevents right after. ...
    (microsoft.public.access.modulesdaovba)