You rock! Ugly bad form no longer corrupting things. You'd think that as I was tooling around looking for what would do it tools--startup would have jumped out. Oh well. Thanks! By the way, I had changed the name of the the bad form to frmbadmain, then realized that that was a HUGE mistake. I got scared it would never open again. Now on my list--make my own darn forms and put together some rockin reports to knock my board members socks off. Also important and still needing a white horse: help me fix my autonumber problem so that when I get new donors I don't have to guess at an unused primary key number. BTW today's thank you note was similarly easy--all lined up for me already! Folks pay thousands of dollars for off the shelf fundraising programs. (and they spend lots of time figuring out how to use them too!) We can't afford that, but we also can't afford not to treat our donors well. Thanks so much those of you who have encouraged on and off list. 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 Cathy.Evans@xxxxxxxxx Sent: Friday, August 06, 2004 2:36 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Access again--automated entry of date thank you notes were sent That is fabulous! I've been rejoicing right along with your inspirational victories! Try Tools/Startup and change or remove the Display/Form Page form that is selected to get rid of the offending form. If nothing is selected, there may be an autoexec macro opening the form, if that's the case, remove or revise the row with the open form. "Katherine Driskell Felts" To: <mso@xxxxxxxxxxxxx> <subscriptions@kdfcons ulting.com> cc: Sent by: mso-bounce@xxxxxxxxxxx Subject: [mso] Re: Access again--automated entry of date thank you notes rg were sent 08/06/2004 02:19 PM Please respond to mso ..... 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 ************************************************************* ------------------------------------------------------------------------ ----------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company. ------------------------------------------------------------------------ ------------------------------- ************************************************************* 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 *************************************************************