Jumat, 13 April 2012

RE: [MS_AccessPros] Re: E-mail on Change

 

LOL Bill,

I have long been aware of how little bosses (and, truth be known) really
understand of the intricacies of other people's work. What appears simple on
the surface frequently turns out to be anything but simple. I often
encounter an unstated assumption that knowing how to use an application is
all a person needs to use the application effectively and efficiently. "The
computer does it all." So I find people with absolutely no math skills
trying to learn to use Excel at their boss's behest. And, of course, all you
need to know to build an efficient database is be proficient at using the
Access interface. Data and requirements analyses?? Why waste time on that
S***. Just use Access to do it all.

Apologies for the rant. I know I am preaching to the choir.

Glenn

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: April-13-12 11:35 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: E-mail on Change

Glenn

Care to wager on how long it takes the boss to say "Uncle"? [smile]

I had this exact request a few years ago. The "every change" soon became
"number of changes each day" to finally "Never mind".

Bill

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Glenn Lloyd"
<argeedblu@...> wrote:
>
> The devil in me says make sure you give the boss exactly what he asked
for.
> However, use this advice with caution. Being flooded with emails may just
> sharpen the bosses skills in learning to know what he really needs and how
> best to ask for it.
>
>
>
> Glenn
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> Sent: April-13-12 10:50 AM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Re: E-mail on Change
>
>
>
>
>
> Dan
>
> While this isn't impossible, does your boss realize how many emails he's
> going to get?
>
> Use each form's AfterUpdate event to send an email using DoCmd.SendObject.
>
> But I bet he changes his mind after just one week. This being my
prediction,
> you should use a global constant Boolean to determine if the email should
be
> turned on or off.
>
> In a standart module, put this in the general declaration area:
> Public Const gcbolSendEmail As Boolean = True
>
> Now add this public Sub in the same module
> Public Sub SendEmail()
> If gcbolSendEmail = True Then
> DoCmd.SendObject ObjectType:=acSendNoObject, _
> To:="myBoss@...
<mailto:myBoss@...%20%3cmailto:myBoss%40myCompany.com%3e%20>
<mailto:myBoss%40myCompany.com> ", _
> Subject:="Another update", _
> Message:="Do you give up yet?", _
> MessageEdit:=False
> End If
>
> End Sub
>
> Then in each form's AfterUpdate event put this code:
> Private Sub Form_AfterUpdate()
> Call SendEmail
> End Sub
>
> Edit the code in SendEmail to match your boss's email address, the
message,
> etc. so it reads the way you want it to.
>
> When he starts yelling, "STOP THOSE BLASTED EMAILS!!!" you can set the
> global constant to False.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , Dan Fielding
> <amessyguy@> wrote:
> >
> > Is it possible to send an e-mail via Outlook to a specific user every
time
> a record in a database has been changed, deleted, or updated?
> >
> > My boss would like to receive a simple notification that a change has
been
> made. The actual update/addition that took place isn't important, just the
> fact that there was an update/addition.
> >
> > I guess there are two types of procedures that might be possible here.
> One would be an e-mail notification each time any change is made (possibly
> generating a lot of e-mail messages). The other would be one e-mail no
> matter how many changes took place during that editing/updating session. I
> think to make things easier I would prefer that the boss get one e-mail
> stating that changes have been made, regardless of how many changes there
> were.
> >
> > If this is too difficult, is there some other method you all use to do
> something similar that doesn't involve e-mail?
> >
> > Dan
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar