Search results

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

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

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

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

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

I have a report showing classes offered, dates classes held and students attending each class, ie., Class: Computer Basics 10 May - 25 May Joe Jones Mary Smith Etc 25 July - 15 Aug Paul Albert Marty Cruz etc Class: Word Processing 02 Jan - 26...

I have a table of Organizations. The primary key is the Organization Name. In a form I use an unbound combo box to look up the Organization Name. It works great unless there is an apostrophe in the organization name and then it gives me an error. Here is the code the Wizard generated...

As a volunteer, I developed an application on my home PC using XP and Access 2000. I copied the application to CD and then loaded it on my clients PC (Office 2000). The application copied as read-only which I changed. I can not seem to get the applicaton to work. The first error message I get...

Hi Folks... I have been browsing this wonderful site for a couple of weeks and have gotten tons of helpful information. But now I am stuck. I have some knowledge of ACCESS but minimal VB smarts. I am self teaching myself as I (as a non-paid volunteer) build a membership data base application...