Search results

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

If it weren't for this site I would have probably slit my throat sometime back if I had to depend on the help system in Access (XP Professional). Lots of message in this forum say to check Access Help. So, maybe, I'm thinking its not the Help system, it might be me. Here an example of the...

I created a report on my PC. It contains a word document. Works great. Im using XP Pro. When I place the application (along with the word document) on another PC using Professional 2000 and try to print the report I get the following message. "A problem occurred while communicating with the OLE...

Jane: Thanks for your input. However, what you suggest only counts the number of records. What I am trying to do, in addition to counting the number of records, is count how many groups of records there are in the report. What I wanted to count is the number of courses offered, the number of...

It Is Working!! Not sure if its the best way or the right way but I can now count the number of groups in a report. Here is how I did it. I added a control to the header of the group I want to count. Its control source is set to =1. The running sum is set to either OVER ALL or BY GROUP...

Arghhhhhhhhh!!! That is website I had been looking at. Made a lot of sense until I tried it. I set up the control in the header and named it "Counter" and set its control to = 1. Then I set its Running Sum property to Over All. I kept it visible so I could see what was going on. So far, so...