Search results

Thank you all for the help. But I ended up just taking the path of least resistance. I found the intended recipients by creating a query. I right-clicked the "email" column/field and COPIED the email addresses. I then just pasted them into the BCC field of a new Outlook email and clicked SEND...

I appreciate your reply. I am a novice though and just a little bit of step-by-step would be helpful. How do I " use a select all and send" and where do I enter that code? Thanks again.

Hi. I have a simple need but all results of my search give me directions to do things far more complicated than I need. Maybe you can help me. I have a query (Access 2007) that contains a field named "email" (which contains email addresses, of course). I want to email everyone in the query and...

Yes, that did it. Thanks.

Hi. I've got a report based on a query. The query has its results sorted ascending in "field A". Everything worked great. I've had to edit the query -- added a couple of fields and changed the sort order. Insteading of sorting "field A", "field B" is now sorted ascending. I've edited the...

Perfect! That did it. Thanks so much.

I really can't as it contains a lot of personal info. Sorry.

OK, I went to the SQL view and added your line. That view now looks like this: SELECT [MP TABLE].[LAST NAME], [MP TABLE].[FIRST NAME], [MP TABLE].[Att2007], [MP TABLE].[Att2008], [MP TABLE].[Att2010], [MP TABLE].[Att2009] FROM [MP TABLE] WHERE Att2010 = "Yes" AND Att2009 <> "Yes" AND Att2008 <>...

Thanks for the reply. That makes perfect sense. But forgive the newb question...where exactly do I type that sequence? All I've ever used is the "criteria" line in the query design. Thanks.

I've got a table that contains people and their attendance records for an annual event. The three attendance related fields are: Attend2008, Attend2009, and Attend2010. Each field can contain either Yes, No, or be blank. ("Yes means the person attended that year, "no" or <blank> means they did...

Yes, in fact that is where I noticed that they were gone.

I actually have two forms that may be used to enter data into this table. I checked both of them and neither have anything in the filter property.

Hi. I've got an Access 2007 table with about 2,000 records sorted by Last Name. A form is used to input the records. A couple of days ago I noticed that all the records with last name beginning with Aa through Al (Aaron, Abernathy, etc.) are missing. Last name "Amos" is the first one in the...

I've got a table with a "Date of Birth" field and an "Age" field. Those fields are also included in my form. When completing the form I would like to fill in the "Date of Birth" field and have it automatically complete the "Age" field with how old that person would be on, say, June 29, 2009...

I'm terribly sorry to have to ask this a second time but my original thread is now apparently corrupt (same title, see below) and the thread is now unavailable. I have not been able to view/read the five replies to my original thread so hope you're willing to help again. I have a form with a...

I have a field into which I want my data entry people to be able to enter ONLY "B" or "G" (for boy or girl). They can leave it blank, but if anything at all is entered it must be either B or G. What's the best way to achieve that?

What does this mean exactly? Can you give me an example?

Anyone have an idea on this one? Why it work on one PC and not on others?

This one seems to work great. "Or set the default value as Date()."

Here's a quirk to add to the mix. I got this to work on my computer. But when I save and close the database file, then open it using another computer on the network and open the form, it does not open to a new, blank record. I checked the code and it is still there. Any ideas on this one?