Recent content by extraolivesplea

Hi I have set up a simple password system to allow someone to have access to some forms within my database that I don't want others to see. I have created a pop up form for the password based on using the Input Mask Password. The password log in works fine but the password stays in the input box...

Am new to creating databases - just thought I'd mention that first! I am really just practicing a few things before I start proper. I have set up a simple password entry form where there is only 1 password for all users. It opens up another form or displays the error message. Is working fine BUT...

validating check boxes & calculating there are 2 tables: tbl1 is for student details are contains fields for: ID (pk), 1st name, surname, tutor grp, ks2 aps score tbl2 is for statements: ID (PK), 9 separate fields for statements (yes/no), self-assessed level (number - calcualtes based on which...

calculations on yes/no box fields Hi! Sorry for the confusion but there are 2 tables. 1 holds students details, 1 holds the statements - each statement has a separate field name. Have now sorted out the calculation issue, but having a syntax problem with the code to allow only 3 check boxes to...

Here's what I'm trying to do: Students have a form with 9 statements in - they check 3 of them. The underlying table uses yes/no for the statments. Is there a better structure perhaps? 3 of the statements are worth 1 point, 3 2 points and 3 3 points. For each student I want to calculate their...

Hi! Here's want I'm doing: Creating a form for students to fill in - list box to select name, then yes/no boxes for them to select 3 relevant statements out of 9. 3 statements are worth 1 poiint, 3 worth 2 points and 3 woth 3 points. What I want to be able to do is calculate their points on the...

Here's what I'm trying to do: Students have a form with 9 statements in - they check 3 of them. The underlying table uses yes/no for the statments. Is there a better structure perhaps? 3 of the statements are worth 1 point, 3 2 points and 3 3 points. For each student I want to calculate their...