Recent content by SherryLynn

Hello, I have tried to search for a solution on this, but haven't found exactly what I'm looking for. Hopefully I am not duplicating this question here. I have a MS Word 2003 document that I have added Option buttons to (Option 1 and Option 2). I need the user to choose one and then...

Thank you Leslie and Pampers. I am going to give this a try and will let you know if I run into any trouble. Sherry

Thank you both for your replies. I have to apologize though for not being more clear in what I needed help with. (It was clear in my head, but not in my writing it - haha). As you suggested Pampers, I would likely set up the tables that way once I have the data in Excel. However, my problem...

Hello all, It's been awhile since I have been here. I am in the process of creating a new DB on information that is coming from Excel. The data is getting converted over to Access permanently. I work for a child protection agency with children who go in and out of foster care. Currently...

Hello JonFer, Ok, I am trying to play around with this and running into a snag (due to my inexperience I'm sure). When you say "create a table that lists the file numbers...", how do you mean create it. Do I create a make table query pulling that field from my original table? If so, will I...

Thanks JonFer. I am going to try that out and let you know how it works. Sherry

Hi Joe, I took a look at this post and am finding your suggesting helpful. I wonder if you (or someone out there) can help me take this a step farther in my database. I want my users to use this type of search to bring up a "subset" of records in a query or form and then select one of those...

Thanks PHV, I will try that out. Yes, normalization would be nice - too bad they didn't create the DB like that. There are over 7000 records on families with multiple fathers, etc. Sherry

Hello, I have a database that has a LastName field. The last name field can contain several last names. Here is how a typical LastName is entered: Smith xx Johnson xx Russell Now, I would like to filter records in the database to pull up say all Johnson files. When I attempt to use the...

Hello, As I described (in my second post), depending on what files are required at the meeting, I choose those files, and each has a unique File#. They are random, based on who might be available to present the case at that particular meeting. I might have 20 files sitting waiting to go to...

PHV, Do you have any ideas on how I can accomplish what I have described in my initial post? Thanks very much! Sherry

Hello, I tried what you suggested, but when I use a comma to separate the file#'s, I don't get any records. If I type in only one file#, then the query works. I am posting the SQL so that maybe someone can help me figure this out. Thanks. SELECT tblFamily.Family, tblFamily.File...

Does anyone have any ideas on a solution to this? All suggestions are much appreciated :-) Thanks, Sherry

I thought maybe I should clarify a little bit. The records I am pulling are to go into an Agenda Report. I might have 30 files on my desk which I would go through. Based on what is needed at the meeting, I would choose say 10 of those files. I would want to be able to "punch in" those ten...

Hello all, I have created a report which I will base on a query. I want to be able to select a number of records based on their File# (not an autonumber field). I would put criteria in the query, but there isn't any specific criteria to use. I will be picking a list of File#'s and there...