Showing Form while process runs

[RLN]

Re: Access 2003

I have a process that sends out emails to addresses (internally in our
company). Form1 has all the main functionality/data, etc on it. When
the user clicks "Send Emails" on Form1, I change my cursor to an
hourglass when it starts and change it back to normal when finished. I
would like to be able to show a 2nd form (Form2) very small and simple
that says, "Sending emails out....please wait".

This little pop up form is just a status indicator nothing else. Is
there a special way to code this so that when Form2 pops up, all focus
goes back to Form1?

thanks...

*** Sent via Developersdex http://www.developersdex.com ***

[Salad]

RLN wrote:

Re: Access 2003

I have a process that sends out emails to addresses (internally in our
company). Form1 has all the main functionality/data, etc on it. When
the user clicks "Send Emails" on Form1, I change my cursor to an
hourglass when it starts and change it back to normal when finished. I
would like to be able to show a 2nd form (Form2) very small and simple
that says, "Sending emails out....please wait".

This little pop up form is just a status indicator nothing else. Is
there a special way to code this so that when Form2 pops up, all focus
goes back to Form1?

thanks...

*** Sent via Developersdex http://www.developersdex.com ***

If I enter
Docmd.OpenForm "test"
msgbox Forms!Test!ID
msgbox Forms!Test!CustomerName
msgbox Forms!Test!CustomerAddr
Docmd.Close acForm, "Test"
it will execute the lines following the OpenForm line and then exit the
sub. That is if you haven't made the form Test modal.

[sparks]

On Fri, 15 Aug 2008 11:43:46 -0700, Salad <oi*@vinegar.comwrote:

>RLN wrote:

>Re: Access 2003

I have a process that sends out emails to addresses (internally in our
company). Form1 has all the main functionality/data, etc on it. When
the user clicks "Send Emails" on Form1, I change my cursor to an
hourglass when it starts and change it back to normal when finished. I
would like to be able to show a 2nd form (Form2) very small and simple
that says, "Sending emails out....please wait".

This little pop up form is just a status indicator nothing else. Is
there a special way to code this so that when Form2 pops up, all focus
goes back to Form1?

thanks...

*** Sent via Developersdex http://www.developersdex.com ***

If I enter
Docmd.OpenForm "test"
msgbox Forms!Test!ID
msgbox Forms!Test!CustomerName
msgbox Forms!Test!CustomerAddr
Docmd.Close acForm, "Test"
it will execute the lines following the OpenForm line and then exit the
sub. That is if you haven't made the form Test modal.

could you have a model form and display info of each email as it
cycles thru to show that it was doing something without a msgbox?
for each one display this info in a txtbox on the form.
I assume that there would be a way to know when it was done...have a
label that says done and and exit form button...enabled/visible when
thru.

[Salad]

sparks wrote:

On Fri, 15 Aug 2008 11:43:46 -0700, Salad <oi*@vinegar.comwrote:

>>RLN wrote:

>>>Re: Access 2003

I have a process that sends out emails to addresses (internally in our
company). Form1 has all the main functionality/data, etc on it. When
the user clicks "Send Emails" on Form1, I change my cursor to an
hourglass when it starts and change it back to normal when finished. I
would like to be able to show a 2nd form (Form2) very small and simple
that says, "Sending emails out....please wait".

This little pop up form is just a status indicator nothing else. Is
there a special way to code this so that when Form2 pops up, all focus
goes back to Form1?

thanks...

*** Sent via Developersdex http://www.developersdex.com ***

If I enter
Docmd.OpenForm "test"
msgbox Forms!Test!ID
msgbox Forms!Test!CustomerName
msgbox Forms!Test!CustomerAddr
Docmd.Close acForm, "Test"
it will execute the lines following the OpenForm line and then exit the
sub. That is if you haven't made the form Test modal.

could you have a model form and display info of each email as it
cycles thru to show that it was doing something without a msgbox?

Yes. If you executed the code within the modal form.

for each one display this info in a txtbox on the form.
I assume that there would be a way to know when it was done...have a
label that says done and and exit form button...enabled/visible when
thru.

Code doesn't execute if you open the form modal. Try this out (change
form name to match yours)

Docmd.OpenForm "YourFormName",,,,,acDialog
msgbox "Here I is"

Then try this
Docmd.OpenForm "YourFormName"
msgbox "Here I is"