Search results

If i open the form on its own, everythings cool. If i put the form as a subform, i get the error message. :confused:

Put this subfrom up without the message: You cant use a pass-through query or non-fixed column crosstab query as a record source for subform or subreport I've made a form using this, and it works fine. What do I need to do to sort it out??:confused:

Oh yeah, this is what I'm using to try and get the next date. It looks logical enough, and does return a date, but it isnt the correct one, as there is a closer date then the one returned. NearestAccDate: Min(IIf([Date]>=[Ass-Assessments]![ResultDate],[Date],"False")) where Result date is...

yeah i know. Am not the best at design, naming and organisation stuff Mile! I kinda just muddle my way thru it all. Any suggestions on the naming then, or maybe a link would be easier for u?

Heres the db. THe logic behind the accDate?? Well, its just a table of dates really. The next available accDate needs to be found, and as soon as current date reaches that (if all exams are passed) then the db will accredit them automatically. ( I know hoe to figure that one out) so this is the...

Heres the db. THe logic behind the accDate?? Well, its just a table of dates really. The next available accDate needs to be found, and as soon as current date reaches that (if all exams are passed) then the db will accredit them automatically. ( I know hoe to figure that one out) so this is the...

Students in my DB have certain dates where they can be accredited with passing their exams. Once all 3 are passed (which is sorted - ta mailman) they are accredited with it on a certain date(these dates are held in a separate table). I would like to calculate the nearest next accreditation...

worked a treat thanks v.much for taking the time and effort to help me mailman

Exam report and XX are all under 'Type' field, and the fees are all under 'amount' field...

My query has 3 tables, StudentDetails, Assessments, and AssessmentFees. The aim of the query is to list all the assessments that the students have failed. I can do that fine. I am having problems with calculating the total fields however. there are 3 assessments, Exam, Report and X-Exam...

cool all done. there ya go :D

dont laugh mailman, but how do i do that??

ah ok that worked, sort of. Maybe you can help me with the next part of the problem. Basically if all three were passed then the caourse is completed. At the moment, Pass=Completed, and Fail=Incomplete. I need a Completed flag when all three=Pass. Any ideas?

I'm trying to run a query to work out whether a student has passed their assessments or not. Testing on a student who has passed Exam, Report and XX, the following query returns incomplete. acc1: IIf([Ass-Assessments]!AssessmentID="Exam" And [Result]="Pass" And...

Mil-o-Phile answered the original for me, but i got a lil confused. Hi all. I have a query linking 2 tables: Student data & Student Assessments. For eachstudent, I would like to count the number of assessments they have passed (using dcount). Then, if they have passed all three i would...

Hey all, in my (sub)form, i have a checkbox. whenever i check it, it adds a new (blank) record, which i do not want. All i want is to tick the box, and for it to appear ticked in the corresponding table. Any ideas?? :p

well, i trust your jusdgment, but am not sure what you mean exactly....

Hi all. I have a query linking 2 tables: Student data & Student Assessments. For eachstudent, I would like to count the number of assessments they have passed (using dcount). Then, if they have passed all three i would like the (yes/no) accredited tickbox to be enabled. In other words it can...

I doubt thats the correct term, so let me try and explain! |I have a subform, i would like to create a textfield or a label that will only appear if a certain condition is met. In this case I'd like it to appear when there are less than 6 months remaining on a contract. Could anyone please...

thanks Tay, really should check out the settings before i come on here and ask!!