Search results

So I'd have to type it in like that each time? No way will the boss go for that. She wants to just type in white and have it do it like Lotus does. We are also unable to search on any field with dlookup in filter by form either. This is why filter by form is just not working for us. But I...

Still not getting a workable search form so making sure we can at least utilize filter by form so we have functionality. Here's my question, is there someway to make it so that filter by form accepts wildcards? I want a search where we enter White to return results of not only White, but also...

Same error after importing to a new shell and even completely recreating a short version of the search form. Feel like I'm really missing something here.

I'm using 2003. I get the very same error, invalid procedure call or argument, but it doesn't highlight anything so there's nothing to fix and run it again. How frustrating.

I clicked on the ellipsis button and let Access do it itself.

Bob, I put the code on the click event of the SEARCH button and I get an error. Invalid procedure call or argument with Private Sub Searchbtn_Click() highlighted. Here is the code I put there: Private Sub Searchbtn_Click() Dim strWhere As String Me.Filter = vbNullString Me.FilterOn =...

That did it! I knew I had the idea right, could not figure out why it wasn't working!! Thanks for the fast response! Elise

Not sure this is where this discussion goes but here it is. I'm using access 2003 on windows xp. Table structure is as follows: StudentInfo: StudentID pk LastName FirstName MI etc Classes: ClassPrefix pk CourseName CreditHours CourseCost etc Grades: ID pk StudentID Semester Year...

Thanks Bob I'll check that out. Yeah I knew storing the info in separate tables was bad, I'm working with an existing database though so re-vamping it as I go. It's a nightmare so far. I think they did that for reporting purposes, related to the other issues I'm having with searches. The...

Thanks Linq, the scrolling really isn't my main issue though :) I'll play with it and try to do it with a combo box I guess since that seems to be what everyone thinks is best. I don't care if I have to use one or not, I just want these other fields to autopopulate, but as of yet no one has...

Still looking for help on this issue if anyone can explain to me about how to open a recordset to get these fields to autopopulate. Hoping someone can help, really hitting a wall on this one. If you need more information from me I'm happy to provide it. Thanks to anyone that responds :)

We currently have in excess of 4k students, each with a unique ID# and record. Maybe I don't understand how combo boxes are more efficient when dealing with a high number of records like this. I keep seeing combo box offered as a solution and truly, I don't get it LOL. I don't understand the...

Using Access 2003. I'm fairly new to coding in Access/VBA, my background is web design not development but I've been thrown headfirst into this project. I have a database of student information. Main form/table is StudentInfo. Also have forms/tables for Enrollment, Classes, Grades etc. I'm...

I've not been able to find out how to code it to work so any help you might give would be much appreciated. Not sure what more info you might need though. I have a main form StudentInfo that has two subforms Enrollment and Grades. I want to be able to do a ctrl+F (already have a macro set...

Thanks for your reply, but as you said read-only won't work for us. I actually solved this particular issue by splitting it into separate forms, we didn't need to have all the information grouped onto just one so now each one is searchable on it's own form and works fine. Still have the issue...

What I need is to be able to search on all fields, in the form and in the two subforms that I have on the main form. So far I've not found a way to do that. Filter by form simply will not search on the subforms. We are fairly well resigned to the fact it's a design flaw in Access (lotus approach...

I am using Access 2003. I have a form containing student information that shows information from more than one table. I know I can create subforms to show some of this information, but the main trouble I have with subforms is that they are not searchable from the main form; I'm having trouble...

The problem I have with filter by form, and I mentioned this in my previous thread, is that we have two subforms linked to the main form which do not become searchable when we use the filter by form. Still need to find a way to make sure the fields in the sub forms are searchable as well when...

So in your example, would this still work on a form? What we need to do is to mimic what Lotus Approach can do by hitting a keystroke, bringing up a blank form that has all the same input fields as our records do, and be able to enter anything into any of the fields and have it search based on...

I have a form set up that has several fields to search from. I created a separate form and included the most searched fields that we use. In the search query for that form, under criteria, I have the following code: Forms!QBF_Form!StudentID Or Forms!QBF_Form!StudentID Is Null also for...