Search results

Once agian many thanks mile o:D

Concatenation!!!! Afternoon yall! If I have the fields address1, address2, address3,address4 and PostCode(or ZipCode) how can i merge them all into one block? Only 1 address item per line, and if one is left blank then it skips that line and brings the next one up, so there are no gaps in...

yeah fairy nuff1 At the moment i'm one of those lurkers, not enough knowledge to be able to help anyone else yet! Hoping that'll change tho, am learning more every day! woohoo! Access aint that bad after all ;)

oops, sorry! Cant have the word 'fliippin' hey? :confused: Believe me, thats the mildest i could come up with and thought i did quite well actually!

flippin tick boxes ! ! ! ! ! Hey all! In one of the db's that was there when i got this job, there is a form full of tickboxes, i've never seen so many of them, pardon me, I digress! Tabbing through them is ok, but using the arrow keys causes the ticks to move about, effectively editing the...

i thought that, but I'm modifying the report rather than doing the query... The guys gonna be back in 2 months so don't want him to not have a clue whats going on with his system. The query is cool, i just want it to come out sideways!!!!! :confused: :confused: :confused: :confused:

Me wants to go sideways -----> Hey all! I have a report listing students results on a law course. It has 4 columns and is in a top-bottom, left-right order, with 4 columns. In the detail, there is a field with the students name, then underneath is a subform. This in turn actually lists the...

Don't get me wrong, It's loverley! ;) If ur gonna keep changing maybe you'd like a lady who goes by the name of Aria Giovanni...

thank you very much Mile-O. What happened to your Veronika Zemanova avatar by the way? Was very very nice!:D

Bit of a vague one this... I've got my forms up and running but they're looking as bit boring as far as I'm concerned... The people in my office tend to complain less about the functionality of the db if it looks pretty, which leaves me to get quietly on with building up the queries, reports...

Afternoon all :D My tblStudentToAssessments has Yes/No fields [Resit] and [ResitPaid] i have a query qryResitsUnpaid which basically brings up all resits, unpaid - funnily enough! When the [ResitPaid] box is checked (in tblStudentToAssessments), the data is picked up by qryResitPaid instead...

In my studentToAssessment table i have the fields StudentID-AssessmentID-ResultID-ResultDate-DatePaid-AssessorID and it's relationship wit the assessors table can be seen in the attached screenshot... All i need to do is enable each assessment to have up to 3 Assessors. instead of the 1 it...

Hey all! I have a table as part of my db that needs modifying. It was ok but the boss has decided it needs alittle more... I have the fields: StudID - AssID - ResultID - AssDate - DatePaid - AssessorID with the problem being in the DatePaid field... Only resit assessments require payment...

I have a table in Access(97) to which I have to import data from Excel(2002). I've tried saving as .csv(comma delimiters), and also as .txt(tab delimiters) then copy&pasting. It works but misses out a couple of columns (maybe due to them being blank? Thought the commas would have sorted this!)...

wasnt expecting that answer but worked a treat, so cheers buddy! :D

Quick and Easy! Hey all! With the help of Mile-o-phile i managed to get my database normalised and it works a treat. However, I've added a new table, and it doesnt seem to 'relate' the same as the others, even thought it has the same structure and joins (Well as far as I can see anyway). What...

Awesome! All works asides from 1 thing... When it sets the field to Disabled, it does it to the rest of the fields as well. The form is in table view, as the students can take many assessments. I would like it to just disable the failed fields/textboxes, but it disables the whole column...

Guess the quick&easy was meant for u guys, not for me! Both replies make sense, but i'm confused as to: Seth: Where does that code go? Is it macro code, or can i just stick it in the combo box. cheers, lee:D

Just a quick&Easy one! Hey all! Been a while since I've been on here. guess that means I've been doing some work for a change! I have a form that displays data directly from a table - tblStudentsToAssessments. It goes like this. Assessment - Result - DateTaken - Assessor - DatePaid DatePaid...

Problem with PK I have a problem with repeating data in my tables. 3 tables: Students, Assessments, and StudentsToAssessment. with the following keys: Students: StudID, Assessments: AssessID, StudentToAssessments: StudID&AssessID This is correct for normalisation, but causes problems when...