Search results

Hi I have a main form with values in subforms which I need to update other subforms by means of a click. The following code works fine with SubjectID but NOT UnitID. there are also no error messages, just nothing happens. Can anyone tell me if there is something wrong with the code? Option...

Thank you Shane, I switched your entry around to Forms!frmBehaviour!SubfrmBehaviourPoints.Form!StudentID=Forms!frmBehaviour!SubfrmBehaviour.Form!StudentID and it worked a treat. You have saved me a great deal of time. Thank you Kind Regards Tanya

I think you are correct and I cannot work out how to select the StudentID column.

I have a form with two subforms and need to update a field in one subform based on the selection on other subform. Is this possible? The main form is frmBehaviour SubfrmBehaviour has StudentID and when this field is selected subfrmBehaviourPoints updates, however the StudentID field does not...

MStef I just found a problem with your solution. Each student can only be in one class. I need each student to be in many classes and each class have many students. This was why I had a student&Classes table. This places me back at square one. Any suggestions? Tanya

Thanks I couldn't find that at first. Your solution is very good and I will use it but I am sure I have seen databases where a main form has two subforms related if you could enlighten me on this process I would appreciate it. cheers Tanya

Thank you MStef, you have been very helpful. I like the way you approached the problem. Could you please tell me how to change the orientation of the text in subform2. I have not seen this done before and cannot find the control. Regards Tanya

Hi I have a problem with a form and two subforms Main Form: frmClasses from table tblClasses and includes [ClassID] and [Class] only This first subform allows me to see all the students belonging to a particular class. : subfrmClasses from SELECT DISTINCTROW [tblStudents&Classes].StudentID...

Thank you.

Excellent, Thankyou very much. You have saved me a lot of time. regards Tanya

Hi I have the following query which tallies the daily points and need to be able to select the week from mon-fri and for the year to date. I have spent hours on this without success. If anyone could help I would appreciate it. ::::Selects Daily tally:::::::: SELECT...

Ahhh Ha! I've got it now. I went into each subform individually and deselected the formatting toolbar. Thanks Tanya

I don't understand what you are trying to say. When I select a tab on my form, I don't want the formatting toolbar to show. there must be some way I can change this.

Can someone please tell me why when I select several but not all the tabs on my form that the formatting toolbar displays, only to disappear when another tab is selected. This is really annoying and I cannot find a solution. Any thoughts greatly appreciated. cheers Tanya

Thanks for the idea. I have since solved the problem. The problem related to the macro, I changed the window mode to dialog. cheers Tanya

Hi My main form has the following command line DoCmd.Maximize Which is exactly what I want. BUT I have added a text box with a macro to open another form to enable adding data to a combo box and the problem is it keeps opening in maximize mode. I think this is related to the fact the main...

Thanks... I tried this [adding where studentid = '123456'] and it didn't work and thought you may have been referring to another way of scripting this. cheers Tanya

I ran your code in place of my third query, but didn't get the desired ranking. Also, I am not sure what you mean about embeding it in another query? Could you please be more specific.

I have been scouring the Internet looking for a solution to my problem and have attached the closest I can get to the desire outcome. If anyone can help I would really appreciate it. -----My first query [qryMITotals] totals scores in a multiple intelligence test SELECT...

Finally, I have had success... I have tried numerous arrangements of the tables and query after query... I believe the problem was with the indexing, with each combo looking up an index, then returning a number, whilst showing text. Anyway, the tables tblFocus tblTarget and tblStrategy...