Search results

Many thanks JHB for your response, which is much appreciated :) I am not a programmer so I wouldn't know where to start with writing the code. Could you give me an example please? Thanks again, Anna

The query is designed to bring together data from 2 different tables: Classes and Students & Classes, which I then display in a form. When the data from these two tables is merged together in a query, everything is fine. The query returns the correct number of records, and the query is...

Good morning Access Programmers, I need some help with a form and its underlying select query. I have a form that returns the details of a class, its tutors, how many places are available on the class, how many are taken, and how many are available in total. Initially, the underlying query was...

Thanks. The columns you have in your own query are the columns I want to see in the query result. The columns in your "qry_Results" are the columns I want to see. However, in the "CourseName" column I also want to see listed those courses where the "NumberofBookings" column is 0 because no...

Hello again High & Wild, Thanks again for your sample database, which was helpful to an extent. However, it did not return the records I wanted. The problem seems to be that Access is only returning records where there are students allocated to a course, but it won't return records if the...

This is great, many thanks High & Wild! I'll take a look when I've stopped being dizzy and let you know how I got on. BW, Anna

Thanks for your help Paul, but changing the join type hasn't worked. I think it may be because the query's structure is a bit complicated. I'll try and explain. I created a query (qryCappedCourse) that comprises two tables:- - Classes - Instructors and Classes This merges the course name...

Good morning everyone, I have a query that shows the following:- 1) List of courses (e.g. Art and Its History) (called CourseName) 2) Number of students allowed on the course (e.g. 12) (called CourseCap) 3) Number of students currently allocated to the course (a count of a field called...

Paul, Thanks for the help once again. I can see why that would work normally, but something has happened to the database and it has affected all kinds of things. I have decided to take up your advice about combo boxes in tables, however, so I have created a new, blank database and I am starting...

My problems with the combo box have just multiplied :( I created my database using Access 2007. I was then upgraded to Access 2010, and that seems to have played havoc with each look up I have created in all of my tables. For instance, I have a table listing teachers and their status, e.g...

Thanks for the help and advice Mr B. I am totally self-taught on Access, so I don't know what I am doing most of the time! It's working now, so thanks again. Best wishes, Anna

Good morning, I have a table in which I have created a combo box. When I try to select a value from the combo box in the table, I get the annoying error message "The text you have entered isn't an item in this list", even though the value IS an item in the list!! (The combo box lists job...

Many thanks Paul, that worked very well. Regards, Anna

Hello there Access Experts, Can you help me solve this problem? I want to create a list box that contains a list of all the available forms in my database. I don't know how to write code, so I would appreciate a kind soul explaining how I can go about doing this in very simple English please...