By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,073 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,073 IT Pros & Developers. It's quick & easy.

Showing Form while process runs

P: n/a
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 ***
Aug 15 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.

Aug 15 '08 #2

P: n/a
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.

Aug 15 '08 #3

P: n/a
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"
Aug 15 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.