Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Running process in the Background

0 views
Skip to first unread message

RLN

unread,
Jul 24, 2008, 11:00:01 AM7/24/08
to
Re: Access 2003
The FE is on the workstation and the BE is on the file server. Right now
the system only has 2 concurrent users.

I have a process in my application that sends out email confirmations
internally in the company that indicate that the processing of their
financial transactions has completed. Generally when the user runs this
code module to send the emails, it might take 2 to 3 minutes, depending on
the number of emails that need to be sent out.

Right now the user cannot do anything else in the app until this process
gets done.

Is there some VBA code I can add that would run the email sending process in
the background so the user can continue using other parts of the application?


Thanks...

Stefan Hoffmann

unread,
Jul 24, 2008, 11:08:51 AM7/24/08
to
hi,

RLN wrote:
> Generally when the user runs this
> code module to send the emails, it might take 2 to 3 minutes, depending on
> the number of emails that need to be sent out.

How do you send e-mails?

> Is there some VBA code I can add that would run the email sending process in
> the background so the user can continue using other parts of the application?

No easy way without a lot of extra coding.


mfG
--> stefan <--

RLN

unread,
Jul 24, 2008, 4:14:05 PM7/24/08
to
>> No easy way without a lot of extra coding.<<

Do you have an exmaple where his is done?

dch3

unread,
Jul 24, 2008, 10:05:03 PM7/24/08
to
What code are you using to send the emails? Are you using
CreateObject("Outlook.Application") to create the items directly in Outlook?

Stefan Hoffmann

unread,
Jul 25, 2008, 4:28:35 AM7/25/08
to
hi,

RLN wrote:
>>> No easy way without a lot of extra coding.<<
> Do you have an exmaple where his is done?

As you cannot use threads in Access directly, you need to code an extra
program for that.

btw, you haven't answered my first question. The time it takes is not
normal. I strongly believe that your code is not clean. Otherwise if it
is, then you have a general e-mail problem.


mfG
--> stefan <--

RLN

unread,
Jul 25, 2008, 2:58:15 PM7/25/08
to
This is a small snippet of how I am setting up the email to send.
Dim olApp As Outlook.Application
Dim olMail As MailItem
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)
0 new messages