Recent content by LeoDee

I do need help Dan_Cat: I have been unable to get my code working. Followed your great example. I had to change my references so DAO was a higher priority that ADO. And, I wanted to increment my dates by week instead of day. I empty the Calendar Table then run two append queries. So far so...

That is pretty slick!! While some of the coding is Greek to me, I believe I can follow your example and come up with something workable. Really appreciate the time and effort you put into this. Thanks so much, LeoD Lyon

I have a table of classes that shows start date and class end date for each class taught. I want to print a monthly calendar showing the days of the month and which classes are taught on each day. To do this, I have constructed a BIG series of queries that creates a single record for each class...

I have a form that contains a sub-form. On the form I use a combo box to select records which appear in the sub-form. I would like to filter the records on an either or criteria on the same field. For example, if I were filtering on CityName, I would like to be able to select either Boise or...

Thanks for your input. I found a way to make it work. It may not be the most efficient way but it does the job. I enter the data into the form which is associated with the output table (Student/CLasses). I have the user click on a button which executes newrec. Then I move the data from the...

I have a Student table, a CLasses table and am generating records for a Waiting List table. I had thought of having a form which captured the Student and all they Classes they wanted to take and writing a separate record for each Student/Class to the Waiting List table. I will try the approach...

I have a form which allows students to sign up for a class. If the student signs up for multiple classes I have to make separate entries for each class. What I would like to do is allow the students to select multiple classes on a single form and generate a separate record for each class...

Hope you are still reading this topic. I would like a copy of your code. My email is FSLyon@Yahoo.com. In advance, many thanks....

Ignore Please ignore prior post. Multiple ORs are working via form with no problem. I was comparing yes/no boxes and had problems with default condition and error message was confusing me.

Merci! Now that I know I can have more than 3 "OR" statements in a query, how come I keep getting the following error message when I enter the 4th "OR" statement? "The expression is typed incorrectly, or it is to complex to be evaluated". I know it has been typed correctly as I have check it...

I am using a from for my query criteria. There are 11 possible selections (for printing labels). I built the query and tested it using a single selection. Worked great. However, when I increased the number of "OR" selections to more than 3. It gave me an error, something to the effect too...

Makes sense!! Thanks for your help.....

The combo box selects the players names from a table......

I am scheduling tennis matches. Each match consists of 2 lines of singles and 3 lines of doubles. For each match I have 12 players to select from for 10 spots. I am using a combo box to select the players for each position. How can I preclude the selection of the same player twice? In other...

Guys: Thanks for the replies. As far as the 2nd PC not having Word, it does. I even tried recreating the report from scratch on the 2nd PC and I got the same error message. I will try the Norton Anti-Virus suggestion. Thanks again....