[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 10:02:12 -0500
Jim,
Geez when you talk over my head it's just flat sexy. No seriously. I'm
now beyond the capability of Access 2002 for Dummies, but no where up to
speed with you smarties. I need Access 2002 for the
Moderately-Intelligent-Yet-Prone-to-Dumb-Mistakes.
Actually, I used James' suggestion of having a separate one cell table
which is date last TY sent. I then have an update query that I run when
I've actually sent the TY's. I had to redo code to include today for
when I'm REALLY good about getting the TY's out quickly. (I had had >
or < without being inclusive).
Today I'm going to figure out what a crosstab query (I vaguely remember
crosstab back when I did social research in college and grad school, but
we had the techie run the thing we just opined about the results!) and
I'll get LYBUNTS and SYBUNTS and ytd giving and lifetime value of the
donor knocked into shape today. Then it will be fixing the dang forms
that are screwed up beyond recognition (I may make new ones
completely!!! See above about yet-prone-to-dumb-mistakes). And the
last, REALLY DIFFICULT problem is that I have screwed up the main donor
form so my donor number field is no longer an autonumber and I can't
change it (let access start a new field beginning with 1) because it is
the one that the donations table uses as a relationship with the donors.
Access won't let me change it from a number to an auto number because
there are already things filled in on the sheet (to which I say "Yeah,
duh!"). Again see above about prone to dumb mistakes.
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
*************************************************************
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:
