Search results

Thanks SOS

Thanks SOS I wasn't aware of point 2 but it makes so much sense to have it this way. But could you please explain (or point me in the right direction) how this is done? My DB is used by 5 users. The MDB is stored on a server and they all access this via mapped drives from their PC to this...

Hi I understand that once a DB is converted to a MDE, it cant be converted back to MDB. So this is my question. I've completed a DB and converted to MDE. 6 months later i am required to make a change to either the form, or add another module, query, anything. I still have the original MDB but...

Hi all I've created a really neat database for the local school and youth club. I have disabled the shift key method and also use the a bespoke form with user names and passwords for the users to enter – like this: It sits on a server and am worried one of the volunteers would...

Thanks I already have a phone with unlimited text so don't need any sms gateways etc. Just trying to find a way to link the phone numbers from within our Access DB to the phone (connected via Bluetooth) and send.

Hello We run a school and have a mobile phone with unlimited text. We communicate with Parents via text messaging but this is done by using the Nokia PC Suite (and the numbers are stored in the phone) We now have an Access database with all Phone numbers etc. Is it possible to use the...

I run a Homework club and have been asked to design/create an Exam Question Bank. Might be better to explain this using examples. Say GCSE English: The Exam Bank will have 50 questions within. The user requires 10 questions to be printed. The Exam Bank would select 10 random questions and...

Thanks sorted it listbox.listcount

Hi I have an unbound list box that lists the name of students (from a combo box). So if i select Class 2 from the combo box - then it lists all the students in this class on the unbound list box I need to have a count i.e. the total number of students in the class as well. Any idea how to go...

Thanks for helping Bob but i dont understand what you mean. Could i please have some examples? txtLineNumber will have values from 1 to 20 If the value of txtLineNumber is between 4 to 20, i want this label field called lblPos to not appear i.e the visible property to be No Thanks again

Anyone please? There must be someone out there who knows how to do this?

I'm struggling with this. I need to have an expression in my report where it would look at the value of a field, then use the visible YES/NO on a text box. I can do this within a form by using txtbox.value function - but can't seem to do this in my report. Please help...

Just realised that the classes have about 20 kids each. using your example - i can only get 9 children What do you think i should do? Thanks again

Excellent thanks a bunch...

Hi David Yes I totally agree and attempt this in excel. However I'm not sure i understand your comments. >> Personally I would print out a grid from Excel with seat numbers on them. I understand this >> Then I would get plenty of coloured shapes, then working in grids of 9 I would place the...

Thanks Lets say 20 rows of 10, which makes it 200.

Not really sure where to start with this or whether it's easier to do in excel. I have 10+ classes with approx 20 kids in each class. They now have exams and we have sorted the room out I need to be able to plan their seating requirement so kids from the same class are not sitting next to each...

Hi I have 2 queries/reports that work fine. Report 1: Print out student absence details, 1 sheet per student Report 2: Print out Exam results, again 1 sheet per student. I want to be able to print both Reports on 1 sheet. Absence on 1 side and Exam on the other (we have a duplex printer) Is...

Thanks a bunch. I was trying with a & symbol and not the actual work AND. Cheers

I have a simple form that lists all the students, classes, exam results and period. The form can be filtered by class and the after update code is However i would like to introduce another combo for the Period and then filter further using this. How can this be achieved please?