Search results for query: *

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...

Ok, thanks Larry. Sherry

Hello Fancy, Yeah!!! That was what it was. It worked just fine. I'll finish up the rest of the buttons and hopefully all will still work. Thanks so very much for your help. Sherry

Can you tell me exactly where I need to look for that? I'm a little confused. Thanks so much. Sherry

Hi Fancy, Ok, I tried that out, but am getting an error. Here is the code: Private Sub EditRecord_Click() Me.AllowEdits = True Me.AllowAdditions = True Me.AllowDeletions = True Children2.Form.AllowEdits = True Children2.Form.AllowAdditions = True...

I have read your post here and set the defaults according to the KB article (208923), etc. This relates to Access2000 and I am running Access97. There is another KB article(120912) for Acc97 - but only half of the article is there (it's very weird). I guess the Find box's are slightly...