Search results

  1. A

    Retrospective Patient Census

    Hi all, Perhaps someone may help me. We run a database that records patient data for people who are admitted to a critical care unit. We have a staff ratio that allows us to care for 9 patients, but we do have 12 beds, so there are commonly more than 9 patients within the unit. I have been asked...
  2. A

    Action queries that can be run by casual users

    Hi all, I wanted to run a make-table query that can be run by users on a regular basis (at end of month) that will allow users to enter the name of the query themselves (i.e. month name). How can I do this from a user interface, without giving them access to the tables and queries? Any help...
  3. A

    Cut and paste function

    Hi all, I have been looking for this function within these forums, but cannot find it. Basically, I have a form which contains groups of usernames (within subforms) When I want to change a user from one group to another, I would like to use a cut/paste function. What I want to do is : When the...
  4. A

    Gantt-type gaps in data

    Hi all, I hardly know how to explain what I am after, but I will try. I am looking at data that shows when a process starts and when it ends. This relates to ICU patients who have particular types of IV lines inserted. We calculate their overall line days, ignoring the overlaps when they may...
  5. A

    Changes to form design saved automatically after running Macro

    I have Access 2003. I noticed recently that after I ran certain macros within the project that I have created, any changes to form design, query design, code, table design are saved automatically, without a confirmation message popping up. Or I can only do "save as" . :confused: Most annoying...
  6. A

    Getting First/Last Values from a query

    I have a table of data that lists a patient's name, Medical record Number, Admission Date, Laboratory Haemoglobin Value, and the time the test was taken. I want to limit the resuilts in the query to show only the patient's first Laboratory HB (haemoglobin) value, but I cannot get the query to...
Back
Top Bottom