Search results

  1. M

    Combo box difficulties in selecting record

    Hello all Thanks for any help. See attached file. First I know it's a crap database structure and I am endeavouring to change this. I am not a professional, just trying to set up a small database to help me look after patients. On the "Select Patient" combo box (number 147) I have two...
  2. M

    Form - show by appointment date.

    Hi all I'm sure this is easy but can't figure out a good way to do this (newb - sorry). I have a database of patients I see - I'm sure it's not structured very well but I have been using it for a while now. I have a number of fields for clinic dates (which again I know is not the best way to do...
  3. M

    Max and Min function

    Hello all and thanks again for any help. I'm using this dummy simple table to try and figure out how to performs some queries that I need to use for a large patient database. I need a query to get the max, min and most recent blood result for each patient. There is apparent table where HandC is...
  4. M

    Return without GoSub error

    Hi I have a macro based query that was working fine until recently but now has started returning the error "Return without GoSub". It is a toggle button on a form that OnClick uses following macro. I don't recall making any changes that should cause this error. Any help gratefully appreciated...
  5. M

    Query most recent date and associated field data into form control

    Hello all Any help gratefully appreciated. I'm not an Access professional - just a mere physician trying to setup a regional level database to help care for people with a specific serious rare disorder. I have developed a database with a single large table. These patients have numerous...
  6. M

    Toggle Button in Form and ApplyFilter macro

    Hello all Many thanks for any help offered here. I am sure this is not the right way to do this but this is what I have done so any help gratefully appreciated. I am not a database manager, developer or programmer but a stupid physician grappling with Covid patients and trying to setup a...
Top Bottom