Search results

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

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?

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!!

: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!

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

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

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

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

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

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

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

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:

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 ;)

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

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

sweet. thats logical. but i still dont really get it...Its one of those weeks Len. Would you mind If I attached a copy of the SQL statement I'm using? I'm hoping you could tell me what I've done wrong...? Cheers, LeeBoy. P.S - Sky blues fan by any chance?

Hey all, This relates to both forms and queries, so i stuck it in here... In my dept there are 4 forms for entering/displaying exam marks. Its the typical thing where you enter the marks, and the form calculates the wightings, pass/fail and so on. Nothing complicated there... The...

Hey all! I inherited 3 db's when i took my new job. People are now asking me to allocate them passwords, because they seem to have ll forgotten theirs! My problem is this: I own everything within the db, apart from the db itself. I cannot allocate new users or passwords at all which renders me...

Mornin Y'all! How do I go about setting usernames/passwords for a new member of staff. We all have passwords so far, because I inherited this db from someone else. Now I need to add a new member of staff onto it (who by the way is a lovely lady ;) ) and don't know how... Cheers loads, LeeBoy

Mornin yall! Currently, if i tick a box in one of my subforms, the assessment record then moves to another subform (depending on the criteria). This doesnt show up until i go up one record then back down... How do i make it update immediately?? As you can guess I'm an absolute novice at the...