Search results

You would use an unbound text box where the user could enter a value. I couldn't get it figured out so I resorted to a Combobox. It works fine and displays the results needed by either typing the CaseID number (the one I changed from the phone field) or by drilling down through the dropdown...

Sorry about that- I meant CaseID, not ClientID. Thanks for the clarification and for helping me to understand naming doesn't matter to the user- only me. One other question... and this was my original purpose for posting here to begin with; I need to make search form that will pull from either...

I found the places you were talking about and made the changes (I don't quiet understand how they relate (column width seems like it would be relational to size and not affect what is shown) but I will look into it and figure it out. Thanks for the pointer! With both of your help, I now have a...

I will have to go back and look at how that was implemented in your example as I didn't connect all the dots. I was attempting to add a combobox for employees (we call them advocates for this program). Long story short, I got it added using the 2nd method you listed above (additional field in...

We don't need a phone field, but the supervisors will be given cases that have preassigned Case ID's from another system. This Case ID will need to be entered into the database manually and from that point forward stick with the client as that Case ID is how they are known in the other system...

Okay, so if I'm understanding your example and I wanted to add a subform showing assigned case managers, I would need to do the following: 1. Set up a new table (EmployeeTable) with a list of all employees. 1a. In that table I would rename the ID field with the autonumber attribute to...

Thanks a lot! I'll check this out once I get back to the office and see what I can glean from it. Hopefully it will help clear some things up as I know what I need (end result) but I am foggy about how to make an efficient means to that end. This may just be the thing I need to help put 2 and...

Okay, a slight problem I have found. Since renaming everything to get rid of spaces I found that I am getting #Name? in my fields on my "DA_Input_Fields". I found out the problem. It is that I can't pull from more than one table in more than one form. I can use a query for this (but it isn't...

I believe that a "request" is related directly to a case and not a client, correct? Yes. You are correct. You can remove the Client_ID field from the request table, because of the relation Clients->Cases->Requests you'll be able to see which clients are associated with which requests. I...

Yes. Just dates. When you click the field, a calendar will pop up. j razz

When I attempt to change the data type to "AutoNumber" for Client_ID I get this message: "Microsoft Access allows only one AutoNumber field per table." The ID field is AutoNumber. Do I need to just leave the Client_ID as "Number"? These are the little gotchas that make you wonder if you...

Okay, a slight problem I have found. Since renaming everything to get rid of spaces I found that I am getting #Name? in my fields on my "DA_Input_Fields". I tried to figure out how to change this and I went under "Design View" and opened up the Property Sheet and then clicked the drop down...

Okay, I have made the changes to the naming convention, Subdivided my table into three separate tables (Collection Fields is no longer and in its stead I have: Cases, Client, and Requests), and I have established relationships between the three "Client_ID" fields- but I didn't see where in the...

Your description of the Requests leads me to believe that you should have a separate table for those as well, which would be related to the Cases table. Couldn't say for sure though without having a little bit better understanding of the circumstances and the "other things" that take place when...

Are there ever more than 1 clients involved with 1 case. No. Table "client" Fields clientID (primary key) LastName FirstName Table "cases" CaseID (primary key) ClientID (foreign key) CaseOpen CaseClosed So you are recommending that I divide up my one table that has all fields currently in...

Can you give us a bit more information about your general needs for having this database? What type of items are in the collection fields table? Fields are as follows (not many): Client ID (number) First Name Last Name Case Open (Date-Calendar) Case Closed (Date-Calendar) a check box that...

Intro: Hi all, this is my first post here and today is my first day attempting to build a database. I spent a long while doing searches for "search" and "Access 2010" only to later realize that the term must be Query and not Search. So, I don't have a great understanding of the terminology or...