Search results

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...

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...

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...

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?

I've got a form with a DATE field and the little icon for the calendar appears when I tab to that field. Is there a keyboard shortcut for today's date that I can use without having to click the little calendar icon? I know I can copy today's date and paste it but wondered if there's a keyboard...

My form contains a combo box that uses a RetrievalField to search records in a table. As I TAB through my form and reach the end of the form, I'd like to hit TAB again and go to a new, blank form. Currently, hitting TAB takes me to the next record in the table. Any help appreciated. Thanks.

Hello. I have a form with a combo box containing a RetrievalFeild to look up data (name and birthday) that may already exist in the table. That way, if the data is already there, I don't have to enter it a second time and create a duplicate entry. When I am in the combobox and find existing...

Hi. I have created a simple query using four fields from a table. I then created a report based on that query that displays those four fields. When I open the report, however, I get an "Enter Parameter Value" message with a field name that I'm not using in either the report or the query...

Hi. Here's an easy one for you (that I can't seem to figure out). I've got a table with 1,000 records. One text field is SCHOOL NAME. I want to count how many records there are of each school. For instance, there may be several records that have Lincoln County High School, several more...

This is bound to be a stupid question but I can't find the answer. I need to clear the text data from a single field for about 400 consecutive records. So, in my table, I click the first cell that needs to be cleared, scroll down to the last cell that needs to be cleared, then SHIFT+CLICK and...

Hi. Here's a report layout challenge for you. I have ten kindergarten classes each in a different room with different teachers. Each classroom contains from 10-15 students. My table has fields for grade (they're all kindergarten), classroom, teacher, and students. I need to print all ten...

I have got a table with people's names, addresses, phones, birthdays, etc. as fields. I've created a form to use to enter data into the table but want to be sure I'm not duplicating data already in the table so have set up a combo box. The combo box has three "columns" (last name, first name...

Need an opinion about the best way to do this. Using a form which puts data into a table, we entered about 1,200 names with addresses, phone numbers, etc. for an annual event a year ago. Now it's time for this year's event. Many of last year's participants will attend again this year and will...

Learning my way through Access 2007 and wonder if you can help me with this. (I'm guessing it's simple.) I have a table that contains several fields including "Boy/Girl", "He/She", and "Him/Her". I have a form that contains the control "Boy/Girl". How do I configure the form so that when BOY...

Hi. I'm looking for help on how to lay out a report containing data about classes at a school. I need it to look something like this: http://www.south-haven.org/classroomexample I've got a table containing these fields: - Grade (there are seven grades -- Kindergarten, 1st, 2nd, 3rd, 4th, 5th...