Recent content by Desmond_Fox

Hi, that is exactly what I have got working. If you're interested in doing something similar, here are the steps 1. Using your MySQL interface, create a database. I used a cPanel hosting account which comes with an interface for MySQL. 2. Add a user for that database and create a...

Yes, precisely. Front end on c:\ and connected to MySQL on internet. If there is a problem with that approach or a better way, I'd be very glad for any advice. Des.

Hi, I was hoping someone knowledgeable could advise whether my solution below is the right one. The short version: does using a MySQL back-end (hosted on internet) and Access front end overcome issues of 30+ users accessing/editing the database at same time? The longer version...First some...

[SOLVED - I think] Re: Trying to create a subform that updates a table Hi, I got it to work and learnt a few things along the way. How I got it to work 1. Create a query for each subject (qry_Maths, qry_English). The queries filter the tblComments to just the comments for that subject...

Thanks. I see what you mean about not needing the subjects table. I've removed that now, but still no joy. The issue that remains is that I still need to identify whether a comment is about their english, maths, reading etc. so that I can display a form that shows the students name and a...

Thanks. Every student does every subject (since its primary school), so I figured the subject table only needed to have a list of subjects. If the subject table had a studentID, then the table would then be a list of every studentID for every subject. Is that what I am supposed to do here?

Hi, I've spent many days trying to work this out. I don't even know if I can explain what I'm trying to do clearly, so here goes. Any pointers in the right direction would be wonderful. Here is the set up I have a primary school database. There is a main form that shows the students...

You are totally right. Thanks for your help. I think I have a whole new appreciation for how queries work thanks to you.

Thanks. :D It took me a few days to apply this to my real world example but I finally got there. Your help was awesome. A small thing I figured out is I need the word 'AS' before the word ThisYear. Also, to display the actual result, I needed to use a Last() function. SELECT StudentID...

[Solved] Selecting the latest row for each year Hi, I'm trying to help my local school and I'm having trouble with a simple query. They have an access database with a table like this (simplified for this example): -------------------------------- Name Result Date...

Thanks llkhoutx, I seem to be having some success by creating a temporary table. EDIT: I thought I would expand on this solution to anyone having a similar problem. I made a form with a combo box to select a class of kids a button on the form initiates a query. The query populates a...

Hi, I've been struggling with this challenge for a week. I have a primary school database. I'm trying to create a form that allows a teacher to select their class, then select a subject and then be presented with a data entry form in a table layout that lists only their student's names in one...