Recent content by Techie2k

Conditional Formatting based on a Lookup Table Hi all.. I've decided to abandon the line graph for the time being in favour of some coloured boxes. I've created a lookup table for the levels as it occurred to me I can't chart alphanumeric values. So I've got my data in and displaying. I'd...

Hi. I'm a bit stuck on creating a chart in Access 2010. Not sure if I've set my table up right or not :confused: Here's my table design And the input form My data is laid out like so When I insert a chart though, I'm lost. It's like it's totally ignoring my data. The data isn't mine, it...

Not quite one man.. Though it is a lot to get my head round.. Really wish sometimes I could grab a VBA expert and sit them next to me for a day lol.

I am the guy that sorts the data out at the end of the year.. and yes our 'whole school system' should monitor our SEN kids - but it doesn't. I'm therefore trying to create our own version specific to our monitoring and tracking needs. If you've been in education then you'll be aware that the...

Hi vbaInet, Reason being is I'm making this database for use in school and not everyone knows how to run queries, excel flummoxes most people. I'm making a system that run's itself as much as possible to limit end user 'messing'.. I won't be in this job forever so I don't want to leave the...

Many thanks for all your help.. In the end I went for the public function - mainly because I understood that one.. I can see the simplicity in the roll over process, but there is still a fair bit of roll over stuff to do each year. I wanted to automate as much as possible really. Sorry if...

I did though?

Hi all.. Thanks for the suggestions but I'm not having much success.. I've attached a screen shot of the table and the form - maybe that will help. Cheers again. :D ps - nbrYearGroup is the box with a number 7 in it.. our tutor groups are 7X, 7Y, 7Z, 8Y etc etc

Hi guys. Thanks for the help so far.. It's taking a bit to sink in though sorry :confused: Should my expression now look like this? (((DateSerial(Year(Date()),1,9))-[StartDate])+6 ----------------------------- I tried that, it said no.. So.. I've made another table and called it...

Cheers for your reply - thats that thing i need help with. How do i do what i wnat to accomplish? Thanks Chris

Hi. I work in education and I'm currently creating a database for all our SEN pupils. Because their year group will increase by 1 each September I use 'Start Date' and work out the year group from that. That way it will increment automatically each year. Problem is, it won't update till...

I'm trying to create a database/report using Access 2007. The database collects teachers reviews of individual students. I collect their responses using Google mail and Google Docs - save the spreadsheet to my PC and then link that to the Access database.. That far I have managed to get!! Then...