Search results

I don't want to make you do the work, and believe me I've tried all of your suggestions and several more. It doesn't seem to matter what I try, I just don't understand the reasons why I can't grasp this stuff. Nothing I try works, I can't even figure out how to do what I described in my...

Hey there. CHeck out the form called "test" in this DB. It ALMOST does what I want, that is you can see all of the child records as you cycle through the parent records. What I want to do is have a combo box for Patient K Number where a user can select a patient that way. It doesnt seem to...

Bump, Im in a slump

I have decided just to use bound forms now. My Entry form works just fine for new patients. I now need another form to add a new case, or modify an exisitng case (for example to put in an End Date) to an existing patient, I'd also like to be able to cycle through all of the cases for a...

I have ran accross a post that says that unbound forms will not work for parent-child relationships....is this true? http://www.access-programmers.co.uk/forums/showthread.php?t=59582

Ok, here is the addnew code that doesnt seem to work. I've got all of the error messages to stop, but it doesn't seem to be adding anything new to the table. I really suck at this. Can anyone give me a hand? I'm not opposed to using bound forms either. I just am having a hard time getting...

Hi there, I'm still struggling with this. I have uploaded where I am right now. What im working on is the code for the AddNew record button, as an unbound form. It throws me a runtime error when I try and use it, and Im not quite sure why. Any ideas anyone? -Z Ignore this atttachment, I...

Ok, I think I've addressed all suggestions so far. What is next? I require form to enter cases for new patient, and cases for existing patients. I also will need a way to look up (search by name, PatientID, location etc) and edit entries, mostly just to close a case (enter an end_date)...

Ok, let me work on this for a few minutes, and I'll post what I get. -Z

I have read up on normalization, wouldnt adding autonumber fields actually hurt the database ? I thought that normalization was to reduce redundancy in the database. -Z

Thanks Missinglinq, sounds simple, but since I am simple......when you say place a subform control on it, does that mean dragging a "visits form" onto the "patient information" form? Can the "same unique identifying fields" be something like a patient ID number? Or should it be an autonumber...

Here is where I am now. For Kryst51, and anyone else who can help.

Hi there, I have a database with a parent-child relationship. Parent - Patient. Child - Individual visit. How can I create a form that will take user's input and put it into the correct table ? -Z Edit - For example, in the northwinds sample.....if there was a form for customers to use to...

Hmm, strange, when I do that the form fails to yield any results for Jenny, Forrest or Bubba

Thanks, SO you build a query and then pull that into the search form? Any idea how I can limit the results to the most recent "problem". -Z

Well, I'll have the patient name, and I want to use the EndDate field. I'm just wondering how I can get that Record to pop-up, the technicality of it. :) I'm not good at access, but am starting to understand DB design better

Any thoughts on how I have a form display the most recent Case (child record) when I search for a patient name or ID# (master record)?

Yes, although I am trying to brainstorm a good way to "close the case" that will be easy to do and create as little confusion as possible. -Z

Well, I want to have a button for "closing the case" whenever a patient is moved, changes precautions, or leaves the hospital or expires. This button will insert the "now()" date into an EndDate field that I'll use for some total days calculations. I want to leave the EndDate field blank (or...

I understand how to search for patients to see if they are in the database. I'm not sure how to set it up so that I can determine which patients are currently present, any ideas? -Z