Search results

Thanks a million KBalling :) - I ran a query like you suggested, but found that I had too many records returned for some dates (up to 20) and we only have 12 beds. It looks more reasonable now, after I modified the criteria to read only Where DateTbl.Date Between AdmitDate and DischargeDate...

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

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

Hi Wminnette, I used that idea for an update query for much the same purpose as described here - works fantastically well - thanks for a good idea! Anne

Thanks Chris - will give it a try later

Thanks HiTechCoach, I guess that it's the form event that has me snookered! The Cut function did not work when I wanted it to. Does using a global variable overcome this? How would I use it? (I have only very basic coding skills - learning as I go) In this case I have decided to do a less...

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

Thanks very much - will give it a try - I have already configured a procedure based on the code but was unsure how to run it - cheers - Anne

Thanks Gemma, I do understand your logic, as it is exactly the same logic I was trying to apply with a query calculation. I would not be the greatest in the world at coding - I understand the bare-bones of coding - self taught beginner! Do you mean that I should use this code within a form...

Hi Gizmo, See attached excel file with anonymised data. There are some patients who have a few different types of lines with overlap, but there is at least one in there who has a gap (line-free days) Cheers Anne

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

Thanks Bob, I will try that

Cheers Bob, I have a macro in which I have Set Warnings to "Off". Perhaps this causes the same problems? I will try it without that part of the macro. I have not noticed this in earlier editions of Access. Is it a relatively new fault?

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

Cheers Brian, I did what you suggested - it is a logical answer when you see the end result - just couldn't see the wood for the trees! First time using this forum - delighted with the result! Anne

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