Search results

I had another look at the tables and took your suggestion about querie for from related only to tblbookloans however, it doesn't allow me to create another record for another student, then return to previous to see the history. This is very frustrating given our aircon is on the blink and it...

Thats ok, perhaps I didn't explain myself so well. I am going to leave this problem for a couple of hours and then get back to it. I will keep you informed. Cheers Tanya

Hi StudentID is not an autonumber because it is taken from the Departments own Oasis Database and I am trying to relate the borrowing of a book to a class and faculty. For instance, one student is enrolled in many classes hence studentclassID and within each faculty there may be more than...

Thank you for this break down as you see it, I will take it on board and see what I come up with then get back to you. You did mention a few FK which did nothing, the reason being that this library is a small part of a much greater project I am working on. [I have attached a copy for your...

Thank you Scott for this answer.

That is fine, I appreciate your patience and time. It was late here also when you posted your last response and morning now in Sydney. regards Tanya

Main form is frmclasses and the problem is with subfrmLoanBooks I found that if you enter one record, that is fine, however when you click on a new row you get the following message: You cannot add or change a record because a related record is required in table tbltextcopies Otherwise the...

Thank for your reply. I tried what you suggested and it didn't work. I have since attempted to reorganise the tables a bit and playing with the form, but now I am getting an error message relating to a table and requiring a value? I realise I will need to set up cascading combo's for the...

Hi I am stumped on the next stage of my database. Within a school faculty there will be many book titles and copies of each. I am attempted to streamline the process of recording the books on the shelf and those borrowed to students. At present this is recorded by hand which leads to incomplete...

Yes I finally worked that one out. Thanks again and I'm not worried about the earlier confusion only the amount of time you have put into this problem for me. This has been a great learning experience for me. cheers Tanya

John.. I am trying to understand how the text box SumOfCountOfGood works. Is this text box searching the whole subform? I tried recreating this for SumOfCountOfAve and it wouldn't work? I cannot see how it relates to the field work or to any of the queries. cheers Tanya Edit: OOps Silly me, I...

Thank you John You really are wonderful. The queries you gave me earlier will benefit me immensely over the comming days when I set up reports, and you've just given me the exact answer I had been looking for. Thanks again. regards Tanya

I do want a specific student result!

Magic! Thank you John. I have been stumped on these queries for days! Now.. query3 will allow me to get a count for None, Poor, Good, Ave, Exc but how do I get these totals into text boxes on my form frmAtt? In the copy you sent me, the total of good for instance is correct for the class but...

Hi John I am having problems creating a Totals Query. No problem counting for one though. i.e. I created a query to count Good from work field and that works fine. As soon as I try to create a query which brings in all the counts of various performances I get into strife. Here is my current...

hi John I realised that in its present format based on tblAttendance it would not allow me to define records to count and this was ultimately my question. Is it possible to use Dcount on results of form rather than a table. Can you suggest a better method? I would really appreciate any ideas...

Hi I have a attached a copy of my db, hopefully it will all make a lot more sense now. Cheers Tanya PS. This is not a school assignment! I am a school teacher and this db is intended for my own use.

Hi GoodTotal appears to be displaying the correct value, however it doesn't help me because the 2nd subform is related to another subform, i.e. select student and subfrm 2 relates to record in other. I have since decided to try a new tack with this problem. This is what I eventually want to...

Thank you for your patience. This is what I have Sub form 2 Named subfrmAttComments text field named 'GoodTotal' and following statement =DCount("[Work]","tblAttendance","[Work]='Good'") Sub form 1 Named frmAtt text field named 'txtGood' =Me!SubfrmAttComments.Form!GoodTotal The error I...

Hi John Please excuse my ignorance, but I don't follow with the code for main form, where do I place the line of code? i.e. do I place it under the event 'On Open'??? Also the control name, is this the field name or name of the 2nd subform? kind regards Tanya