Search results for query: *

Actually, it shouldn't be the same name, I've added a chk in front of each, but it's close. Appreciate your help.

Here is the code minus a couple of commented out areas...I hope that the line spacing comes out wide enough....it's pretty confusing when it carries to the next line. The form is basically several input fields with a check box next to each to specify which fields you would like to search by...

Jebry-- Yes, your assumptions are correct. I was trying to limit the ammount of code that I copied to the board to hopefully eliminate any extraneous confusion about the question I was asking. Out of curiousity, what is the difference in placing the single quote (') vs the double quote...

Hello All, I have the following code on a form used to search a table. My goal is that if someone enters any information into the field, it will search for any entry's that contains the entered string. I also want it so that if anyone leaves the field blank, it will return every record. The...

thanks....not it works like it was supposed to---FINALLY!!! Much appreciated- jodym43

Hey guys, I'm not sure what I'm doing wrong, but when I try and run the following code.....I get the following message "compile error: Loop without Do statement". As you can see from the following code, I have a Do statement....but I'm not sure where the problem is. I'd appreciate...

Thanks Kalin...that's exactly what I was looking for. I don't think I would have tried the format that you provided, but it worked beautifully. I appreciate your help.

Thanks. I knew that it had to be something fairly simple, but couldn't come up with anything. Much appreciated!!!

Does anyone know a way to autonumber a list on a report?? I just have a simple report that generates a list of approx 5 - 10 entries. I would like to be able to auto number these entries so the report will look like: 1. first item 2. second item 3. third item .....etc instead of...

Does anyone have a good example for an SQL recordset that uses wildcards in it's WHERE clause, I'm having a hard time getting my syntax correct in doing what I desire. Specifically, I'm trying to select a record set based on the value of a MapCounty field. I want the search to find any record...

Man, do I feel like an idiot. There was a very light-grey line created above the header. Thank you both for your help. Jody

Hey everyone, I have created a report that initially was 22 inches wide. After rearranging items, I only need the report to be approx 7 in wide. When ever I try to drag the right margin to make the report width smaller, it doesn't change. If I try to change the width from the properties...

Exactly......I was trying to get to the point you described, I just didn't know which command I was looking to use. The BeforeInsert wouldn't work for me because I had multiple fields that needed to be filled in for each map, but you pointed me down the right path. I ended up using a...

Got a question that I'm hoping someone can help me with.... I created a DB that tracks projects and maps that are associated with each project. The maps are shown in a subform off of the projects form. I have a separate table (called projects_maps) that simply associates a specific map with a...