Search results

[No message]

Is it not for me to decide what the "correct answer" is? Additionally, I believe that the spirit of a discussion forum is to support the free flow of knowledge. I know you (and others) don't get paid -- but was that ever the expectation or the founding purpose of this forum. I apologize if I...

I did this because I thought different (valuable) people might look in one forum, but not the other. Additionally, I wasn't sure whether this topic better fit into the "General" forum or the "Tables" forum -- so I decided to put it into both. Is there some operational, organizational, or...

Pat, Specifically, what are the relationships?

I have attached a sample database. If you open tblLocation, you will notice that the ZipCode field has a drop-down list that contains a bunch of ZipCodes (these should autofill if you type in the field). I have populated this list by using the Lookup feature on the ZipCode field in...

I am trying to decide how I should set up the relationships between the following entities: - SPECIALIST - CASE LOAD - AREA. A SPECIALIST is an employee that is responsible for a CASELOAD. Each CASELOAD can belong to only one SPECIALIST at a time, but CASELOADS can be shifted from one...

I am trying to decide how I should set up the relationships between the following entities: - SPECIALIST - CASE LOAD - AREA. A SPECIALIST is an employee that is responsible for a CASELOAD. Each CASELOAD can belong to only one SPECIALIST at a time, but CASELOADS can be shifted from one...

Does anybody have a good strategy/method for creating a way to be able to search for a specific, existing record on a form so that the user can edit it (i.e., rather than having to scroll through a thousand records). All ideas would be appreciated. Thanks! -CoddFish

Does anybody know how to implement nested subforms? I am clueless... Please let me know if you know of a source that explains this, or if you can explain it to me so that I can actually create the thing. Thanks. - CoddFish

Fizzio, I've never worked with nested subforms, but this is exactly what I need to do in this case (i.e., I am interested in solution #1). How would I implement this. I've looked in Access' HELP and in an Access book that I have, but there doesn't appear to be any discussion on this...

A PROVIDER can have one-to-many NEGATIVE LICENSING EVENTS. Each NEGATIVE LICENSING EVENT has negative action(s) filed as: - Denial - Suspension - Injunction - Revocation - Probation and/or - Fine. These negative actions are not mutually exclusive in that each NEGATIVE LICENSING...

OldSoftBoss, I did as you described and it works, with one limitation: I am not able to create a record in the second form; only edit/delete a record that has already been created in the original subform. My intuition tells me that this has something to do with appropriately linking keys, but...

I have a form with a subform. The subform is the typical format with each record displayed horizonatally in a grid. I would like to be able to double-click on a single record to open another form that will display just that record for viewing, and for add/edit/delete. Each record contains two...

This works beautifully! Thanks Calvin!:D -CoddFish

I have a form that contains a combo-box where the user selects an AreaID (the bound PK for tblArea). This primary key is associated with records that contain three other columns of data: County, ZipCode, and FacilityType. There are two text boxes on the same form that I would like to...

I want to create a form where all controls are initially hidden except for a single combo box. I would like to make the other controls visible only after the combo box has been populated. How can I do this? thanks.