Recent content by Nitrous

works great! Now just the mark thing to go... :S

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

I have until May to complete this project. I have finished my analysis and design (although the design needs changing cos I cant think of a way to make it work)

We're given a project and told to get on with it. I have done quite a few databases before, and they all worked perfectly, but this one has really stumped me. If i cud just set up the tables, it'd be fine. Someone please help...

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

Tried it everywhere and it just keeps saying its wrong :( Do you have any access validation code instead of VB

cool, cheers mate. Where abouts do I put this lot? I just tried it in the validation code box, but it said that it was wrong.

I managed to fix that now :) It calculates it all using an IIf command, quite cool, first time ive ever used one, works like a dream, cheers for the help!

Im after the validation rules. This is for UK car reg, excluding old reg and personalised. Just need a way for it to validate the new XX01 XXX Reg types for all years. It'll need to verify that the first number is either a zero or a five, that is it i think, but how would i do that? Many thanks

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

how do you mean?I have a 4 digit unique ID, how do i reference 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...