Search results

Hi there, I am using a query to get a rough count of how many students have had more than one tutorial. This was working fine until I put a WHERE clause to add a 'TO' and 'FROM' date statement. Here is my SQL: SELECT Count(vTbl.StudentID) AS StudentsMore FROM (SELECT StudentID FROM...

Hi there, I have a table called tbl_student with student ID and several other fields. I have recently received an excel spreadsheet with a list of student IDs and their courses. How would I go about running an append/update query to update each student with no course if they exist in the...

Hi there, I have a student form which is used to enter data about students. I have added a couple of filter buttons so it is easier for the admin team to find blank fields to carry on entering data. Ideally though, I want the filter to also show the records in descending order by created_date...

Hi there, I am trying to write a query to count the number of distinct students that belong to each faculty and a gender breakdown of this. My query is as follows: SELECT distinct Count(tbl_Tutorial.StudentID) AS CountOfStudentID, tbl_Student.Faculty, tbl_Student.M_F FROM tbl_Student INNER...

Hi there, I am using a combo box with a control source consisting of a query of these fields: Course Faculty Department I have two textboxes called 'faculty' and 'department'. The way it should work is as follows: The user selects a course from the dropdown list, the corresponding...

Hi All, Attached is a screenshot of an error message that seems to occur sometimes but then at other times it works fine. It happens on searching for a student and trying to click on a result to transfer the text to a form. The code I am using is as follows: Private Sub...

Hi there, An administrator adds students to a database via a form. He types in the student number and the other student details and then this is saved in the database. The problem is, sometimes he does not check if the student already exists and it doesn't return the duplication error until...

Hi All, I have a blank form and have inserted a subform, this is a table of data from a query. Is it possible to put an on click event on this like as if it was a listbox? Thanks Kate

Hi All, I am trying to count the number of different students seen between two dates. I have tried the following: SELECT Count(*) AS Students FROM (SELECT DISTINCT StudentID FROM tbl_TutorialRecords0708) AS T WHERE (((tbl_TutorialRecords0708.Date) Between #9/1/2007# And #8/31/2008#)); this...

Hi everyone! I know how to import spreadsheet data into an access database but only whole data for a new table. Is it possible to import certain fields for certain records that already exist in a database table? For example, if I have a student in the student table who exists in the table...

Hi there, I am trying to put a condition on a find student button so that tutors can only find a student to add to a record if the record is a blank one. The easiest way to do this is to write an if statement to check if there is a studentid in the record. If there is a studentID in the record...

Hi there I have a search form which works as follows: User types in a studentid and a list box refreshes and displays any matches What I need to do now is on double-clicking a match, I want that record to be copied to table tbl_student in a database called ‘Ask_dbase’. The student table fields...

Hi there, I have a database with a form to record tutorial notes. I have autocorrect on a memo box but users seem to use the general spell check button from the main menu then wonder why this goes through all the records and checks the spelling. Is there a way to get the spell checker to just...

Hi there, I have a form in a database with a button. On clicking that button I want another database file to open. Any ideas how I can do this? Thanks Kate :)

Hi there, I have a tutorial history form which allows tutors to view their tutorials and delete any that were created in error. The trouble is, at the moment my delete code allows users to delete any tutor records when really it should just be there own. If MsgBox("Are you sure you want...

Hi guys, I am trying to pull data from a database to another database through an oracle view. How can I change the code I am using for the transfer process to work with ADO?. The reason for this is because we have moved from access 2003 to 2007!

Hi there, I have 6 buttons which are label controls. Ideally I want to set a condition that unless the label called 'New' is clicked, the label called 'Find Student' is greyed out and not clickable. Any ideas how to do this with labels as opposed to buttons?

Hi guys, I have a database that I designed in access 2007. I split the database and kept the backend on a shared network drive. I created 10 copies of the frontend to deploy to 10 users. This worked fine to begin with but now some users are getting backup copies being created on opening the...

Hi there, I have three tables with the information to be able to get a count of how many students that each tutor has seen but everything I have tried using the cross tab type of query and putting a count on studentID and group by tutor name but this seems to count the students the same for...

Hi there, I developed a database for some users and one of the users has recently got the following message on opening: 'The document ASK_Database_v7_temp.accdb caused a serious error the last time it was opened. Would you like to continue opening it?' (options: yes or no) When she clicked...