Search results

second screen shot Here is what I want to show when the form opens

Hi, Rather than have buttons to take me to different forms, I inserted 6 tabs to act as the navigation portion of my main menu. The problem that I am having is that when I view the form, it opens about 3 inches down the page rather than at the top of the form, where the tabs are. I initially...

What elements really add to the physical size of a mdb file? I am working on a pretty extensive database and the file is already up to 56 mb - and I only have 63 records in there! When I am done, I expect to have more queries than anything. I consider myself a knowledgeable newbie who has the...

Jon, Thank you! That example provided a crucial advance in my forms. Not only was it simple to incorporate, it answered my nagging question as to how to get the field to say one thing, but the db understand it as another. The filter works great, and now it is more user friendly! Rather...

Thank you jack! I will try that in the morning when I get to the office. From the sounds of it, I need to code it in sql rather than the query wizard. The explanation looks thorough - I just hope I can follow the directions and make it happen.

another screen shot of query Here is a screenshot from the query design view - to see my syntax

Hi, I have a form that is serving as an advanced search engine for my table. Using combo boxes, I have placed value lists items like *, True, and False. A user would go to this advanced search page and select all of the criteria for their desired records. Leaving the form open - whose text...

Casey: Thank you for the suggestion. I am sure the SQL statement would speed things up and it certainly sounds more efficient. However, that is a little advanced for me at this point. Basing it on a new query was the easiest solution for me at the moment. Dodgeboy: When you make a query, it...

ok, solution Ok, after toying with it some more, I found the easiest of answers. I made the form based on a query - rather than a table. This allowed me to make the query, based on both tables.... I am getting the hang of this stuff slowly but surely.

Hi, I am trying to construct a universal equipment log for a school and their sports teams. I am having difficulty with a form handling data from two tables - essentially a #Name? error. One table holds the item descriptions for a particular team. Like: field: equipment_item_1 value: shirt...