Search results

  1. Pharcyde

    Concatenation

    Once agian many thanks mile o:D
  2. Pharcyde

    Concatenation

    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...
  3. Pharcyde

    Navigate Checkboxes

    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 ;)
  4. Pharcyde

    Navigate Checkboxes

    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!
  5. Pharcyde

    Navigate Checkboxes

    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...
  6. Pharcyde

    Transpose a Column

    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:
  7. Pharcyde

    Transpose a Column

    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...
  8. Pharcyde

    User Interfaces

    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...
  9. Pharcyde

    User Interfaces

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

    User Interfaces

    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...
  11. Pharcyde

    Updating table via query (via a form!)

    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...
  12. Pharcyde

    2 Xtra fields causing brainache

    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...
  13. Pharcyde

    in need of modification

    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...
  14. Pharcyde

    Getting Excel data into Access

    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!)...
  15. Pharcyde

    Relating New Table

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

    Relating New Table

    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...
  17. Pharcyde

    Disabling A Textbox If A Condition Is Met

    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...
  18. Pharcyde

    Disabling A Textbox If A Condition Is Met

    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
  19. Pharcyde

    Disabling A Textbox If A Condition Is Met

    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...
  20. Pharcyde

    Problem with Primary Key

    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...
Back
Top Bottom