Search results

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

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

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

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

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

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

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

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

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

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