Search results for query: *

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

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

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

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

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