Search results

Just tried it. Perfect, thats exactly what I was looking for! I'll leave u alone now mile-O. Cheers for all the help on this, much appreciated!!:D

ok. its not that I'm not listening to you, because you clearly know a lot more than I do. I guess I'm just not understanding it.... Maybe If i try and explain(for myself as much as you! lol) ...There are a set of dates where accreditation/submission/results take place. ~~~~~~~~~~~~~~~~~~ i.e...

But not on the .zip you gave me. All i did was put data in the tables. Maybe I'll just take it as given, because it doesnt seem to affect the db really...

aye. that all makes sense. but i'm sure that i definitely need the assessment dates in a separate table. One thing that confuses me though, is that in the relationships window it keeps putting tblResults_1 in. Why does it do that!?

hmmm. hadn't paid much attention to it. It expires in 2200 so won't be around ;) But seriously, yes please, I would! I also need to keep the table that holds all the set assessment dates - only just noticed it had gone. Asides form that its perfect... :D

as always, you have been very helpful. Thanks very much, Lee :D

Following on from a post yesterday "Strange Things Happen" to which Mile-o-Phile gave me a link to a normalisation thread he was involved in. Read the thread, understood the concept, so then had a look at my tables. They all seem to work fine, so that left me :confused: lol. From what I can...

Brilliant, cheers for that boys. btw Rich, the assessments are in a different table, was just the student details i was having the problems with. I'll get onto the normalisation route now Mile-O :cool:

So its sporadically creating duplicates? that makes sense. So i guess what I should do is hold all the students details on the main form, then keep the assessments and suchlike in the tabbed panes and it should all be ok? Thanks guys, much appreciated:D

Well, the main (frmStuDetails) holds all the assessment, assessment fees and personal details, etc. I just wanted to have the student name, ID and so on at the top whilst the user could browse through the rest of the details in the tabbed panes without losing sight of who they were looking at...

lol, phenomenon! yeah no problem. The table is tblStudentDetails. The form frmStuDetails, and then the subform frmStudentDetailsSubForm which both read from the aforementioned table. Cheers :D

This I really dont understand...:confused: :confused: Data in my tables keeps on moving around. Its like there's a poltergeist in my DB! Let me try and explain that a little better... Say you put in the data like StudentID: 1 (autonumber) name: Lee Address: 57 Inverness Place StudentID: 2...

Hahah. Flippin eck! That was 2 months ago!!!! U have a photographic memory or summit??? :eek:

Dayumn! You know my memory better than me!! Cheers bro!

Anyone know any good tutorials, I need to start modifying bits of my DB and am not too sure where to start really... Cheers, Lee:confused:

i gottit! it's all to do with grouping levels. Cheers anyways tho! :D

its a report. could find the continuos thing in view or properties...

Hi all. I have a report which is basically an invoice, notifying students of the amounts they need to pay in order to resit a failed exam. The query I have brings up all failed exams. Thats fine. In the report however, it will only bring up the 1st person who has resits. So basically what I...

I have a query running off a crosstab query. When openin in a from its fine, but if opening as a subform i get 'You can't use a pass-through query or a non-fixed-column crosstab query as a record source for a subform or subreport I've sorted this by setting (fixing) the column headings. But...

i got a normal query as the source. But that query has a crosstab as part of it. Maybe thats the problem... I've never even heard of a pass through!