Search results

  1. D

    Am I doing this right? Scaling up database to cope with 35+ users

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

    Trying to create a subform that updates a table

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

    Selecting the latest row for each year

    [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...
  4. D

    How do I create a partially completed datasheet on-the-fly for data entry

    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...
Back
Top Bottom