Search results

============================================ Thanks JD I think this, if it worked, would be an excellent solution. Unfortunately it's beyond my knowledge. I have no idea how to do this. Many thanks for you suggestion Rob

Dear Lagbolt, many thanks, this works perfectly. One other quick question if I may. Is it possible to link the same criteria in the query to a drop down list? I'd like to have a form where I can select Year Group then Gender then Pronoun. This would allow me to investigate all the possible...

Hello folks, I wonder if anyone can solve this problem for me. I have a table with a memo field that contains teacher comments. Each student in teh database has been assigned a gender. I have discovered that some comments have been copied and pasted and as a result there are incorrect...

Thanks for taking the time to reply Glue. I assume that this code is for the report not the form. Can I ask on which event this code is inserted? Also, in line 7, you mention JobID should this be YearGroup? The source for the Yeargroup on the report is [Year Group ID]. The fact that there...

Many thanks once again Bill. I will certainly try this as soon as I get some time to spend with it. Rob

Hi Bill, I have 8 reports. Four for Mid Term and the Four for End Term. There are several report options: Records by Form Class Records by Teacher and Yeargroup Records by Teacher, Subject and Yeargroup Records by Selecting Individual Student Each report has to be duplicated for Mid and...

Thanks Bill. I understand where you're coming from with this. I'll have a look, however to create a different report for each yeargroup would effectively mean 12 reports as there is one each for Mid Term and End Term. Maybe too much. Rob

Bill, can I presume to ask a further question? I have a report which is based on the information submitted in the original form. In the report are two text boxes: MTR Target Level and MTR Target Grade. Would a similar code inserted into the On Load event do the same as the code you wrote for...

This works brilliantly Bill. Many thanks....you're a star! I agree with your observations re naming fields. Rob

Thanks Bill

Hi Bill I took out everything that I could and zipped what was left. I hope that this works. From the main switchboard: Select View/Edit Student Reports Select Mid and End Term Written Reports.... Select View/Edit by Form Class Select AAK Year 9 Select Mid Term (any subject) This is the...

I'll see what else I can delete in terms of forms and reports. There are many of them. I did compact the db first and It is not split. Rob

Hey Bill, I've deleted everything that I can but when I try to upload I get the following message: "Your submission could not be processed because a security token was missing." The file is 18,212 kb. Is that still too big?

I see it Bill. I will try to downsize the DB a bit more.

Bill, how do I attach the dbase?

Hello Glue and thank you for your prompt response. This is what I had envisaged. Unfortunately I know very little about programming code. Would it be possible to give me an example of this code? Rob

Hi Bill, thak you for your prompt response. I have a form that contains student details, name, form class etc. with a subform (continuous form) containing a list of subjects that the particular student has opted for. Beside each subject there is a button that opens a different form, used for...

Hello folks, I wonder if anyone here can help me? I have form which contains a number of combo boxes, but there are two of particular interest. [Target Level] and [Target Grade] Each database record has a Year Group number 7, 8, 9, 10, 11, 12 or 13 and this number determines which of the combo...

Dear mahenkj2 Your method was correct. I now have this working, many thanks for your help. You are a star! Rob

Hello mahenkj2 I don't know if this is what you asked for but it is the SQL for the query that is not returning the values expected. It should have returned 1 record (see below) because the [MTR Behaviour Grade] is null. It returned a load of records instead. I have attached the query for...