Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Informing a user a job is running (XP SP-2)

    Hello again!

    I have a program which will automatically create invoices at the start of a new month for customers, and for those who have the ability to auto deduct from their accounts, a transaction is also generated. The program itself runs very well, however, there is nothing telling the user when the job is selected, that is is running - only a message saying that it has completed.

    It is a short running program (maybe a minute), and I thought about using a timer control, but I would rather have a message stating that the program is processing, so there is something more visible for the user. I couldn't find anything within the msgbox control. Is there a way to accomplish this? I'm sure there is, I'm just not creative enough to find it.

    TIA
    Steve

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Informing a user a job is running (XP SP-2)

    You can do the following (inspired by <!mskb=96989>Microsoft Knowledge Base Article 96989<!/mskb>)

    1. Create a form with the following properties:
    <UL><LI>Record Source is empty (i.e. the form is unbound)
    <LI>Scroll Bars set to None
    <LI>Record Selectors set to No
    <LI>Navigation buttons set to No
    <LI>Border Style set to Dialog
    <LI>PopUp set to Yes
    <LI>Modal set to Yes[/list]Place a label on this form with the text you wish ("Please wait while your job is being processed" or something like that)
    Save the form as frmPleaseWait.

    2. Use the form this way:

    Sub ProcessJob()
    ' Open PleaseWait form
    DoCmd.OpenForm "frmPleaseWait"
    ' Force PleaseWait form to be drawn
    Forms!frmPleaseWait.Repaint
    ' Your code goes here
    ...
    ' Close PleaseWait form when finished.
    DoCmd.Close acForm, "frmPleaseWait"
    End Function

  3. #3
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Informing a user a job is running (XP SP-2)

    I was so tunnel-visioned looking for a way to get a msgbox to work for this, I didn't think about a form (Though I wouldn't have come up with all the property setups). This looks like an awesome solution. I will give this a whirl and keep this idea stored for future use!!

    Thanks again!! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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