Recent content by Pharcyde

  1. Pharcyde

    Transpose a Column

    I didnt get a straight answer buddy, but I worked it out. Thing is is was so long ago that I can remember which report it was about! I'll have a look for you when i get a little time at work today and get back to you. In the meantime take a peek at the thread mentioned below - lemme know if it...
  2. Pharcyde

    A problem With NULL!!!

    Mile-O - yup, they are currently variants. So far its the only thing thats worked. Do you think this is going to cause p :) roblems in the future?
  3. Pharcyde

    A problem With NULL!!!

    oh yeah. I did, it did, everyones happy! Cheers all for your help! Think I'll be scouring the net for a VB reference guide or something so I dont have to keep annoying yous lot on here!!
  4. Pharcyde

    A problem With NULL!!!

    :o Holy Sheet! Yes, everyone - how rude am I!? Many thanks to the mailman for his help with the code originally - he is very correct in pointing out that it was him that sorted the first lot out for me!! Sorry 'bout that! :o :confused: No offence intended - slightly stressed at the mo!
  5. Pharcyde

    A problem With NULL!!!

    Removing the 0 sounded perfect, but it didnt make any difference! Having a negative number just makes it come up as a negative number! I've found a way past it by altering the table manuall and printing the reports off without opening the form (So it cant change the values) and I guess I could...
  6. Pharcyde

    A problem With NULL!!!

    Heya All! I have a little problem trying to assign a null value. All I need really is the ability to assign a null value to a field if no mark is entered in a box. At the moment, If the field is empty, FinalMark is assigned the value '0'. I would like it to be blank. Function...
  7. Pharcyde

    Exporting a report, keeping formatting

    Hello and good afternoon to everyone! I've been asked to put some options on our DB with reguards to exporting some reports to .rtf format. Theres no problem with using the 'Save As/Export' right click option, but they'd like me to do it via a function/button. I've found a piece of code that...
  8. Pharcyde

    Assigning values with VBA

    Greetz namliam! Cheers muchly for all the help, I got email notification that you'd replied just as I managed to complete it!!!! I'm bound to forget it in the future so this post will deffo be helpful to me. Once again, thankyou, LeeBoy :eek: :D
  9. Pharcyde

    Assigning values with VBA

    :eek: :eek: I see what you mean about Normalization namliam, its a stopgap measure at the moment, because the examboard is a week today..! Calculated Results? I'll trust you on that one! I thought it was just a case of conditional statements in the code.as in, 'take the last taken mark, copy...
  10. Pharcyde

    Assigning values with VBA

    Mile-O - Great memory buddy!!! This is a different database tho! I inherited it when I came to work here and Its over 150Mb with mucho critical data on it so dont wanna be losing it just before the examboard! The one you helped me with is all done, works fine, and the girls who use it...
  11. Pharcyde

    Assigning values with VBA

    Good morning all! I am desperately in need of somebody's help, as my VB is weak and needs a lot of work! I have a form which holds student marks. They have 3 attempts for each exam, a final mark, and a final result. The table that holds these values has them down as: Mark Mark2 Mark3...
  12. Pharcyde

    limiting report length

    yeah thats what i tried to do...the report pulls from 2 different queries so its tricky - do you know if its possible to write a macro that will display the 1st 2 pages only while in preview/printing?? :confused:
  13. Pharcyde

    limiting report length

    Morning all, my report for some reason or another comes out at 462 pages....I only need the first two... Is there any way in which i can just limit it (or just the printing) to display only the first 2 pages?? cheers muchly, LeeBoy :D ;)
  14. Pharcyde

    Limiting report pages shown

    :D Hey all! Is there anyway I can get a report to just show the 1st two pages when its previewed/printing? Instaed of simply having 2 pages, it has 406 (2 per student!) which is 404 too many! I dont know how to stop this, so my next option was to limit the amount of pages shown... Cheers...
  15. Pharcyde

    DCount frustration in a report

    Greetings all! I'm doing a statistics report, and it all went fine until i got to the very last part - should've expected it really! Students can pay their fees for our Law course in 3 ways: Grants - from local education authority (LEA), Personal finance - Yourself/Parent, Sponsorship - from...
Back
Top Bottom