Search results

Hi there, Im currently working on a testing system for my school and have come up against a few problems. The first one is giving marks for correct questions when a test is being taken. I have the Question and 5 possible answers, and the user has to enter a number 1 to 5 to identify the...

Im having a bit of trouble again! Im making a testing system for my school, and the answer that they enter is a number, 1 to 5, which is compared to the field where the teacher enters the correct answer. if a correct answer is entered i want it to compared it to the field and if it is true...

Hi, Im having a bit of trouble with some coursework im doing at the moment. Its a testing system for the school but I haven't a clue how to set the tables up to comply with the user requirements. The users requirements are:  Maximum Class Size of 25 people  Maximum of 25 questions  All of...

Hi, Does anyone know how you would go about validating a car registration number in the new form since 2001 (eg AB01 XYZ) Many thanks!

Hi there, I have got my database to calculate a value if something is either enabled or disabled using the IIf command. Now what I want to do is store that value in my table in a field, how do I go about doing this? Calculating Total Price so that it can be displayed on an invoice. Many thanks...

I have a form where I enter data to, and a button to update a field. It takes a percent and changes it into a grade for a particular subject. Now what happens when I press the update button is that it changes the grades for every single person instead of just the active person. How do I make it...

I have a table with multiple data entries in, and what im trying to do is get a set of update queries run via a macro to update a single field rather than the entire column of data. At the moment it updates the field for every data entry and i need it to update it for just the active data entry...

Im trying to get my database query to display all records which are 21days old. I have used the command DateAdd("d",21,[Date]) [Date] is the name of my date field. The query is a normal query, not anything special. This query does not work, it doesn't display records at all. How can i get it...