Search results

I have further questions about this. Here is my plan: - the database will be split, and housed on network folder 1 - subfolder 1a will contain the data tables - subfolder 1b will contain multiple copies of the front end, which will contain forms and reports - one for each work station (I don't...

Thank you both so much. Yes, I need to change it. Mark, I looked at the database. That was really helpful. Now I understand what it is supposed to look like. In terms of the data returned, it gives us what we want, once I figure out the queries. So, two things: 1) In terms of data entry...

Thanks very much. Ultimately, I need to be able to do the following: on the data entry form, beside each of the 9 status options, display the date (date stamped) when the user clicks on that status. allow the users to modify the date stamped date for each status, right on the data entry...

Thanks so much. Just to clarify - I don't really want to find the latest status only. I need to store all 9 status dates. They each need to be saved, and displayed on the form, and the time spans between each status date will be reported. So, for each patient, I need to be able to create a...

I have been pouring over this for some time, and keep thinking I have found the solution. In my main Patients table, I have: - a single field for patient status code (9 numerical options, entered via a form option group) - 9 separate fields for status date - one for each status (example...

Thank you. And this is why I ask the experts.

Thank you so much for your feedback. I'll look into how to split the database. To answer your question, what I meant to say is that all users will be entering data into forms and viewing reports - some of them on a daily basis. However, none of them will be accessing any data table views...

I am creating a clinic database to store patient information, for multiple users (clinic managers, care providers, clerks). I've noted some background info, and my plans below. Does this sound reasonable, especially in terms of not splitting the database? I want to make sure that I am not...

SOLVED: Relationships - linking reference table field to 2 main table fields I could have sworn I tried that before and it didn't work, but now it did. Many thanks!

My database has staff reference table, listing all the current staff. On my main table, there are 2 separate staff fields - one for the person who did initial contact, and one for the person who later was assigned the case. Both of these fields store numeric data (since they appear on the...

Thank you so much. I think I have found a way to do it that combined everything I`ve learned so far. From what I can tell, an option group is really just a different visual representation of a list box. I can use select case to program a different event for each option. I`ve scrapped the...

Thank you so much. I found an older thread with some code samples, and tried it. It worked. :)

SOLVED: Possible to program different events for option group updates? Hello. My team will be developing a number of databases in the coming months. They may be fairly simple. We have little coding experience, but we are looking things up as needed. I have a question about option groups on...

Thanks very much. 1) I thought that an option group is just another way of viewing a list - as check boxes that can be moved around the screen, rather than a drop-down list that appears in one small space. With the option box, I can still only select a single option. The team really prefers...

I am stuck, probably on some little minor detail ... and another question. #1 I created the continuous patient status subform with the 2 fields: an option group for collecting patient status, which has an After Update event procedure, to date stamp into the pt status date field. I still need...

Thanks so much. I'll give that a try.

I got my database to time stamp my patient status changes, but it isn't creating a time-stamped log all of the changes - it just the most recent time that the field was updated. I need it to log the most recent time each of the 9 options for the status field was selected. I did this: - created...

OK thank you. I think that is what I needed most urgently for now. I would like to share the rest, and I get that I need to show the rest of the fields in order to get additional help. I'll work on queries in the meantime, and on figuring out how to get the time stamp on the page. I really...

OK that actually was pretty quick. Here's the link. It never actually says anywhere "foreign key" (I am working with Access 2007), but I think I did it right. I chose the 3rd join properties option. HCN = PtID. There are many more fields in the Intake Form, obviously, but I don't really...

Thank you so much, plog. I'm working on that. I have only one table right now, so no relationships to speak of. I'll figure it out and post, though it might be later from home. It looks like this will create more of a log with multiple records for each patient, which is a different structure...