Search results

I'm interested to understand why the syntax of this very simple IF statement works in example A but not in example B. Even though both examples require only one resulting action Example B requires an End If block to work, whist Example A doesn't. The only difference is that in Example B the...

Using VBA can someone explain the process I need to follow to transpose the data in the spreadsheet shown in pic1 into a db table laid out as shown in pic2? Cycling through each of the records in the spreadsheet I need to take the StudentID and ClassRef and append to it an ExamPaperID which...

I have this bit of code which opens an existing Excel workbook from a file picker in one of my forms (txtFileName) and which then deletes all but one sheet (which is renamed) and then saves the workbook with the new name "Target.xlsx". Ultimately this will be imported into my db. The problem is...

I'd like to thank AWF and its members for helping me create the database I was working on. The task is complete. Well, at least I think it is. I have done what testing I can and I think I've addressed all the glitches and bugs, so now I'll just have to see what happens when it's in use. What...

Hoping someone can help. I have a junction table which contains records of students who have been allocated class year groups. It contains 3 fields; StudentID, ClassID, and AcademicYearID. A student can only be allocated one class year group in any academic year, so the table has a composite...

I’m not even sure I’m asking the right question, so I’ll set out my problem and maybe someone can point me in the direction of a solution. I have a suite of charts in a multi-tabbed form which I want to compile into a single report for printing. The majority of charts share the same source...

Does anyone know of any free to use statistics add-ins / plug-ins for Access 2010? There is a paid-for product from FMS called Total Access Statistics and if I was anything other than a hobbyist and/or flush with cash I might consider buying it. But I'm not, and as I'm only ever likely to...

I’m trying to generate a recordset based upon two user-defined criteria - a list of those subjects where 80% of the class cohort scored less than 20% of possible maximum marks. The two percentages (80%) and (20%) will be user-defined but I will set the defaults at these levels. A query to...

On opening my form I’d like to set the default value of a combo box using the current date as a parameter The following SQL gives me the value I want but I don’t know how to apply this to the default value for the combo box. SELECT tblAcademicYears.AcademicYearID FROM tblAcademicYears WHERE...

I have been going round in circles on the best way to approach a report which is dependent on data from 13 tables and with a three-field filter. The report is a student's exam feedback, with all information summarised on a single page. The best I can achieve is 5 queries to extract the data I...

I’d like to get some advice on a good way to approach the coding for a form which will enable users to add a new exam to my db. Adding a new exam involves adding data to three tables (ExamPapers, Questions and GradeBoundaries), all of which require inclusion of the PK from at least one other...

I’m not even sure I’m asking the question the right way but hopefully you’ll get the gist. I have a form (pic attached) from which tutors can alter the details of tests that students are scheduled to take. The subform recordset shows only those students enroled on a test where there are no...

I am getting a 2185 error code when dynamically filtering records in a form from an unbound text box. “Error… 2185 – You can’t reference a property or method for a control unless the control has focus” The filter routine works fine until no records match the string in the text box and that’s...

I have been trying to find the answer to this but without success. I want to populate a subform from the record I select in another subform. I have attached a screen grab of the form to illustrate. My parent form [MainForm] has two subforms [SubFrmA] and [SubFrmB]. The underlying data is...

I could do with some help regarding the best way to approach the following tasks. It’s to do with entering students’ exam scores for the schools database I’m developing and it’s the thorniest task I’ve confronted so far. It’s not a simple case of just entering a student's total score for each...

This is related to my thread "School database: How to use controls and a macro to simplify student exam registrations" I need a method of selecting some records in a continuous subform that I want to do something with – in this instance copy those selected records to another table along with...

I am developing an Access 2010 database for tracking students’ progress and exam achievements and I am trying to figure out a way to quickly and easily register students on exams. The table I am trying to populate is the Tests table in the attached diagram. This is a junction table with...

Hello. My name is Nick and I live in Surrey in the UK. I am not an Access newbie, but it's been over a decade since I created my last database and up until now they have all been relatively simple affairs. Having retired a few years back I thought I was done with building databases, but it...