Search results

I have a database with a parent table for basic patient information, and a tPatientStatusDates table (data entry via continuous sub-form) which logs, for each patient, the date that they reach each of 6 stati. I'd like to be able to report the wait times between each status type. For example...

Thanks arnelgp. I will try that later. What event does the tempvars code go under?

Thanks arnelgp. I tried it. I don't see any difference though - if the form is already open, and I navigate from the record, the form still only opens to the previous record I was viewing. Any other commands? I also tied on open, and that didn't work. Private Sub Form_Activate() ' when...

Thank you arnelgp! This works, if the form is not already open. However, if the form is already open, and the user clicks on a name on the report, then the command navigates the user to the form, but it doesn't refresh to the record that was just selected from the report. It still displays...

Thanks Mike. The report is currently being used to help identify which records are not updated. So, it helps to just update the records as users scan through the reports.

Thanks so much, Mike. I'm curious, though - why is it best to close the report before opening the form? At this time, the database has many records with incomplete data, so it will actually be really helpful for users to toggle between the report and the form. The report will show them...

My database has a number of reports, and I've programmed it such that people can click on the last name of a patient on any of the reports, to open that patient's record on the form. However, the form is then filtered such that they cannot search for other patients, or move to other records...

Thank you. I have asked the user to try that.

Thank you both. I vaguely get it - printer issues. I'm not very tech-savvy, but I think I will ask the user to perhaps go to the printer settings, and select a PDF writer or something of the sort, and see if that helps. I don't know if they can de-select all printers. I'll see how far we can...

Can anyone tell me why a user would get a "DLL function not found" error, when attempting to export an Access report to Excel? I had no issue exporting this report on my own computer, but another user was not able to on theirs. The DLL error message was preceded by an error message about...

Thanks. Fixed it!

RESOLVED: Form option group - single click selects 3 options I have an option group on my form, and it is supposed to allow only 1 selection. It has 6 options. Three of the options function fine - when I click on any of them, only that 1 option is selected. However, the other 3 options seem...

Thank you both. Ridders - it's more the second option - after logging the status on the subform, the field on the form must then be completed. Actually, it doesn't matter which order they are completed in, but just if one is completed, then the other must also be completed. If I need to force...

I have a database with a form, and a subform. There's a numeric "status" field on the subform, with 6 options. The subform is continuous, and each of the 6 status options may be logged, for each records. Each time one of the 6 stati are logged on the subform, there is a numeric field on the...

Hello again. It's been a while since I posted. The project was on hold for a while, and it's now up and running. The biggest challenge now is getting current patient status. The "tPtStatusDates" table is great. We log changing stati and their associated dates, for multiple patients. I...

OK, so I have worked on it, and the biggest challenge is that that any which way I look at it, the 9 status options, including all the holds, don't fall into nice separate categories that make sense in the real world. I summarized in a way that I think makes the most sense, given the types of...

I am working on a database project (not related to the previous one), to store data on repeatedly completed forms for patients. Each patient comes for multiple visits. Each visit, they complete 2 separate forms. I have set it up in the following way: - tPatientID - stores patient ID info -...

Thank you Mark. I see your point. I am mapping out some tweaks to the table structure. I'm going to tinker with this, preferring the second option you suggested. If I set up the "oranges" categories correctly, and then all the dates end up in the "apples" categories, I think I can produce...

Many thanks to all for this incredibly useful information. I will take this back to the team so that we can plan for this. And yes - one of the downstream steps is definitely to remove some of the functionality so that end users only see the specific forms and reports that they should access...

Thanks. Re: 1 - I am not sure if it a terminal server - will try to figure that out. It's a network folder that the division has access to. The issue is that we want to do this on our own, but only IT has access to actually save anything on their computers. And getting all the staff to...