[mso] Re: Access again--automated entry of date thank you notes were sent
- From: "Katherine Driskell Felts" <subscriptions@xxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 6 Aug 2004 13:19:17 -0500
Woo Hoo! My LYBUNTS SYBUNTS TotalGiving By Donor, and YTD Giving by
donor queries are going great guns!! I didn't really think I'd get it
done today! YAY helpful Microsoft application capable people! James, I
didn't end up using the datepart function but instead I did
Year(Date())-1 and it worked for figuring out what year was last year!
Now my last question. I've screwed up the entry form that is the thing
that opens when the database opens. How do I turn that off--it is so
messed up that it enters the wrong thing in places and forgets people's
names--BAD VERY BAD!
Kathie
Katherine Driskell Felts,
Executive Director
Blooming Prairie Center
Deep Roots, Bright Futures, Unlimited Horizons
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Jim Pettit
Sent: Tuesday, August 03, 2004 11:49 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access again--automated entry of date thank you notes
were sent
Katherine--
Oh, flattery will get you everywhere...
*IF* you were using SQL Server, you could create what's called a
Trigger,
which is a procedure that runs automatically and transparently when
changes
are made to a database table; this trigger would fill the donations
table
with the date a particular 'Thank You' note was sent.
However...you're using Access, so we have to do something different,
don't
we?
I'm not sure how you're calling the query you spoke of (the one which
produced the info you needed to send the thank you notes). But here are
your
options, as I see them:
1) If you're calling your query via a saved macro
a) Create a date field in the donations table.
b) Create an update query that will place the current date in
that
date field.
c) Add a line to the macro to run the query created in step 'b'
above.
d)
2) If you're calling your query from a form with underlying VBA code:
a) Create a date field in the donations table.
b) Create an update query that will place the current date in
that
date field.
c) Add a line to the code to run the query created in step 'b'
above.
In either case, you can pop up a dialog box asking the user if they wish
to
have the update query run when everything else runs.
There. Have I helped, or further complicated things for you? ;-)
--Jim
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf
Of Katherine Driskell Felts
Sent: Tuesday, August 03, 2004 8:18 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access again--automated entry of date thank you notes
were
sent
Hey guys, I got a query to accurately produce the information I needed
to send thank you notes to donors. Woo Hoo! Two months of off and on
work pays off! Here's my question now for the best and the brightest of
those who face Redmond when they pay homage to the gods of capitalism:
Is there a way to tell access to automatically keep track of the fact
that the thank you note was finally sent on August 2? What would be
really great is if that would go in my donations table right next to the
date received and amount, and THEN the next time I go running a query,
if it would remember that the last set of thank you notes went out on
August 2, so it would automatically know to grab records with dates
between August 2 and the next time I run thank you notes (that date).
Now, it can't just notate that the query was run, cuz I might run it to
get information for a board member, it has to ask me if it should notate
it.
I can see why programmers like their jobs-its cool when it finally
works!
Kathie
Katherine Driskell Felts,
Executive Director
Blooming Prairie Center
Deep Roots, Bright Futures, Unlimited Horizons
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes)
in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
